Powershell and license help

gurujyotsinghjolly5544 · 2021-06-03T16:47:03.000Z

Hello Everyone

Hope you all are safe!!

I need help on Powershell

I am trying to get output for all licenses usage with below PS command

$customformat = @{expr={$_.AccountSkuID};label="AccountSkuId"},

@{expr={$_.ActiveUnits};label="Total"},

@{expr={$_.ConsumedUnits};label="Assigned"},

@{expr={$_.activeunits-$_.consumedunits};label="Unassigned"},

@{expr={$_.WarningUnits};label="Warning"},

@{expr={($_.WarningUnits)-($_.ConsumedUnits)};label="Remaining"}

Get-MsolAccountSku | Sort-Object activeunits -desc | Select-Object $customformat

I do get the output but with the "'MichealinnGroup:DESKLESSPACK_YAMMER'" format

Then I tried to use array:

  $accountskuid = @{
      'MichealinnGrupp:STANDARDPACK'                   = 'Office 365 Plan E1'
      'MichealinnGrupp:STANDARDWOFFPACK'               = 'Office 365 Plan E2'
      'MichealinnGruppENTERPRISEPACK'                 = 'Office 365 Plan E3'
      'MichealinnGrupp:ENTERPRISEWITHSCAL'             = 'Office 365 Plan E4'
      'MichealinnGroppDESKLESSPACK'                   = 'Office 365 Plan F1'
      'MichealinnGrupp:DESKLESSPACK_YAMMER'             = 'Office 365 Plan F1 with Yammer'
    }

But I am unable to get the appropriate results.

Can someone please help me :-(???

@spiceuser-6pek2

Neally · 2021-06-03T16:56:51.000Z

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don't say "Need help" or "PowerShell Help", actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy, past…

Neally · 2021-06-03T17:00:12.000Z

thesmiilingguru:

I am unable to get the appropriate results.

How exactly do you want it to look like?

you obviously know how to pull the licenses.

Get-MsolAccountSku

Neally · 2021-06-03T17:13:00.000Z

like so?

$prop = 
@{n="AccountSkuId";e={$_.AccountSkuID}},
@{n="Total";       e={$_.ActiveUnits}},
@{n="Assigned";    e={$_.ConsumedUnits}},
@{n="Unassigned";  e={$_.activeunits-$_.consumedunits}},
@{n="Warning";     e={$_.WarningUnits}},
@{n="Remaining";   e={($_.WarningUnits)-($_.ConsumedUnits)}}

Get-MsolAccountSku | 
Sort-Object activeunits -Descending |
select-object $prop # | format-table -autosize

AccountSkuId                Total Assigned Unassigned Warning Remaining
------------                ----- -------- ---------- ------- ---------
dersystest:DEVELOPERPACK_E5    25       17          8       0       -17

gurujyotsinghjolly5544 · 2021-06-04T04:24:53.000Z

Hello @alexw

thank you so much my friend for your response.

What i want it

AccountSkuId                Total Assigned Unassigned Warning Remaining
------------                ----- -------- ---------- ------- ---------
__*Office 365 E5*__               25       17          8       0       -17

Instead of

AccountSkuId                Total Assigned Unassigned Warning Remaining
------------                ----- -------- ---------- ------- ---------
dersystest:DEVELOPERPACK_E5    25       17          8       0       -17

Neally · 2021-06-04T04:42:22.000Z

how about like so

$skuHash = 
@{
    'MichealinnGrupp:STANDARDPACK'        = 'Office 365 Plan E1'
    'MichealinnGrupp:STANDARDWOFFPACK'    = 'Office 365 Plan E2'
    'MichealinnGruppENTERPRISEPACK'       = 'Office 365 Plan E3'
    'MichealinnGrupp:ENTERPRISEWITHSCAL'  = 'Office 365 Plan E4'
    'MichealinnGroppDESKLESSPACK'         = 'Office 365 Plan F1'
    'MichealinnGrupp:DESKLESSPACK_YAMMER' = 'Office 365 Plan F1 with Yammer'
}

$prop = 
@{n="AccountSkuId";e={$skuHash[$_.AccountSkuID]}},
@{n="Total";       e={$_.ActiveUnits}},
@{n="Assigned";    e={$_.ConsumedUnits}},
@{n="Unassigned";  e={$_.activeunits-$_.consumedunits}},
@{n="Warning";     e={$_.WarningUnits}},
@{n="Remaining";   e={($_.WarningUnits)-($_.ConsumedUnits)}}

Get-MsolAccountSku | 
Sort-Object activeunits -Descending |
select-object $prop

gurujyotsinghjolly5544 · 2021-06-06T06:03:29.000Z

@alexw

YOU ARE THE BEST!!!

YOU ARE AWESOME!!!

IT WORKED !! THANK YOU SO MUCH