How to collect custom inventory from Azure AD Joined devices

Use this powershell script and deploy it using intune.

Function Get-SystemSpecs { 
$processorSpecs = Get-CimInstance win32_processor 
$processorName = $processorSpecs.Name 
$processorSpeed = [string]([math]::round(($processorSpecs.CurrentClockSpeed /1000),2)) + 'ghz' 
$processorCores = $processorSpecs.NumberOfCores 
$processorThreads = $processorSpecs.ThreadCount 
$ramTotal = "{0:N2}" -f (((Get-CimInstance CIM_PhysicalMemory | select -ExpandProperty Capacity) | measure -Sum).sum /1gb )
	
	Function Get-RAMDetails	{
    $RAM = Get-CimInstance CIM_PhysicalMemory | where {$_.CreationClassName -like "Win32_PhysicalMemory"}
	$RAM = $RAM | ForEach{ $_.DeviceLocator + ": " + ($_.Capacity / 1GB) + "GB, " + ($(if ($RAM.SMBIOSMemoryType -eq "24"){"DDR3-"} ElseIf ($RAM.SMBIOSMemoryType -eq "26"){"DDR4-"} ElseIf ($RAM.SMBIOSMemoryType -eq "34"){"DDR5-"} Else {"Unknown-"}))  + $_.ConfiguredClockSpeed + "MHz" + " (" + $_.Manufacturer +")"} 
	If ($RAM.Count -gt 1) { $RAM = [String]::Join(", ",$RAM)}
	Return $RAM
} 

Function Get-HDDDetails { 
	$HDD = Get-CimInstance Win32_DiskDrive | where {$_.MediaType -like "Fixed*"} 
	$HDD = $HDD | ForEach{ $_.caption + ", Capacity: " + [math]::round(($_.Size / 1GB),'2') + "GB" } 
	If ($HDD.Count -gt 1) { $HDD = [String]::Join(", ",$HDD)}
	Return $HDD
}

$Specs = @{ 
	'ComputerName' = $env:ComputerName
	'Processor' = $processorName 
	'Cores' = $processorCores 
	'ThreadCount' = $processorThreads 
	'ProcessorClockSpeed' = $processorSpeed 
	'Physical Memory Size' = $ramTotal + ' GB' 
	'Memory chip(s)' = Get-RAMDetails
	'System Type' = Get-CimInstance win32_operatingsystem | select -ExpandProperty OSArchitecture 
	'Hard Drive(s)' = Get-HDDDetails 
	'Serial' = Get-CimInstance win32_bios | select -expandproperty serialnumber 
	'OS' = Get-CimInstance win32_operatingsystem | select -expandproperty caption 
    }
    Return $Specs 
} 

Get-SystemSpecs | ConvertTo-Json -Compress

Then use this graph api script to pull the hardware details returned by the powershell script.

# Set the required variables
$tenantId = "<Your Tenant ID>"
$clientId = "<Your Client ID>"
$clientSecret = "<Your Client Secret>"
$ScriptGUID = "<Your Script GUID>"
$URL = "https://graph.microsoft.com/beta/deviceManagement/deviceManagementScripts/$ScriptGUID/deviceRunStates?`$expand=managedDevice"

# Authenticate and get an access token
$body = @{
    Grant_Type    = "client_credentials"
    Scope         = "https://graph.microsoft.com/.default"
    Client_Id     = $clientId
    Client_Secret = $clientSecret
}

$tokenResponse = Invoke-RestMethod -Uri "https://login.microsoftonline.com/$tenantId/oauth2/v2.0/token" -Method Post -ContentType "application/x-www-form-urlencoded" -Body $body
$accessToken = $tokenResponse.access_token

# Retrieve the data from the specified endpoint
$headers = @{
    Authorization = "Bearer $accessToken"
    'Content-Type' = "application/json"
}

$response = Invoke-RestMethod -Uri $URL -Headers $headers -Method Get
$deviceRunStates = $response.value

# Prepare an array to hold the final data
$finalData = @()

