CA Client Automation

  • 1.  Software Installation Date

    Posted May 13, 2019 03:42 AM

    Hi All,

     

    We have CA ITCM 14 SP2 in our environment.. We have signature and heuristic scan enabled for all agents and we are able to collect software inventories from agents.. but we are not able to see software installation date on both signature and heuristic scan, instead it is showing date created.. i believe date created refers to detection date and not acutal software installation date that are shown in ARP / Registry in windows and respectively from LINUX agents. 

     

    How to get actual software installation date from both windows and non windows servers.



  • 2.  Re: Software Installation Date

    Broadcom Employee
    Posted May 13, 2019 07:34 AM

    This has been an issue for a while. We do return the date if the date is recorded if you look most packages do not post the install date in the registry.



  • 3.  Re: Software Installation Date

    Posted May 13, 2019 09:32 AM

    Any custom solution ?..



  • 4.  Re: Software Installation Date

    Broadcom Employee
    Posted May 13, 2019 10:46 AM

    The data is just not there.  It it up to the software vendor to populate that date



  • 5.  Re: Software Installation Date

    Posted May 15, 2019 11:14 AM

    Hi

     

    i use 2 metod

     

    using WMIC query

    wmic product get Name, RegOwner, InstallDate

     

    using SqL

     

    use mdb
    SELECT hw.host_name AS Equipo, def.name AS Software, def.sw_version_label AS Version, --DATEADD(SS, def.creation_date, '19700101') as 'Colectado en fecha',
    DATEADD(s, disc.creation_date, '19700101') as 'Software Instalado' ,
    DATEADD(s, hw.creation_date, '19700101') as 'Agente instalado'
    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 Flash Player%'
    def.name LIKE '%java%'


    --and
    --hw.host_name like'%227801%'
    --and def.sw_version_label LIKE '8.0.2010.9'
    ORDER BY 'software instalado'



  • 6.  Re: Software Installation Date

    Posted May 17, 2019 06:50 AM

    Hi,

     

    How to get wmic data written into itcm mdb tables



  • 7.  Re: Software Installation Date

    Posted May 17, 2019 05:18 PM
      |   view attached

    Here is a script which uses WMIC to get the version data of a file then adds the data to a MIF (Management Information File) in the Agent's inventory collection directory. All MIFs in that directory will be added as inventory for the computer automatically. You will obviously want to modify the script to customize the WMIC command, parse the data you need from it and modify the MIF characteristics to reflect the data you are collecting.

     

    Hope that helps.

    Attachment(s)

    zip
    GetFileVersion.DMS.zip   792 B 1 version


  • 8.  Re: Software Installation Date

    Broadcom Employee
    Posted May 17, 2019 06:54 AM

    is the data you are looking for in wmic?  if you run the command locally do you see the data if so I can help you.



  • 9.  Re: Software Installation Date

    Posted May 17, 2019 09:12 AM

    Hi Richard,

     

    Yes i can able to see data while running wmic query



  • 10.  Re: Software Installation Date

    Posted May 17, 2019 09:15 AM

    I have a script you can use as an example but I'm away from my computer

    right now, I'll send it when I get back in about 3 hours

     

     

    On Fri, May 17, 2019, 08:12 Madanraj-NPCI <



  • 11.  Re: Software Installation Date

    Posted May 20, 2019 08:11 AM

    Hi Steve,

     

    Can you please help me with script