Courion Tip – HTML ticketing results for the last hour

Depending on what your ticketing table looks like, here you go…

Select ‘<TR><TD>’ as EXR0, Date,'</TD><TD>’ AS EXR1,UserActedOn,'</TD><TD>’ AS EXR2,TargetID,'</TD><TD>’ AS EXR3,ActionReturnMessage,'</TD></TR>’ AS EXR6 from ticketing
where Date >CAST(SYSDATETIME() as datetime) -.04
order by Date desc

This will give you only the results for the last hour (0.04 days)

Advertisements

Posted November 10, 2011 by mmdmurphy in Courion Tip

Tagged with

%d bloggers like this: