Clarity Client Automation

Expand all | Collapse all

Report with all the information of installed and uninstalled

  • 1.  Report with all the information of installed and uninstalled

    Posted 7 days ago
    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!


  • 2.  RE: Report with all the information of installed and uninstalled

    Posted 7 days ago
    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?


  • 3.  RE: Report with all the information of installed and uninstalled

    Posted 7 days ago
    Edited by Jhon Orion 6 days ago
    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.