Novell Home

Translating Codes, Times, and IP Addresses

Novell Cool Solutions: Tip

Digg This - Slashdot This

Posted: 31 Aug 2005
 

Problem

"iManager does a pretty good job of translating actual EventID codes into meaningful statements. However, I want to query the log table directly through the MySQL Command Center.

Where can I find a compiled list of EventIDs and their corresponding definitions? (Any help on translating Unix Time and IP Address would be cool, too!)"

Solution

Here are some Event ID lists:

NetWare

http://www.novell.com/documentation/nsureaudit/html/netware_events.htm

File System

http://www.novell.com/documentation/nsureaudit/html/filesystem_events.htm

eDirectory

http://www.novell.com/documentation/nsureaudit/html/edirectory_events.htm

Note that the event IDs in these lists are shown as hex, while the Audit system stores the values as decimal.

As for translating the times, there is a Cool Solutions article:

http://www.novell.com/coolsolutions/tip/7720.html

I can't point to samples for the IP address, though. It is stored in decimal form. If you convert it to hex, split the four pairs, then convert each back to decimal with a dot between them, you will get the familiar 123.0.0.x format.

For the IP on MySQL, use this fuction:
INET_NTOA(ServerIP)

For timestamps on MySQL, use this fuction:
FROM_UNIXTIME(clienttimestamp)

So an example would go something like this:

select INET_NTOA(ServerIP), FROM_UNIXTIME(clienttimestamp), text1, value1 from log;


Novell Cool Solutions (corporate web communities) are produced by WebWise Solutions. www.webwiseone.com

© 2014 Novell