For SCOM how can we fetch the data of the devices configured?

Question

We would like to fetch device (instance properties) data from SCOM.

We have explored various approaches, such as:

1. Pulling data directly from the database (documentation not found).
2. Using PowerShell commands.
3. Accessing REST endpoints.

Could you please advise if there is a preferred method to fetch the required data?

Answer 1

Hi,

What specific properties are you looking to fetch?

• Pulling data directly from the database (documentation not found).

Direct queries to the SCOM database, despite its complexity and potential risks, provide access to raw data.

We can utilize the following query to dig the database.

select * from MTV_Computer

select * from INFORMATION_SCHEMA.TABLES 
where TABLE_NAME like '%computer%' 

select * from INFORMATION_SCHEMA.COLUMNS 
where COLUMN_NAME like '%mac%'

https://kevinholman.com/2016/11/11/scom-sql-queries/