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