Create List Report with count using "alm_asset" table

[SJena]

I need to create a list report using "alm_asset" table, where we have Asset is primary, and more than 1 laptop assigned to the user as per the IT region location.

But its not allowing me to add the more than 1 count option in list report.

Also i have tried using pivot report type, still its showing count for bother the users, who has 1 or more tan one laptop assigned.

Requesting to guide me to create a report where i can add the count is more than one for the user.

So that we can see which user has assigned multiple laptop as asset.

Thanks

[SebastianBarnes]

Hi @SJena!

It may be difficult to accomplish this from the alm_asset side, but you can accomplish the same end result by running a report on "sys_user" based on their assigned laptop Configuration Items.

The below screenshot shows how to accomplish this.

1. Report on sys_user table (at the end, you will have a list of all users with 2 or more laptops)

2. Use a related list condition to show "Greater than or equal to 2" records on "Configuration Item -> Assigned to"

3. Still under the related list condition, add a filter to make sure only laptops are considered. So something like "Name contains LAPTOP" or however your laptop CIs are named. Or you can use something like "Asset > Model category IS Laptop."

The end result will be a list of all users that are assigned 2+ Laptops.

I hope this helps a little!

Sebastian