Need a report where i can get the department wise spent and total cost on softwares

[Ashupakasma]

Hello Experts,

I need to create a report which contains 

1- How many software has been there in the environment department wise

2- How much total spend on software (For each department)

I am trying to create this report but when I am taking the cmn_department in table I am not getting the software details in data section of report. 

please suggest the best way to get this detail in a report 

note- in software entitlement we haven’t provided the department details, i hope its will not impact to create the required report 

[Mark Manders]

If you are reporting on the department table, you won't get to the software, since it's not on there. You will need to go from the software, grouping by department (depending on how your setup is, through user?)
How is the cost showing (on which tables). If that's on the same table, you can do it in the same way: software, grouped by user.department.

[Ashupakasma]

Thanks @Mark Manders ,

But for software table do we choose the Software model(cmdb_software_product_model) or cmdb_sam_sw_install ?

[Mark Manders]

I don't know your instance, so I don't know where your software is stored. You need the table where software is linked to the user (or device to go to the user from there).

[Ashupakasma]

Thanks @Mark Manders 

The OOTB table is alm_entitement_user