ITIL User Count Month by Month

Nick Lozano · ‎05-04-2022

Hello,

I need to get a month by month ITIL user count for the last year. The only way I can think of doing this is using the sys_user table but am having trouble with it.

Mark Becker · ‎05-05-2022

It's only looking current day. You can only get this from today and moving forward not historically. There might be a way to get historical if you have Create Date and Retired Date or some day to recognize that someone was not there and active at that point in time. In which case you would define someone as active as [Create Date] > Today AND [Retired Date] < Today.

PA is acting correctly here as it's just looking current state and running it backwards. I usually set up the indicator and start it today and going forward. Up do you if you really need it historically could be unattainable depending on the attributes available to you.

View solution in original post

Jaspal Singh · ‎05-04-2022

Try something as below.

Nick Lozano · ‎05-05-2022

Thanks Jaspal. I'm looking for a total each month. This way we can see total number of ITIL users each month.

Would I need to move out of report and into PA?

Wayne Richmond · ‎05-05-2022

PA will record the data at intervals so will provide the solution. Alternatively, you might be able to create a Metric to do it and then report on that.

Mark Becker · ‎05-05-2022

Hi Nick,

Yes you will have to move out of Reporting and into PA for this. I would set up an automated indicator to look at User table if you have roles there. However, for ours we do not have roles on the user table. If that's how yours is set up just create the automated indicator in PA. You would then put it in a job to run each day and record the count. You can look at averages over the months or display however you'd like. For us, our roles are kept in another table called User Role [sys_user_has_role]

If you're familiar with PA you'd set up an Indicator Source then an Indicator and put that in a job to run each day. Hope this helps!