Hey everyone! I'm looking for some help with scripting in PowerShell. I need to check the usage of Microsoft Visio and Power Apps in our Microsoft 365 tenant for users who have licenses for these applications. Specifically, I'm interested in creating a CSV file that includes the user's display name or email address if they have a license for either product. Additionally, I want to know the last usage date for those apps, but only if it's older than 30 days or if it's never been used (null).
I have Visio Plan 2 and Power Apps Premium in use. Even though I've searched online and played around with tools like Gemini, I'm struggling to find a working script. The usual APIs like "getVisioUserDetail" or "GetMgReportOffice365ActiveUserDetail" haven't returned the information I need, and it feels like Microsoft's API support for tracking these apps is pretty limited. I'd love any help you can offer so I can automate this process and have the data emailed to my manager at the end of the month. Thanks in advance!
3 Answers
You might be on the right track! While that method works, there is actually an OData API endpoint where you can retrieve such reports. It's a bit complex, but if you try this endpoint: https://reports.office.com/pbi/v1.0/, you might be able to extract the info you need. Additionally, there's a Microsoft Knowledge Base article that could help you navigate through the reporting APIs. Here's the link: https://learn.microsoft.com/en-us/microsoft-365/admin/usage-analytics/customize-reports?view=o365-worldwide#use-the-reporting-apis. Good luck!
You might want to check GitHub to see if any script libraries have what you're looking for. Libraries like admindroid or O365reports could have something already developed that might save you some time.
From what I know, there isn't a direct API that gives you the data you're looking for. Your best bet is to check the Admin Center under Reports > Usage > Visio. It provides some data, but it might not be exactly what you want, especially for automation purposes.
Related Questions
How To: Running Codex CLI on Windows with Azure OpenAI
Set Wordpress Featured Image Using Javascript
How To Fix PHP Random Being The Same
Why no WebP Support with Wordpress
Replace Wordpress Cron With Linux Cron
Customize Yoast Canonical URL Programmatically