Report that shows users with with 2 types of assets (asset_function)

[Jimmy Cummens]

Here's the scenario. Our hardware team is currently working on computer refreshes and they would like a report on who has hardware assigned with the asset_function of both "Standard" and "Refresh." 

Example: Bob Jones has a PC asset with the asset function of Standard AND he also has a PC asset with the asset function of Refresh.

Bill User only has a PC asset with the asset function of Standard.

Bob Jones should show up on the report, but Bill User should not.

I believe i need to run the report against the "sys_user" table. 

The "asset_function" is tied to the "alm_asset" table. 

I've attempted to create the report in Report Builder, but not having much luck. Perhaps a script is needed?

[Jaspal Singh]

Hi Jimmy,

You need to report on alm_asset table and then apply relevant asset_function filter.

Group the report by Assigned To, if needed for better understanding.

[Jimmy Cummens]

Perhaps I'm filtering incorrectly, but that appears to produce a report of users that have either a Standard asset function OR a Refresh asset function. I'm trying to find users that have both assigned to them. 

[Danish Bhairag2]

Hi @Jimmy Cummens ,

Can you try replacing the OR condition for Asset function to AND condition & try to run the report.

Please mark my answer helpful & accepted if it resolves your query.

Thanks,

Danish

[Jimmy Cummens]

Setting it to AND produces no results. 

Using the AND option, the system is looking any assets that have both asset functions, which isn't possible. Our assets can only have one function.