Report displaying list of users assigned to a role as on a particular date.

[Manikandan Subr]

We have a requirement to run a report showing how many users were part of a role on a particular day. For ex: I want to show the trend of users assigned to ITIL role as on 1st of every month. Is there a way we could run this report in ServiceNow? 

[jaheerhattiwale]

@Manikandan Subr You can see the trend of how many users got the particular role in the month. Create a report like below

1. Create report on user role table

2. Select type as trend

3. In configure select "per" month

Play with Per field to get the desired report

4. Apply filter

5 Result

Please mark as correct answer if this solves your issue.

[Manikandan Subr]

Thanks this only answers report about users added but my main requirement is to identify the users that we were to make the report complete. ForEx: As on a month if I only take by created, then i will only show how much was created but not a snapshot what was total used as on that date. 

[AndersBGS]

Hi @Manikandan Subr ,

Yes, but you need to utilize performance analytics to take snapshot of e.g. count of users that have the ITIL group. in the report designer you can only see current and not historical data. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[jaheerhattiwale]

@Manikandan Subr You can create a drill down on the report created like i shared before. If you create drill down then after you click on month bar then it will show the report per day. Create drill down like below

Open report created

Click on drilldown icon

Follow the same procedure i shred for drill down as well.

Just this time select "Per" day.

Please mark both my answers as correct answer if this solves your issue.