I want to do the report with Installed and uninstalled Software. I am working with this query but i want to differentiate when a software was installed or uninstalled.
select ca_agent.agent_name, ca_software_def.name, ca_software_def.sw_version_label
from ca_agent
inner join ca_discovered_software
on ca_agent.object_uuid=ca_discovered_software.asset_source_uuid
inner join ca_software_def
on ca_discovered_software.sw_def_uuid=ca_software_def.sw_def_uuid
order by ca_agent.agent_name, ca_software_def.name, ca_software_def.sw_version_label.
Original Message:
Sent: 12-03-2019 05:17 PM
From: Brian Fontana
Subject: Report with all the information of installed and uninstalled
Which software do you want?
a) ITCM Discovered Software (this comes from AM)
b) ITCM Installed Software (this comes from SD)
And are you looking to do this in DSM Reporter, or are you looking for SQL?
Original Message:
Sent: 12-03-2019 05:02 PM
From: Jhon Vas
Subject: Report with all the information of installed and uninstalled
We have CA ITCM 14.0 in our production environment and we need to create a report with all the information of installed and uninstalled Software, but we don't know where the
is the table that keep this data. Can someone give me some clue?
Thanks!