foreach ($deviceRunState in $deviceRunStates) {
    $resultMessage = $deviceRunState.resultMessage | convertFrom-Json

    $finalData += [PSCustomObject]@{
        ComputerName      = $resultMessage.ComputerName
        Processor         = $resultMessage.Processor
        Cores             = $resultMessage.Cores
        ThreadCount       = $resultMessage.ThreadCount
        ProcessorClockSpeed = $resultMessage.ProcessorClockSpeed
        RamTotal          = $resultMessage.'Physical Memory Size'
        RamDetails        = $resultMessage.'Memory chip(s)'
        SystemType        = $resultMessage.'System Type'
        HardDriveDetails  = $resultMessage.'Hard Drive(s)'
        OS                = $resultMessage.OS
        Serial            = $resultMessage.Serial
        RunState          = $deviceRunState.runState
        ErrorCode         = $deviceRunState.errorCode
        ErrorDescription  = $deviceRunState.errorDescription
        LastStateUpdateDateTime = $deviceRunState.lastStateUpdateDateTime
    }
}

# Export the data to a CSV file
$finalData | Export-Csv -Path "C:\temp\IntuneDeviceRunStates.csv" -NoTypeInformation

Hey, this was working before but not anymore. how to make it work again? thanks.

Thanks, this seems to be much more effective than using the Graph API's native requests for hardware info.

Hello,

I get this result, here is the sample:

and after that I get resultMessage but not able to work with this list of strings(it is not valid json output):

{"ComputerName":"name1","RAM(GB)":16,"CPU":"Intel(R) Core(TM) i7-9850H CPU @ 2.60GHz","Model":"Latitude 5501","SerialNumber":"serial1"}
{"ComputerName":"name2","RAM(GB)":16,"CPU":"Intel(R) Core(TM) i7-10510U CPU @ 1.80GHz","Model":"HP EliteBook 850 G7","SerialNumber":"serial2"}
{"ComputerName":"name3","RAM(GB)":16,"CPU":"Intel(R) Core(TM) i7-8850H CPU @ 2.60GHz","Model":"Latitude 5591","SerialNumber":"serial3"}
{"ComputerName":"name4","RAM(GB)":16,"CPU":"Intel(R) Core(TM) i7-8850H CPU @ 2.60GHz","Model":"Latitude 5591","SerialNumber":"serial4"}
{"ComputerName":"name5","RAM(GB)":32,"CPU":"Intel(R) Core(TM) i7-10850H CPU @ 2.70GHz","Model":"Latitude 5511","SerialNumber":"serial5"}

$resultMessage is returning a blank value in my case.

kubidag Yes, I did look at $resultMessage without convertfrom-json, but there are a lot of resultmessages (over 4000). I

instead used convertfrom-csv. With some help of find/replace in Excel I was able to read the report in the end. In this process I noticed that some resultmessages were in a different format, then expected. I believe this was causing the error message to do the output to json. Converting to CSV i was able to quickly get the necessary report.

umeshkumarchauhan Do you see any results in the MEM portal for "Device Status"?

tjmklaver I wonder if some device reported non JSON output. Did you take a look at $resultMessage alone without convertFrom-Json?

Great post, I have used the following script to collect W10 activation information from over 6000 devices. 

$COMPUTER=Get-CimInstance Win32_Computersystem
$BIOS=Get-CimInstance Win32_BIOS
$SLP=Get-CimInstance SoftwareLicensingProduct -Filter "Name like 'Windows%'" | where { $_.PartialProductKey }
$SLS=Get-CimInstance SoftwareLicensingService

$theThingIActuallyWant = New-Object psobject -Property @{
SystemName = $COMPUTER.Name
Manufacturer = $COMPUTER.manufacturer
Model=$COMPUTER.Model
SystemSKUNumber=$COMPUTER.SystemSKUNumber
Serialnumber=$BIOS.SerialNumber
ProductKeyChannel=$SLP.ProductKeyChannel
LicenseFamily=$SLP.LicenseFamily
PartialProductKey=$SLP.PartialProductKey
LicenseStatus=$SLP.LicenseStatus
OA3xOriginalProductKey=$SLS.OA3xOriginalProductKey
}

$theThingIActuallyWant | ConvertTo-Json -Compress

When I query the Graph Explorer I get the correct output, but I cannot convert back to json using the command convertfrom-json. 

I receive the following error message: 

At line:1 char:38
+ $objResultMessage = $resultMessage | ConvertFrom-Json
+ ~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [ConvertFrom-Json], ArgumentException
+ FullyQualifiedErrorId : System.ArgumentException,Microsoft.PowerShell.Commands.ConvertFromJsonCommand

YEs MikeGriz , I have replaced the Script ID then only i have run this. Kindly suggest. Your article is very helpful.