Reporting - The Users, Groups, and sign-in history report

*** Please note, this article refers to Reporting and Analytics with Power BI. View the FAQ for more details. ***

In this article, we'll explore the Users, Groups, and Sign-in History report. Packed with practical insights that can make a big difference, it's the LMS housekeeping tool you didn't know you needed! The report shows:

• How many starters and leavers you had over the last year
• How many people are signing in to Learn
• Keep on top of your Learn site administration by drilling into key metrics on the dashboard
• Users and their LMS role, so you can check that people have the right level of administrative access 
• Groups that do not have a manager assigned

View the FAQ section to see examples of how this report can be used.

Watch the video below to find out more:

In this video, Dot from Customer Success walks through the report and identifies key uses. Whether you're doing a full site audit or just want to stay on top of your admin tasks, this is a great place to start.

Important things to know about this report 

The report is dashboard-driven with interactive metrics designed to let you focus on the data that matters most. Some key things to know about the report:

• The report does not contain any learning history data
• There is a data export limit of 150,000 rows

FAQ

How can I see a list of Users who have not signed in?

1. Open the Fixed report Users, Groups and Sign-in history 
2. In the 'People panel', select View:
3. Select the edge of the table. This will make available as filters, all the data fields contained in the report
4. Select the filter Days since user last sign in
5. Select Advanced Filtering
6. Select is blank:
7. Select Apply filter. The table will be filtered to show only Users with with a blank entry in the 'Days since user last sign-in' will now show in the table
8. Export the data, if necessary.

How often does the reports database refresh?

• The report database refresh twice a day
• A time stamp showing the most recent database refresh is shown in every fixed report
• The 'database refresh' time stamp can also be added to a user-created report
• Each Dataset is refreshed individually, so the time stamp may differ between reports using different Datasets
• Where a fixed report and a user-created report are built using the same dataset, the time stamp will be the same

Discover more about the Fixed reports

Want to get the most out of Fixed Reports? Our step-by-step guides cover the top queries on compliance and Event management, helping you use Fixed Reports effectively while learning key techniques along the way.

When you're ready to explore further, view Key techniques for using the Fixed reports in which Gary walks through real-world use cases.

Need quick answers? Check out FAQ, Reporting and Analytics with Power BI, packed with over 100 common questions and links to in-depth resources. You can also join our regular Ask Me Anything: Reporting live events - come along and ask your question directly to our panel of experts. 

Don't have your Academy account yet? Contact your Customer Experience Manager or the Support Team to sign up today.