View only one reseller licence with Get-MsolAccountSku

%3CLINGO-SUB%20id%3D%22lingo-sub-1480443%22%20slang%3D%22en-US%22%3EView%20only%20one%20reseller%20licence%20with%20Get-MsolAccountSku%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1480443%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3EI%20work%20for%20an%20MSP%2FO365%20reseller%2C%20and%20every%20so%20often%20we%20do%20a%20licence%20audit%20to%20check%20that%20our%20clients%20aren't%20being%20over%2Funderbilled%20for%20licences.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20created%20a%20powershell%20script%20which%20will%20get%20all%20of%20the%20licences%20assigned%20to%20a%20tenant%2C%20and%20how%20many%20are%20in%20use%2C%20but%20we%20have%20an%20issue%20where%20they%20might%20buy%20licences%20off%20multiple%20resellers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BGet-MsolAccountSku%20will%20give%20me%20the%20total%20number%20of%20licences%20a%20tenant%20has%20across%20all%20resellers%2C%20so%20when%20we%20match%20that%20against%20our%20records%2C%20it%20looks%20like%20tenants%20are%20being%20underbilled%20by%2020%20or%2030%20licences%2C%20which%20makes%20people%20nervous...%20So%20is%20there%20a%20way%20of%20filtering%20it%20by%20who%20they%20buy%20the%20licences%20from%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1480443%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%20center%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%20Administration%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Hi All,

I work for an MSP/O365 reseller, and every so often we do a licence audit to check that our clients aren't being over/underbilled for licences.

 

I've created a powershell script which will get all of the licences assigned to a tenant, and how many are in use, but we have an issue where they might buy licences off multiple resellers.

 

 Get-MsolAccountSku will give me the total number of licences a tenant has across all resellers, so when we match that against our records, it looks like tenants are being underbilled by 20 or 30 licences, which makes people nervous... So is there a way of filtering it by who they buy the licences from? 

2 Replies
Highlighted

Not via PowerShell afaik, but you should see separate bundles in the admin portal UI.

Highlighted
That’s true, but then means someone has to go back and check once the script has run - ideally it would be nice to be able to set it off and get results without having to go back through manually.