Query: select MOID,mo.DISPLAYNAME,TYPE,IPADDRESS,MAX(downtimetable.STARTTIME),SUM(ELEMENTDOWN+PARENTDOWN+DEPENDENTUNAVAILABLE) as downtime,ROUND(AVG((1-((ELEMENTDOWN+PARENTDOWN+DEPENDENTUNAVAILABLE)/(ELEMENTDOWN+PARENTDOWN+DEPENDENTUNAVAILABLE+UPTIME+.0001)))*100),
4) as avail,mo.NAME from ManagedObject mo INNER JOIN TopoObject topo on topo.name=mo.name INNER JOIN OpManagerObject opm on opm.name=mo.name
INNER JOIN ElementAvailabilityHourly2009_02_12_3 availability on availability.ELEMENTID=mo.MOID LEFT JOIN downtime2009_02_12_3 as downtimetable ON mo.MOID=downtimetable.ELEMENTID and
((downtimetable.STARTTIME BETWEEN '2009-02-26 00:00:00.0' AND '2009-02-26 07:00:00.0') OR (downtimetable.ENDTIME BETWEEN '2009-02-26
00:00:00.0' AND '2009-02-26 07:00:00.0')) where COLLECTIONTIME BETWEEN '2009-02-26 00:00:00.0' AND '2009-02-26 07:00:00.0' group by
downtimetable.ELEMENTID,availability.ELEMENTID order by avail,DISPLAYNAME

Note: Iems marked in blue are table names and items marked in orange are the from-to time range for the query period. to get the correct items marked in blue you have to execute this query SELECT MetaTable.ID,BINARY MetaTable.ARCHIVETABLENAME,BINARY MetaTable.LOOKUPTABLENAME,MetaTable.FROMTIME,MetaTable.ENDTIME,BINARY MetaTable.BUILDNUMBER FROM MetaTable WHERE (((BINARY MetaTable.LOOKUPTABLENAME = 'ElementAvailabilityHourly') AND (MetaTable.FROMTIME < 1235673000000)) AND ((MetaTable.ENDTIME > 1235547000000) OR (MetaTable.ENDTIME = -1))) ORDER BY 4