Software Entitlement Count per Software Model

[shuchi24]

Hi All,

I would like to create a view that displays the count of software entitlements for each software model. Could you please guide me on how to achieve this?

Thanks,

Shuchi

[sivasankaris]

Hi @shuchi24 ,

Step-by-Step: Creating the License by software model  count 

1. Navigate to Reports: In the Filter Navigator, type Reports and select Create New.

2. Data Source Configuration:

   • Report Name: Enter something descriptive, like Software Entitlement Count by Model.

   • Source Type: Select Table.

   • Table: Search for and select Software Entitlement [samp_sw_entitlement] (if using Software Asset Management Professional) or [alm_license] (for standard assets).

3. Select Report Type:

   • Click Next or go to the Type tab.

   • Choose Bar (for a visual).

4. Configure the Grouping:

   • Click Next or go to the Configure tab.

   • Group by: Entitlement>Software model.(get this by dot walking)

   • Aggregation: Ensure this is set to Count

5. Save and View:

   • Click Run to preview the data.

   • Click Save to keep the report.

If you find this useful, please mark it as helpful and please accept my solution....

Best Regards

SIVASANKARI S

[shuchi24]

Hi @sivasankaris , @Nilesh Pol , @MikeW0609686430 
 
Thank you for the solution. I am looking to create a report that displays the list of software models along with the count of software entitlements associated with each model. The report should show zero if there are no entitlements, and reflect the actual count if there are one or more. Since I have duplicate software models, I would like to verify whether these duplicates have any entitlements before proceeding. If they do, I plan to consolidate them into a single model and then remove the duplicates.

Thanks,
Shuchi

[Nilesh Pol]

@shuchi24 

You can display the count of software entitlements for each software model is best achieved by creating a Report based on the Software Entitlement table. 

If you find this useful, please mark it as helpful and please accept my solution....

[MikeW0609686430]

There is a view in the SAM workspace that displays all entitlements: