How to display only the active user record in the reports?"

[Srinivasu2]

Hi Community,

"I've noticed an issue where some users have multiple ServiceNow records when generating reports.

For example, there is an active user record for Ed Labhan and a duplicate, inactive user record with the same name.

I need to ensure that only the active user record is shown when generating reports. Could you please advise on how to display only the active user record in the reports?"

Thanks & Regards,

Srinivasu

[debendudas]

Hi @Srinivasu2 ,

You can add a filter condition in the report shown in the below screenshot:

If this solution helps you then, mark it as accepted solution ‌‌✔️ and give thumbs up 👍 ! 

[Srinivasu2]

Hi @debendudas ,

I have created duplicate inactive abel tuter user record in sys_user table

Add filter condition in reports : active is true

The caller is Abel Tuter, but both active and inactive records are being displayed as below

I want to display only the active Abel Tuter user record to avoid any confusion when selecting the correct active user

Could you please check the screenshot and advise?

Thanks,

srinivasu

[debendudas]

Hi @Srinivasu2 ,

This is a filter where you are seeing the inactive records.

Please use the filter caller.active = true and save the report and then the inactive records will not be visible in the report.

[Srinivasu2]

But still it is showing two records

Could you please check & advise?

Thanks,

Srinivasu