Somebody knows how to get just some information from SLA reports? Can be by a SQL query for instance.
I would like to get just Object, Source, Target and Total unavailability as below.
This is calculated dynamically by the ump.
You would probably have to run a query such as the following and do the calculation yourself.
Here's an example from a lab server and 'test' SLA:
Method: getQoSData(java.lang.String: 188.8.131.52, java.lang.String: QOS_DISK_FREE, java.lang.String: FC_NIMSOFT/datastore1 (1)/Free, long: 1320127200000, long: 1322722800000)
SELECT DISTINCT r_table, table_id
WHERE source = '184.108.40.206'
AND qos= 'QOS_DISK_FREE'
AND target = 'FC_NIMSOFT/datastore1 (1)/Free'
Query qSem took: 0.0s
SELECT sampletime, samplevalue, samplerate
WHERE table_id = '266'
AND sampletime BETWEEN '2011-11-01 00:00:00.0' AND '2011-12-01 00:00:00.0'
Query jPbj took: 0.0s
The SQL is dynamically generated when the SLA calculation is performed. However, extracting the SQL is only available in UMP through a debug utility.
hope this helps
Retrieving data ...