View who has logged into Dynamics 365 - across many environments
A licencing requirement was raised at work this week where we needed to know who out of our Dynamics 365 CRM users were actually using the application. These licences are really expensive and having many of them unused would cost the company lots of money over the year. We did think of looking at audit tables in CRM, but unfortunately this wasn't an option due to the fact we have many Dynamics 365 environments. A single licence will allow you access (if you have permission) to access as many sandbox environments as you wish. This would mean collating data from many environments into one dataset. We needed something more overarching. So I reviewed Azure AD to see if I could view signins for a particular application and low and behold I could see all logins to Dynamics CRM Online. All we would is visit this page, add the filters and download a CSV file. The resultant CSV file would then need filtering to remove duplicate users, because we don't care about when and how