Number of members of a group logged on within a given timeframe

I need to come up with a livereport to determine how many unique users per group have logged in within a certain amount of time. We need to monitor the usage per group to align our internal charges with licensing costs. Has anyone written a query similiar to this?Thanks,LucentAdmin

Find more posts tagged with

Comments

Liz_Connors_(sunvalleyfoodadmin_-_(deleted))

This is quite simple, it requires 3 tables :KUAF - Users and Group listingKUAFCHILDREN - Links KUAF to KUAFDAUDIT - Audit table of events,so you can query DAUDIT for events that are LOGIN's over the specified date range where the USER ID (got from DAUDIT) maps to the specified group in KUAFCHILDREN and then you can use KUAF to provide more info on the user and/or group such as proper name, username etc.

Brian_Rourk_(rourk_-_(deleted))

Thanks for the information, the following seems to do the trick:SELECT COUNT(kuafchildren.childid)FROM kuaf, kuafchildrenWHERE kuaf.id IN (SELECT kuaf.groupid FROM kuaf WHERE kuaf.id IN (SELECT DISTINCT (daudit.userid) FROM daudit WHERE daudit.event = 'LOGIN' AND daudit.auditdate >= %1 )) AND kuafchildren.id = kuaf.id AND kuafchildren.childid IN (SELECT DISTINCT (daudit.userid) FROM daudit WHERE daudit.event = 'LOGIN' AND daudit.auditdate >= %1)