What data are you looking to display?
Tony, looking to display alert history for the last 24 hours.
As the custom table resource does not support pagination an alternative may be to use the custom Query resource. The custom query resource allows you to define the number of rows per page with options to define queries for filtering the data.
select AlertHistory.AlertObjects.AlertConfigurations.Name as [Alert Name],
AlertHistory.AlertObjects.EntityCaption as [Triggering Object],
ToLocal(Timestamp) as [Time],
AlertHistory.AlertObjects.RelatedNodeCaption as [Related Node],
'/Orion/NetPerfMon/ActiveAlertDetails.aspx?NetObject=AAT:'+ToString(AlertObjectID) as [_linkfor_Message],
'/Orion/NetPerfMon/ActiveAlertDetails.aspx?NetObject=AAT:'+ToString(AlertObjectID) as [_linkfor_Alert Name]
where TimeStamp > ADDDATE('HOUR',7,ADDDATE('day',-1,GETDATE()))
Order by TimeStamp desc
Thanks Tony, this is very helpful.