question in report

[suresh kaliappa]

Hi All , 

I want to create a report which contains software usage data and the software model and version in 1 report. But usage details available in samp_sw_usage table in the usage table there is no link between software model. So can someone please suggest this can be achieved and a way to achieve this? 

[Bhimashankar H]

Hi @suresh kaliappa ,

Lets says you want to create list type of report then you need to find some relationship between these table and create database view. On database view you can create the report. If some conditions are very complex then you need to write script include and iterate the records and show in list report.

First you need to find some relation between these table then only you can show the details on report.

Hope that answers your query.

Thanks,
Bhimashankar H

-------------------------------------------------------------------------------------------------
If my response points you in the right directions, please consider marking it as 'Helpful' & 'Correct'. Thanks!

[M Iftikhar]

Hi @suresh kaliappa ,

There’s no direct link between Software Usage and Software Model, so you need to build the relation through a Database View. The Software Usage table provides the raw usage data, but to reach the model/version you first join it with Software Instance, which then links to Software Model.

Each Software Usage record (who used, how many times, last used date) is tied to a specific Software Instance (the actual installation on a device or for a user). The Software Instance then points to the Software Model (cmdb_software_product_model) to provide the product, version, and publisher details.

Once the DB view is created with these three tables, you can build your report to show usage details along with the correct model and version. You can find more details on database views in the official docs: Database Views.

Thanks & Regards,
Muhammad Iftikhar
If my response helped, please mark it as the accepted solution so others can benefit as well.

[nityabans27]

Hi @suresh kaliappa 
There’s no direct link between samp_sw_usage (usage) and the software model.
You need to bridge:

samp_sw_usage → cmdb_ci_spkg (installation) → cmdb_software_product_model

How to achieve it:

• Create a Database View joining these three tables.

• Use the DB view as the report source to show usage + software model + version in one report.