Need a query for operating system inventory

Brian W 26 Reputation points
2023-03-06T14:39:09.4633333+00:00

I'm in the middle of a MS audit and the auditors are asking for inventory information from SCOM. Is there a SQL query I can run to get the below information from SCOM. It's available from the "Windows Server Operating System" view, but I have too many agents to copy that from the console into excel.

• Machine Name

• Operating System (Version and Edition)

• Logical Processor Count

Microsoft System Center
Microsoft System Center
A suite of Microsoft systems management products that offer solutions for managing datacenter resources, private clouds, and client devices.
599 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Simon Ren-MSFT 23,051 Reputation points Microsoft Vendor
    2023-03-08T06:24:40.2566667+00:00

    Hi,

    Thank you for posting in Microsoft Q&A forum.

    Do you also have SCCM installed? If yes, you could refer to the built-in report:

    SCCM Operating system report

    Thanks for your time. Have a nice day!

    Best regards,

    Simon

    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.