[Emerald] RadLogs view

Josh Hillman ( (no email) )
Mon, 7 Feb 2000 21:22:21 -0500

Is there a way to change the RadLogs view so that a date is shown instead of
"-(number of minutes past MasterAccounts.maExpireDate)" when a user's
account is expired? (The beginning date of authentication denial, not the
MasterAccounts.maExpireDate)

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