Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
-Rob
It sounds like you are loading the Sessions Logs? There is field called [Cal Type] in the Session records.
-Rob
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.
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.
-Rob