The "1" in the second-to-the-last line in the script below, makes it show
data only since midnight of the current date. Increase that number (of
days) and it'll go further back in time. The line that starts with "AND
Username like" is there because we sometime search through the logs based on
the username. We have it defaulted to "LIKE '%%'" so that it includes
everyone unless we enter in a username to search for.
SELECT rl.LogDate, rl.UserName, rm.Description, rl.Data
FROM RadLogs rl, RadLogMsgs rm
WHERE rl.RadLogMsgID = rm.RadLogMsgID
AND DateDiff(Day, rl.LogDate, GetDate()) < 1
AND Username LIKE '%%'
/* % acts as a wildcard and can be removed if necessary */
ORDER BY rl.LogDate
Josh
>-----Original Message-----
>From: emerald-request@iea-software.com
>We just started authentication yesterday and in general we are thrilled
with
>our new found source control and information. We have been testing like
>crazy and as you can see by our messages are coming up with questions and
>observations. One thing we noticed that is not a problem but a request to
>be changed in the future is:
>
>When you deactivate a master record or any of the individual services, it
>works correctly but the error message in the log says "User not found", it
>would be great if that could be changed to "User not active".
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html