Q: I want a list of all my Windows 2008 Computers in SCOM. How can I achieve this easily?
A: In My Workspace, create a state view. Give it a name, and for the Object class, choose Windows Server 2008 Computer:
Right click the view – and personalize it to only show the data you want to see. Then perform a CTRL+A and a CTRL+C to copy the data to your clipboard.
Paste this in Excel.
Quick. Dirty. No PowerShell required.
Oh, did you mention dirty PowerShell? Here is a one-liner to accomplish the same result, and output to a CSV:
get-scomclass -name Microsoft.Windows.Server.2008.Computer | Get-SCOMClassInstance | select Displayname, “[Microsoft.Windows.Computer`].NetBIOSCOmputername, “[Microsoft.Windows.Computer`].NetBIOSDomainName, “[Microsoft.Windows.Computer`].OrganizationalUnit | Export-csv c:\bin\output.csv
get-scomclass -name Microsoft.Windows.Server.2008.Computer | Get-SCOMClassInstance | select Displayname, ``[Microsoft.Windows.Computer`].NetBIOSCOmputername, ``[Microsoft.Windows.Computer`].NetBIOSDomainName, ``[Microsoft.Windows.Computer`].OrganizationalUnit | Export-csv c:\bin\output.csv