n SCOM 2012R2 I had a Custom Server Availability Monthly Report created which used Health Service Watcher.
This was not ideal as when the server was in Critical state the Report showed the Server as Down. In SCOM 2019, I want to create a similar Report but want to use ICMP Ping. I have multiple sites so each site is using its own Gateway.
Using SCOM’s Network Management, i have created discovery Rules using each Gateway and Management Server as Network Discovery Servers.
Need advice on how to create Server/Node Availability Reports from each of these Discovery Servers.
I need the availability of the whole environment rather than the individual server/node availability.
-
SCOM collects Data on all individual Servers/Node so i will need a SQL query to SUM up this Data and Calculate and present a UP and Down percentage in a pie chart etc.
-
Does anyone have a query already for this or pass me one that I can use?
-
Can I use SCOM’s SLA Reporting for this Reporting?
-
What can I use as Targets for this type of Reports?
This is a current ICMP Ping Report for a node:
This is what my Custom Availability Report looked like:
Can I use SCOM’s SLA Reporting for this:
Any assistance will be highly appreciated.