How do I get the true availability report of the SCOM agents based on the ping or uptime or any other parameter?

I have pull the monthly availability report for all the SCOM agents. wherever I pull the standard availability report , I am getting the incorrect data.if the agent is critical , SCOM is marking it as down even though server is up and running.

I need the true availability report.I need the report that is based on the pings or up time or any other parameter , that can give right availability

Pretty old article, but fairly accurate: https://tickets.squaredup.com/support/solutions/articles/207849-how-to-create-an-availability-report-in-scom-for-troubleshooting-sla-dashboards - Does this solve the issue for you? - The agent is not the best target if I recall correctly, as this has monitors that will be critical for a number of things.

I want the report as available even though the agent is in critical .