nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Most active groups

OJ_Ryan_Meyer_(AICPAkm_(Delete)_1725193)

Is there any way to see a list of the most active groups for a given time frame?

Find more posts tagged with

Comments

Bob_De_Garmo_(degarmob_(Delete)_2518944)

Please define "most active groups"...

OJ_Ryan_Meyer_(AICPAkm_(Delete)_1725193)

By "Active Groups" I mean the user groups which have the most logins for a given timeframe. Another report showing which user groups have fetched, viewed, or added files or objects would also be very helpful.

Bob_De_Garmo_(degarmob_(Delete)_2518944)

This could probably be worked out via counts from DAudit joined back to KUAF, and KUAFChildren. But the issue would be that Users << for which events are logged in DAudit >> may, and probably do, belong to multiple Groups. So... Would you want the events to be summed only by the Users' Department, or base group?

Laura_Raab_(nidauser3_-_(deleted))

We have a report we use to just tally up the active users (meaning those who have ever logged in at all) and group them by their base groups. Maybe you can use this as a starting point. I would love to know how to actually rank the groups by activity. (This is for Oracle...)select b.name "GROUP NAME", count(unique a.id) "ACTIVE USERS" from kuaf a, kuaf b, daudit c where a.type = 0 and a.userprivileges ^= 14 and a.deleted = 0 and a.id = c.userid and c.event = 'LOGIN' and a.groupid = b.id group by b.name

OJ_Ryan_Meyer_(AICPAkm_(Delete)_1725193)

I want to know what teams, committees, departments, etc. are most actively using the system, but since LL has no way of telling what sub-group they are acting as, I would guess it would have to be Base Group.

OJ_Ryan_Meyer_(AICPAkm_(Delete)_1725193)

This is a great report, but it doesn't show which group is the most active.Thanks for the help. I will still get use out of it.

Alex_Kowalenko_(akowalen_(Delete)_2285456)

Try This...The following query will give a sorted list of the most active "first level" groups based on a , such as ('LOGIN','FETCH','VIEW'), in a given time frame defined by and . By "first level" I mean groups that the user directly belongs to. Users may belong to "upper level" groups through a hierarchy of groups and you could modify the query to find these as well.The "first level" query is:select count(u.name) "Activity", g.name "1st Level Group" from kuaf u, kuafchildren ug, kuaf g, daudit a where u.id = ug.childid and u.type = 0 and u.deleted = 0 and g.id = ug.id and u.id ^= 1000 and g.type = 1 and g.deleted = 0 and u.id = a.userid and a.event in and a.auditdate between and group by g.name order by count(u.name) desc