A Database Approach to Logging Access
Novell Cool Solutions: Tip
By Ron Fowler
Digg This -
Posted: 25 Jul 2002
We, too, created a log utility that runs in the login script and writes to a file on the network. It records the following in comma delimited format:
date,time,ip address,mac address,computername, and username.
That utility (and the Visual Basic source) is available at:
Our access log application is better (for us anyway) because instead of writing the information to a log file that has to be imported into something to query it effectively we changed it. Our version of the app sends the information to a web site that uses Cold Fusion and SQL on the backend to record the information as users login. The information can then be more easily queried by our technicians. We can query based on any of the info gathered from the log over a period of time. It can also be used to ping, wakeup, userinfo, and SquidGuard (proxy that filters pornography) hits.
Other things it records is what building/school the computer is at, ghost image version, and asset tag number. Most of this is done with Cold Fusion queries and minor changes to the above weblog app. This may be of help to those wanting to modify the above app to get more useful info. We also use NAL to fill in information like the DN of the user, etc.
You can contact Ron (to tell him how bright he is) at firstname.lastname@example.org
Novell Cool Solutions (corporate web communities) are produced by WebWise Solutions. www.webwiseone.com