SELECT ApplicationCode, ApplicationID, Message, COUNT(*) AS bugCount, MAX(createdOn) as createdOn, MAX(entryID) AS EntryID, MAX(severityCode) AS SeverityCode FROM qryEntries GROUP BY ApplicationCode, ApplicationID, Message ORDER BY createdOn DESC #xmlFormat(qryEntries.ApplicationCode)# #ApplicationID# #xmlFormat(tmpMessage)# #qryEntries.bugCount# #dateFormat(qryEntries.createdOn,dateFormatMask)# #lsTimeFormat(qryEntries.createdOn)# #qryEntries.entryID# #qryEntries.severityCode# // if we are passing an entryID, then get the message from there var = ""; if(val(args.msgFromEntryID) gt 0) { oEntry = oAppService.getEntry( args.msgFromEntryID ); if(oEntry.getMessage() eq "") message = "__EMPTY__"; else message = oEntry.getMessage(); } SELECT * FROM qryEntries ORDER BY createdOn DESC #xmlFormat(qryEntries.ApplicationCode)# #ApplicationID# #xmlFormat(qryEntries.hostname)# #qryEntries.hostid# #xmlFormat(tmpMessage)# #dateFormat(qryEntries.createdOn,dateFormatMask)# #lsTimeFormat(qryEntries.createdOn)# #qryEntries.entryID# #qryEntries.severityCode# #xmlFormat(oEntry.getApplication().getCode())# #oEntry.getApplicationID()# #xmlFormat(oEntry.getHost().getHostname())# #oEntry.getHostID()# #xmlFormat(tmpMessage)# #dateFormat(oEntry.getDateTime(),dateFormatMask)# - #lsTimeFormat(oEntry.getDateTime())# #oEntry.getEntryID()# #oEntry.getSeverity().getCode()# #xmlFormat(htmlEditFormat(oEntry.getExceptionMessage()))# #xmlFormat(htmlCodeFormat(oEntry.getExceptionDetails()))# #xmlFormat(oEntry.getCFID())# #xmlFormat(oEntry.getCFTOKEN())# #xmlFormat(oEntry.getUserAgent())# #xmlFormat(oEntry.getTemplate_Path())# #xmlFormat(oEntry.getHTMLReport())# SELECT *, upper(code) as u_code FROM qryData ORDER BY u_code #ApplicationID# #xmlFormat(qryData.code)# SELECT *, upper(HostName) as u_host FROM qryData ORDER BY u_host #xmlFormat(qryData.HostID)# #HostName# #qryData.SeverityID# #xmlFormat(code)# #xmlFormat(name)# #xmlFormat(action)# #error# #xmlFormat(errorMessage)# #results# #toString(xmlDoc)# var startDate = now(); if(numdays lt 1) startDate = dateAdd("h", numDays * 24 * -1, now()); else startDate = dateAdd("d", numDays * -1, now()); return startDate;