Count of users for each app

  • 11 August 2020
  • 2 replies
  • 23 views

Hello,

 

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.

 

Thanks!


2 replies

Badge +7

Hi

 

You can do it by yourself through a SmartObject  when launching the form (SmartBox or SQL server for example).
For a stronger integration with K2, I advise you to look at these K2 Ideas and vote on the ones that most closely match your needs.
Here is what I found on my side:

https://ideas.k2.com/ideas/APIT-I-203
https://ideas.k2.com/ideas/APIT-I-97
https://ideas.k2.com/ideas/APIT-I-938


Best regards,

Olivier

Badge +7

By the way, you can see more deeper information about users with the SmartObject Service tester++ in menu Tools++ and "Check licensed users".

 

You can found this functionality with the Smart Object Service Tester++ :
https://community.k2.com/t5/General-K2-Utilities/SmartObject-Service-Tester-plus-plus/ba-p/92426
For french language:
http://www.enk2besoin.com/2016/12/13/smartobject-service-tester-une-version-amelioree-de-loutil-incontournable-de-k2

The tool "SmartObject Service Tester++" is not an official one and is not maintained by K2 France.
In all cases this tool will be not supported by the K2 support:No ticket will be accepted about this.

 

Best regards,
Olivier Chatagnon

Reply