Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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!