[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: [ISSForum] Site Protector tools



Jose,

The only thing stored in the database is the audit trail, but not actual
sessions. You might be able to query the audit trail like this:

SELECT
	ADT.AuditTrailID, ADT.AuditTime, ADT.Username, ADC.EventDesc,
ADI.ParamName, ADI.ParamValue
	from AuditTrail as ADT
JOIN AuditInfo as ADI
	on ADT.AuditTrailID = ADI.AuditTrailID
JOIN AuditEventCMD as ADC
	on ADT.AuditEventCMDID = ADC.AuditEventCMDID
-- AuditEventCMDID 5 = console login, 6 = console logout
WHERE ADT.AuditEventCMDID IN (5, 6)


Cheers,
Robert

-----Original Message-----
From: issforum-bounces@xxxxxxx [mailto:issforum-bounces@xxxxxxx] 
Sent: 23 September 2004 14:51
To: issforum@xxxxxxx
Subject: [ISSForum] Site Protector tools

Does anyone have a website that provide useful tools to query
information from the Site Protector DB.  I'm looking for a tool that
will provide the list of userids currently logged on and using Site
Protector console.
 
thanks in advanced!!


Jose Morales
mailto:mavenusa@xxxxxxxxx
_______________________________________________
ISSForum mailing list
ISSForum@xxxxxxx

TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to
https://atla-mm1.iss.net/mailman/listinfo/issforum

To contact the ISSForum Moderator, send email to mod-issforum@xxxxxxx

The ISSForum mailing list is hosted and managed by Internet Security
Systems, 6303 Barfield Road, Atlanta, Georgia, USA 30328.

_______________________________________________
ISSForum mailing list
ISSForum@xxxxxxx

TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to https://atla-mm1.iss.net/mailman/listinfo/issforum

To contact the ISSForum Moderator, send email to mod-issforum@xxxxxxx

The ISSForum mailing list is hosted and managed by Internet Security Systems, 6303 Barfield Road, Atlanta, Georgia, USA 30328.