Hello,

we are using cognos as reporting tool and I'm looking for a sql query which shows the monitored URLs and their  availability. Could you provide such a sql query?

In this forum I only found a query for cpu and memory utilization:

select RESOURCENAME, from_unixtime(COLLECTIONTIME/1000),COLLECTIONTIME, CPUUTIL,PHYMEMUTIL
        from HostCpuMemDataCollected, AM_ManagedObject
        where AM_ManagedObject.RESOURCEID=HostCpuMemDataCollected.RESOURCEID
        order by COLLECTIONTIME
        limit 100;

Maybe you have some queries regarding URL Monitoring.

Thanks in advance,
Chris