How to get the list of incidents closed by particular user

Dileep Kumar3
Kilo Contributor

Hi ,

I need a small help guys

If a user is assigned with 10 Incidents and the user has closed 7 incidents of 10.

I need the list of 7 incidents numbers.

In a custom table there are 2 fields

1.USER(ref)

2.NUMBERS

if  i select the user in USER field then the list of incidents closed by that user should reflect in NUMBERS field

Thanks in advance

7 REPLIES 7

There is a custom table with 2fields

1 USER(reference)

2 NUMBERS

If i select a person(user) in USER field then 

i need all the list of incident numbers that are closed by that user

in NUMBERS field

 

Hi

I suggest to create a form view on the user record, with a related list filtered on incidents, which are closed by that user.

The table in my example above has a user field. So, if you show that List of the table, you can click on the user and open the form view with the related list.

 

Does that makes sense?

 

BR

Dirk

 

The SN Nerd
Giga Sage
Giga Sage

Create a report

Filter: Assigned to Same As Closed

Group by Assigned To

I don't understand the requirement for all these custom tables.
Each custom table is a table you have to allocate to a product suite when you move over to Madrid Licensing.
This 100% can be done with reports.

Why are you doing this?


ServiceNow Nerd
ServiceNow Developer MVP 2020-2022
ServiceNow Community MVP 2019-2022