I need to get count of active and inactive users per app. We're on K2 4.7 Blackpearl.
Is there a query which be run against K2 database on SQL Server?
I have got Audit Report from Management > License, but that reports only users and last active date. I need app info too, if that's possible.