CREATE CUSTOM REPORT LIST OF USERS WITH MORE THAN 10 INCIDENTS

Sandeep74
Tera Expert

I need to create the custom report in service now with users having more that 10 records and how can I populate those users using report in service now.

 

As  I tired but I couldn't find the field that need to populate the user criteria .

any suggestion or any answer if u know could you provide solution for this.

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

something like this using Related list conditions

Report on sys_user

find_real_file.png

find_real_file.png

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

4 REPLIES 4

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

something like this using Related list conditions

Report on sys_user

find_real_file.png

find_real_file.png

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

is their any wat to populate the user name also their in that report

Hi,

the report is on sys_user

so you can add whatever columns you want to show using the configuration of show columns

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Hi Ankur,

 

I need to report on incident table to display only the incidents where each location contains more than 3 incident tickets.

 

Example: 2 incidents are from Loc A, 5 incidents are from loc B

 

the report should only show the 5 records of loc B

 

I tried your suggestion; it's showing zero records.

 

ArunaSreeYela_1-1688383037808.png

 

 

Could you provide solution for this.

 

Thanks in advance!