How to use Atlassian analytics to generate weekly reports of license utilization

[darshan_s1]

Hi Guys,

I have used the below query in a chart in my dashboard, and I have got an output as attached in screenshot.
I want to know whether it's possible to have the same query give me the license count of my org based on the products - that is Jira, Confluence and JSM

SELECT

  account_status,

  COUNT(account_status) AS account_count

FROM

  account

WHERE

  account_status IN ('active', 'inactive')

GROUP BY

  account_status

ORDER BY

  account_count DESC;

[Robert]

Hi @darshan_s1,

User product access is not currently available in the data lake. We do, however, have a feature request to track this available here: 

• ANALYTICS-340: Add user product access data

I recommend voting for it and adding yourself as a watcher to get updates down the road. 

Hope this helps!