How to determine count of users who have named CALs

[Anonymous]

All,

I am trying to create a custom governance dashboard for my work area and am running into some difficulty with a couple of the expressions I am attempting to use.

What I am looking for is:

1) Determine how many distinct users had 1 or more sessions on our production access point (where the Prod server names are represented by the variable 'vProdNodes') within the last 30-days and

2) How many of those distinct users have named CALs?

For #1, I'm thinking I could do that this way:

=Count({<Node_Name={$(vProdNodes)}, SessionDateNum={">=$(=NUM(Today())-30)"}, Session_Start_Count={">0"}>} Authenticated_User)

For #2 I'm stuck.   Let's say that in my load script I have a field I called NamedCALUser that is populated with either a 1 or 0, depending on whether my corresponding Authenticated_User values match a table of NamedCALUsers that I loaded into dashboard by their production IDs.

So basically out of #1, I'm looking for a count of a subset of those records where NamedCALUser = 1.   Would someone please explain to me how to do that?

Thanks in advance for the help!

[rwunderlich]

It sounds like you are loading the Sessions Logs? There is field called [Cal Type] in the Session records.

-Rob

[Anonymous]

Yes, session logs are a portion of what we are bringing in.   I see exactly what you're talking about regarding the [Cal Type] field.   With regard to measuring CAL utilization, are you aware of a particular field or method that we can tell if a user is utilizing their named CAL "enough" by our standard?  What I mean by that is, I would hate to revoke a named CAL from someone who may not be working on an access point but was using their desktop client to collaborate with other developers / power users.  When a user logs into their desktop client, does that ping somehow against the license server and is it recorded somewhere that I can access?   My entire goal with this is to ensure that our licenses are utilized by the people who need them and use them regularly.

[rwunderlich · Accepted solution]

In the QlikView Server event*.log, you should see  a message like:

100

Notice

License: License leased to user ROB-WORK2\ROB

each time a license is leased or a lease is renewed That should tell you who has a leased license and is launching their desktop.

You may also want to check out David Vasseur's CAL Manager tool. Very useful.

Qlikview Server CAL Manager

-Rob

http://masterssummit.com

http://qlikviewcookbook.com