ITIL User Count Month by Month

[Nick Lozano]

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.

[Nick Lozano]

I tried running through PA and only get the exact same number per month over the last 13 months. Trying to figure out what step I'm messing up on. Below are screenshots for Job, Indicator Source and Automated Indicator. Any help with this would be greatly appreciated.

Setup a job:

My Indicator Source is:

fAnd finally my Automated Indicator is:

[Mark Becker · Accepted solution]

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.

[Nick Lozano]

Thanks Mark, this is what I thought but couldn't be 100% sure. I'm going to take your suggestion and start a daily collection so we can have those stats going forward.

[SN241]

Hello @Nick Lozano , any updates on this? I encountered the same problem. What did you do? Can you share? Thank you!

[Mark Becker]

Hi SN241 - This question was answered. Unless you have a create date and retired date field to set up historical measures you can not measure this historically backwards. You must start the data collection today and moving forward. Hope this makes sense.