Get a first look at what's coming. The Developer Passport Australia Release Preview kicks off March 12. Dive in! 

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

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  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

4 REPLIES 4

Ankur Bawiskar
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  ||  10x 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  ||  10x 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!