cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

Office 365 Licencing Reports

Submitted by Anonymous on โ€Ž01-19-2017 02:49 PM

Hey all,

 

I'd love to be able to create a flow so that when I get an email that the Microsoft subscription has changed that it would then run a PowerShell script (or something similar) to send me an updated user and license report from Office 365. And ideas if this is possible or already been done?

 

Thoughts? 

Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
SteveH
Regular Visitor
โ€Ž06-09-2017 06:54 AM

We have a similar 'need'. We're a multi-forest, multi-hybrid tenant with different companies on them.

This means we have to redistribute the monthly cost to the correct companies.

Right now I use a PS script that creates a csv file with employee's name, first name, e-mail address, company and AccountSKUID. THe file then requires some modifications so be legible and usable for accounting.

Would be great if I can automate the creation of that file on a schedule. The csv can then be re-used in PowerBI.

Currently the action I see for Office365 and Azure AD do not include the AccountSKUID attribute nor can you have Flow create a dump of all users, you can only get your own profile or that of a specific user.

 

KR

Steve