Report about monthly License Cost

[Thomas E_]

Hello, we are using SAM Pro and managing SW Models, entitlements and user/device allocations. We have information about cost centers / departments available for each allocated user/device to an entitlement. What I am now looking for is a possibility to report the software license usage cost per department based on the above information - ideally on a monthly basis. Is it possible to create such a report in SAM Pro? 

[Engelica Adalia]

@Thomas E_ This is possible. You just have to create two different reports since these data are coming from two different tables:

1. Device Allocation [alm_entitlement_asset] - dot walk to the user information to get the department details (Allocated to.Assigned to.Department) and configure to group by Department.

2. User Allocation [alm_entitlement_user] - dot walk to the user information to get the department details (Assigned to.Department) and configure to group by Department.

Then schedule these reports to run on a monthly basis - either schedule an email containing the report or add it to a Dashboard (which refreshes when you view it). 

Hope this helps!

Regards,

Engelica

[Thomas E_]

Ok, understood. How can I get the cost information (available on the entitlement record for the allocation - alm_license table) into the report - since I need to add up the cost for each license per allocation?

[Engelica Adalia]

You can get the cost information from the entitlement by configuring the report and adding the column - dot walk to the Entitlement.Unit cost (to get the cost per license per allocation). 

[Thomas E_]

Ok, that worked. Thank you! However, I would like to have both user based and device based licenses in one report, however, these allocations are provided in different tables so I chose alm_entitlement as the source table. Next issue is that the department for user based licenses is stored in assigned to->department->name. For device based licenses it is stored in allocated to->assigned to->department->name. So the group by is based on two fields. I can add a second "group by" condition, however ,that does not work.