Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Content Management (Extended ECM)
API, SDK, REST and Web Services
Use Livereport to return licensed users
Bill_Todd_(trarei01admin_-_(deleted))
Does anyone have a clue how to use a Livereport to compile licensed user information?
Find more posts tagged with
Comments
Deepika_Kowkuntla_(nidauser2_-_(deleted))
This SQL should return the number of licenses that are in use. It is basically the number of non-deleted users defined in Livelink.select count(*)from kuafwhere deleted=0 and type=0For more details on Open Text's definition of a license, see:
https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=2946881&objAction=viewPaul
Dave_Ebels_(jocoadmin_-_(deleted))
I have used the following very successfully.select count(name)"Users with Logon privileges",100-count(name)"Open licenses" from kuaf where type=0 and deleted=0 and userprivileges>14simply substitute your total license count for the number 100 in this example and the return will be ,,,Users with Logon privileges ------- Open licenses --(number)---------------------------- (number)
