SCCM GUI

1. Navigate to Monitoring > Overview > Reporting > Reports > Asset Intelligence. This lists the various reports available.
2. Click Hardware 01A - Summary of computers in a specific collection.
3. Select the collection for which you want to generate the report.
4. Click Run.

Enter Powershell

[String]$CollectionID = "CollectionID" #replace with the CollectionID that you want to generate the report for
 [String]$SiteCode = "SiteCode" #This is the site code for the SCCM
 [String]$Outfile= "C:\Pythian\Servers-Running SQL-Servers.csv" #Location where you want to drop the file.
 $delimiter = ',' 
 
 Import-Module "$($ENV:SMS_ADMIN_UI_PATH)\..\ConfigurationManager.psd1"
 
 Set-Location "$SiteCode`:"
 
 $Servers = Get-CMCollectionMember -CollectionId $CollectionID | Select-Object Name,Status,DeviceOS,DeviceOSBuild,IsVirtualMachine,IsActive,LastActiveTime,IsDecommissioned,SerialNumber,MACAddress,CNLastOnlineTime,CoManaged
 
 $Servers | ConvertTo-Csv -Delimiter $delimiter -NoTypeInformation | out-file $Outfile -encoding ascii