List of users who have 2 or more Assets assigned

riaz_mansuri · ‎06-18-2020

Hi,

Does anyone know of a quick way we can report on users who have 2 or more assets assigned to them?

I can get a list of the users but just to know who have 2 or more assets.

Any ideas? What is the best way?

Thanks

Swapnil Soni1 · ‎06-19-2020

Hi,

To get it to work your source table isUsers [sys-user] and under related list conditions select Asset -> Assigned to and change the Greater than or Equal to to 2

Hope this helps

Please mark correct or helpful.

Thanks

View solution in original post

riaz_mansuri · ‎06-19-2020

That actually worked! thanks

Swapnil Soni1 · ‎06-19-2020

Great!! Thanks 🙂

Ashutosh Munot1 · ‎06-19-2020

HI,

Have you seen this:

Scripting in Reports

Thanks,
Ashutosh