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; } } }

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)