Software inventory ITCM

[Anon Anon]

hi there I am using CA IT CLient Manager 12.5
I now try to find a step by step guide how to create an overview of all our Adobe Products installed in the organization.
I can not figure out by trying.
I need a report containing the PC Name and which Adobe products are installed in which version.
Can anyone give me some clues?
Merci

[Anon Anon]

Are you trying to use the classic reporter or BOXI?

[Leandro Zampieri]

If you are using the signatures scan data you can do as follows:

In DSM Explorer go to ".../Software/Definitions/Categories" and create a new category.
Then select "All Definitions" and put all definitions into the new category.

Now open DSM Reporter, create a new report.
Select Fields > Add > Software > Signature Scan > "category" > Releases > Any > ...

Regards
Leandro

[Anon Anon]

If you are comfortable with creating SQL queries and directly querying your ITCM database using SQL Server Management Studio or something similar, I would recommend using something along these lines:

SELECT hw.host_name AS Asset, def.name AS Software, def.sw_version_label AS Version
FROM dbo.ca_software_def AS def
INNER JOIN dbo.ca_discovered_software AS disc ON def.sw_def_uuid=disc.sw_def_uuid
INNER JOIN dbo.ca_discovered_hardware AS hw ON disc.asset_source_uuid=hw.dis_hw_uuid
WHERE def.name LIKE '%Adobe%'
ORDER BY Software, Asset

This will return any discovered software with the text "Adobe" anywhere in the Software Signature name along with the computer name and the version.

If you are not familiar with SQL, I recommend an "Introduction to SQL" community college course or other SQL training as it is invaluable in collecting the data you want from the ITCM database. (or any other database for that matter)