I would to understand the usage behaviour of JIra users in my organization.
Please suggest how the following information can be retrieved from the jira database using queries and if its possible to do so in the first place.
See, that's still not clear. You have not defined "usage" just repeated the same vague question. You need to be precise about what you're looking for.
"Creating filter" is one clear metric. "Frequency of usage" is still too vague. Do you mean when people visit it in the issue navigator? Excel? Use it in a Jelly script? Subscriptions? Dashboard gadgets? Reports? Agile boards? Do you mean actual times they visit something using a filter, or just where it's configured to be used?
You've got similar problems with the other three items on your list - the definition of "usage" is too vague to be able to form an answer.
@Jack Graves [AC] first caught our eye with his incredible breakdown of what, in his opinion, can make or break a Jira software implementation. (Read his thoughts on this thread)! In this follow...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs