计数SKU PR CompanyName在租户中具有多个公司名称-Powershell

Question

（首先，对不起，如果我的英语到处都是一点点，仍然在学习）

，我希望有人对如何执行此操作有任何意见。目前，我在一家拥有Mutiple Companies的租户工作。我希望自动化如何获得SKU的所有公关公司，因为它们是单独收费的

。那有点完成工作。但是，它不计算并为我想要的东西提供最佳的输出。

$Report = [System.Collections.Generic.List[Object]]::new() # Create output file 
$Skus = Get-AzureADSubscribedSku | Select Sku*, ConsumedUnits 
ForEach ($Sku in $Skus) {
    Write-Host "Processing license holders for" $Sku.SkuPartNumber
    $SkuUsers = Get-AzureADUser -All $True | ? { $_.AssignedLicenses -Match $Sku.SkuId }
    ForEach ($User in $SkuUsers) {
        $ReportLine = [PSCustomObject] @{
            User        = $User.DisplayName 
            UPN         = $User.UserPrincipalName
            Companyname = $User.Companyname
            Country     = $User.Country
            SKU         = $Sku.SkuId
            SKUName     = $Sku.SkuPartNumber
        }
        $Report.Add($ReportLine) 
    }
}
$Report | Sort Companyname| Select Companyname, SKU, SKUName | Format-Table 
#or replace Format-Table with Out-GridView for easier reading

正如我所说，这还可以。它并没有真正自动化我想做的事情。经过此操作后，我将不得不计算SKU的公关公司。从下面的输出。

Companyname       SKU                                       SKUName                 
-----------       ---                                       -------                 
company 01        18181a46-0d4e-45cd-891e-60aabd171b4e      STANDARDPACK        
company 01        3b555118-da6a-4418-894f-7df1e2096870      O365_BUSINESS_ESSENTIALS
company 02        3b555118-da6a-4418-894f-7df1e2096870      O365_BUSINESS_ESSENTIALS
company 02        cbdc14ab-d96c-4c30-b9f4-6ada7cdc1d46      SPB                       
company 02        06ebc4ee-1bb5-47dd-8120-11324bc54e06      SPE_E5                  
company 03        cbdc14ab-d96c-4c30-b9f4-6ada7cdc1d46      SPB                     
company 03        cbdc14ab-d96c-4c30-b9f4-6ada7cdc1d46      SPB                     
company 04        cbdc14ab-d96c-4c30-b9f4-6ada7cdc1d46      SPB                     
company 04        a403ebcc-fae0-4ca2-8c8c-7a907fd6c235      POWER_BI_STANDARD
company 04        cbdc14ab-d96c-4c30-b9f4-6ada7cdc1d46      SPB                     
company 04        cbdc14ab-d96c-4c30-b9f4-6ada7cdc1d46      SPB                     
company 04        a403ebcc-fae0-4ca2-8c8c-7a907fd6c235      POWER_BI_STANDARD

我希望woud的输出是下面说明的内容：

Companyname       SKU                                       SKUName                     Amount
-----------       ---                                       -------                     ------
company 01        18181a46-0d4e-45cd-891e-60aabd171b4e      STANDARDPACK                1
company 01        3b555118-da6a-4418-894f-7df1e2096870      O365_BUSINESS_ESSENTIALS    4
company 01        cbdc14ab-d96c-4c30-b9f4-6ada7cdc1d46      SPB                         2
company 02        3b555118-da6a-4418-894f-7df1e2096870      O365_BUSINESS_ESSENTIALS    5
company 02        cbdc14ab-d96c-4c30-b9f4-6ada7cdc1d46      SPB                         2
company 02        06ebc4ee-1bb5-47dd-8120-11324bc54e06      SPE_E5                      3
company 03        cbdc14ab-d96c-4c30-b9f4-6ada7cdc1d46      SPB                         2     
company 04        a403ebcc-fae0-4ca2-8c8c-7a907fd6c235      POWER_BI_STANDARD           2
company 04        cbdc14ab-d96c-4c30-b9f4-6ada7cdc1d46      SPB                         6

我可能只是缺少超级明显的东西，我不确定。但是任何帮助都会非常好。

Answer 1

您可以尝试使用group-object对公司进行组。默认情况下，这会使您计数

❯ $Report | Group-Object -Property companyName

Count Name                      Group
----- ----                      -----
    2 company 01                {@{Companyname=company 01; SKU=18181a46-0d4e-45cd-891e-60aabd171b4e; SKUName=STANDARDP…
    3 company 02                {@{Companyname=company 02; SKU=3b555118-da6a-4418-894f-7df1e2096870; SKUName=O365_BUSI…
    2 company 03                {@{Companyname=company 03; SKU=cbdc14ab-d96c-4c30-b9f4-6ada7cdc1d46; SKUName=SPB}, @{C…
    5 company 04                {@{Companyname=company 04; SKU=cbdc14ab-d96c-4c30-b9f4-6ada7cdc1d46; SKUName=SPB}, @{C…

Answer 2

所以我终于设法做到了！我可能根本不是 做到这一点最多 1337 。但这现在正在起作用。它仍然不是完全自动化的。

因此，我还将发布一个版本，其中我将使用图形等。因为我以后使用此脚本在团队中使用机器人进行skus的日志更改。

但是，这是现在的脚本。 工作。

cls
#console is cleared for easier reading.

#Connects to Azure (you need the azure AD PS module to run this script btw)
#in the ms365 prompt that shows up, login with the tenant admin account.
Connect-AzureAD

#creates a list, and gathers all the info about users and SKU's etc for the tenant.
$Report = [System.Collections.Generic.List[Object]]::new()
$Skus = Get-AzureADSubscribedSku | Select Sku*, ConsumedUnits 

#formatting the table we will use in out output
ForEach ($Sku in $Skus) {
    Write-Host "Processing license holders for" $Sku.SkuPartNumber
    $SkuUsers = Get-AzureADUser -All $True | ? { $_.AssignedLicenses -Match $Sku.SkuId }
    ForEach ($User in $SkuUsers) {
        $ReportLine = [PSCustomObject] @{
            User        = $User.DisplayName 
            UPN         = $User.UserPrincipalName
            Companyname = $User.Companyname
            Country     = $User.Country
            SKU         = $Sku.SkuId
            SKUName     = $Sku.SkuPartNumber
        }
        $Report.Add($ReportLine) 
    }
}

#clearing the console again
cls

$commands = {
    #Collects and creates a small list/table with all companies within the tenant
    $firmaer = $Report | Select-Object Companyname -Unique

    #Prints the list out so you can copy the names correctly into the prompt
    write-host "Below is a list of all available companynames";
    $firmaer | Out-Host #out-host is important here to make sure it gets printed before the funtion below runs.

    #Im just setting the userimput to blank just in case
    $userinput = ""

    #Here we prompt the user for the name of the company within the tenant they want to check against.
    $userinput = Read-Host "Write the NAME of the company you want to look at: ";

    #then we Print the table with only the relevant information for that company
    write-host "Skus for: $userinput"
    $Report | Where-Object Companyname -like $userinput | Group-Object -Property SKU | Select-Object Count, Name, @{Name = 'SKUName' ; expression = { ($_.Group.SKUName) -join ', ' } } | Format-Table

    #then here we have a check if maybe the user wants to check another companyname.
    #if they respond to the prompt with y - then the script will run the commands function again from the start.
    $again = Read-Host "Do you want to check another company [ y / n ]"
    if ($again -eq "y") {
        &$commands
    }
    else { # and if not the script wil end.
        Write-Host "Exited..."    
    }
}

#calling the function.
&$commands 

该脚本将为您列出表格中的所有可用公司名称。然后，您可以检查每个公司的SKUS 1 x 1。

输出将是一个表。

它还询问您是否要在第一次检查后检查另一家公司的广告。

正如我所说，我计划自动化这一点，以贯穿您合作的所有公司或其他公司。

我希望这可以帮助其他人同样。