How to determine count of users who have named CALs
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 #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?
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.
