total group count

mdbrammer

What sort of a query do I need in a LiveReport to return the total number of permissions groups (579)?

Aseveli

You can query the KUAF table for this information.

SELECT *

FROM KUAF K

WHERE K.Type = 1 -- Type is 1 for Group

AND K.Deleted = 0 -- Deleted = 0 to show only active groups

This should get you what you need.