A SQL query to SCOM DB to get an info about LAN Topology

Андрій Верещака 181 Reputation points
2021-11-24T12:36:34.49+00:00

Hi !

We have monitored our company LAN by SCOM. Basically we may see the LAN topology at a "Network Vicinity" Dashboard in a SCOM Console. We have a problem that not all of LAN administrators haven't been granted to use SCOM console , but some of them have to see the topology . So we decided to get the info about topology and network relations from the Operational DB, and then take it into Grafana.
But after some days of digging we completely stuck to the wall.

My questions are -

1 is there some info about SCOM DB, tables, relationships or so ? AFAIS there is a literally magical document about queries to SCCM DB to obtain a different info from there, so that I suppose presence of a similar document for SCOM. Am I right ? Is there something about ?
2. Help me out please to find a right table or a view which provides an info about network vicinity.

Operations Manager
Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,419 questions
0 comments No comments
{count} votes