I am running the query on this page to get user data.
What it does not give me is the list of all people who are using a license but have never logged in. What I want is, for all license holders show me when they logged in last, and null if never logged in.
Can anyone please help with that?
On this page you will find a query to get all licensed users. The query does not contain te last login information but you can adapt the query to include it. You'll need to join the cwd_user_attributes table like it's done on the page you linked.
For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events