We are looking for a way to find out Windows Server Editions for 2008/2012 VMs. Does anyone have a solution to get this information natively with SAM/NPM? The Machine Type field doesn't go into this level of detail for 2008/2012.
I get that info from
SELECT SystemName, OperatingSystem
FROM Orion.AssetInventory.ServerInformation
but only when the node is polled from SNMP not WMI
This information is available for WMI managed nodes through SAM's Asset Inventory.
Where can I pull that from via SWIS variables for reports?
Several reporting methods can be optioned to retrieve the OS Version and Edition.
1) Create a custom table report using SWQL as the selection critera
2) Create a Custom Query Report (Under Misc. Category - web reports)
Table is Orion.AssetInventory.ServerInformation
SWIS Schema for this table;
SolarWinds Information Service v3.0 Schema Documentation
Operating System is also a default field you can add to virtually any node report by default. No SQL or SWQL required.
