I work for an organisation that has roughly 400 remote sites, each with a server, router and one of three databases installed on the server. These are all monitored by SAM (Server by WMI, router by ICMP and database as an application).
Each site has it's own group with the server and router added within it
I am trying to build a report that would show the "up time" of these three services. Ideally, the report would show the Group Name (which corresponds to the site), and then underneath that name it shows the Server, Router and Application up-time. As far as i can see, the availability report builtin to SAM doesn't reflect if the server was up, but the router was down. It'll just show both as being down.
The report presumably would need to show the availability of the router (as it's just ping), whether the LastBoot time of the server is within the last ** days, and then whether the application had any events triggered during that time-frame.
Is this currently possible with the defaults in SAM, or if not, how would i go about building the report in Report Writer?
Any help appreciated, hopefully the above makes some sense...
