I have a SQL script that does it perfectly, but I couldn't alter the RadLogs
view to do the same. My attempt to alter the view (slightly modified
version of what's below), produced no difference in the view within Emerald
(2.5.322).
Here's the script I wrote and use in ISQL:
SELECT rl.LogDate,
rl.UserName,
Description=convert(varchar(17), rm.Description),
Data=CASE
WHEN rm.Description LIKE '%Expired%'
THEN convert(varchar(10), dateadd(minute, convert(int,
rl.Data), rl.LogDate), 101)
ELSE convert(varchar(20), rl.Data)
END,
CallerID
FROM RadLogs rl, RadLogMsgs rm
WHERE rl.RadLogMsgID = rm.RadLogMsgID
AND DateDiff(Day, rl.LogDate, GetDate()) < 1 /* past n days */
AND Username like '%%' /* Enter a username if you want */
ORDER BY rl.LogDate desc
Josh
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart