How do I create a report to only show Users with more than one asset assigned to them

anthonylazar
Tera Contributor

‎03-01-2018 11:22 AM

How do I create a report to only show Users with more than one asset assigned to them

Labels:
0 Helpfuls
  • 2,450 Views
5 REPLIES 5

Adam Stout
ServiceNow Employee
ServiceNow Employee

‎03-01-2018 12:48 PM

This should be very straightforward using Related List Conditions. 

0 Helpfuls

anthonylazar
Tera Contributor

‎03-01-2018 01:11 PM

Thank you! So far I have created the conditions below, but cannot figure out how to Filter/condition showing only Users who are assigned >1 device. Any additional info is appreciated.

 

find_real_file.png

Preview file
65 KB
0 Helpfuls

raycallan
Giga Guru
In response to anthonylazar

‎06-07-2019 01:59 AM

Hi Anthony, 

Just found this thread as I was looking for the similar solution whereby I wanted to find users assigned multiple computers and I have managed to get my report working as per Adam's suggestion to use Related lists

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

Hope this helps

Ray

find_real_file.png

Preview file
66 KB

Sudeepta
Tera Contributor
In response to raycallan

‎02-08-2021 06:33 AM

Thanks for your help, nice solution. Instead of writing a script, we can leverage this solution.

0 Helpfuls