SQL query that would give the same or mostly the same results as the Export-SCOMEffectiveMonitoringConf iguration

Is there a view pre built for this, I've looked but I don't see anything that looks like its the equivalent.  So if not has anybody created an sql query that will do it? 

this simple query is almost enough

SELECT distinct Path,DisplayName

        FROM [OperationsManager].[dbo].[BaseManagedEntity]

  where  path like 'servername%' and name <>''   

but I'd like to have it show what the parameters are for a given monitor, I know that I can go to the raw tables  but I can find which tables to use for any unions I need to create, if somebody just wants to give me table names to work with that would be great. 

September 3rd, 2015 4:03pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics