select 0 rank, reportdate, reportName, startTime, datediff( second, startTime, getDate() ) runTime, ownerId, ownerType, reportRequestId, serverName from tbl_SYS_UserReportRequests where serverName = 'FSEWEB07' and status = 'RUNNING' union select 1 rank, reportdate, reportName, startTime, datediff( second, startTime, getDate() ) runTime, ownerId, ownerType, reportRequestId, serverName from tbl_SYS_UserReportRequests where serverName = 'FSEWEB08' and status = 'RUNNING' union select 2 rank, reportdate, reportName, startTime, datediff( second, startTime, getDate() ) runTime, ownerId, ownerType, reportRequestId, serverName from tbl_SYS_UserReportRequests where serverName = 'FSEWEB81' and status = 'RUNNING' union select 3 rank, reportdate, reportName, startTime, datediff( second, startTime, getDate() ) runTime, ownerId, ownerType, reportRequestId, serverName from tbl_SYS_UserReportRequests where serverName = 'FSEWEB87' and status = 'RUNNING' union select 4 rank, reportdate, reportName, startTime, datediff( second, startTime, getDate() ) runTime, ownerId, ownerType, reportRequestId, serverName from tbl_SYS_UserReportRequests where serverName = 'FSEDEV03' and status = 'RUNNING' union select 10 rank, reportdate, reportName, startTime, 0 runtime, ownerId, ownerType, reportRequestId, serverName from tbl_SYS_UserReportRequests where status = 'PENDING' order by rank, reportDate

Report Date	Report Name	Start Time	Run Time	Client	reportRequestId	Server
#reportDate#	#htmleditformat( reportName )#	#startTime#	#runTime#	#ownerType##ownerId#	#reportRequestid#	#serverName#
Total Reports in Queue: #qmd_reportQueue.recordCount#

Process for handling a STUCK report

If the report is still running on the coldfusion server (cfmod_generateReports.cfm), it will need to be killed by cycling the server.
When the server comes back up, set the status of the tbl_SYS_UserReportRequests record to "ERROR"
If the report process is no longer running on the coldfusion server (cfmod_generateReports.cfm), set the status of the tbl_SYS_UserReportRequests record to "ERROR"