- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-04-2022 12:23 PM
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.
Solved! Go to Solution.
- Labels:
-
Performance Analytics
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-05-2022 11:29 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-22-2024 06:06 PM
Hello @Mark Becker, I have a created date but I don't have a retired field in sys_user table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-24-2024 06:34 AM
@SN241 - You can not go back historically for any counts. I would set up your KPI immediately for a daily run or monthly depending on the clients needs. Then you will have your information from now and going forward. Thanks!
