Share via

Need a query for operating system inventory

Brian W 126 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.
955 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Simon Ren-MSFT 33,226 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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.