I want to create a report preferably with SQL that will show the underling availability of the nodes in a business service and then report SLA compliance based on the use of SAM templates over a monthly period with a total availability column that is an average of the service availability. I can do some this using two different web reports but I want them aggregated into one, any ideas?
Business Service 1.0 Node Availability
Business Service 1.0 SLA 1.1 Service Availability
Nodes Availability Total Availability