Can I filter a report by users with more than one asset and have the assets show in the report?

CatchTheFletch
Tera Contributor

I found this thread while looking for this: https://www.servicenow.com/community/itsm-forum/anyone-know-how-to-report-on-users-with-multiple-ass...

 

Which originally I was going off the alm_hardware table. The problem I'm running into now is I can filter down to the people in my org who have more than one asset by following the filter setup in the link above, but now I'm unable to see the assets in the report because I can't get a column for the assets to show. It just shows the users and you have to go to their user record to see the assets. 

 

Alternatively is there a way to filter out people with only one asset with you use the alm_hardware table? I'm attaching an example of what I get with the alm_hardware table. This is very close to what I'm looking for. Just need to filter out the people with single assets.

0 REPLIES 0