Need a report where i can get the department wise spent and total cost on softwares
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-08-2024 03:00 AM
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 as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-08-2024 03:44 AM
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.
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-08-2024 07:28 AM
Thanks @Mark Manders ,
But for software table do we choose the Software model(cmdb_software_product_model) or cmdb_sam_sw_install ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-13-2024 04:57 AM
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).
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-13-2024 07:09 AM