CA Client Automation

  • Private Community

  • 1.  how is it possible for me to add additional data(field) to agent using excel?

    Posted Nov 27, 2015 02:57 AM

    How am I going to upload data using excel sheet to the additional field (as per screen capture)? for example I want to add value to the department field.

     



  • 2.  Re: how is it possible for me to add additional data(field) to agent using excel?
    Best Answer

    Broadcom Employee
    Posted Nov 27, 2015 06:16 PM

    Hi Razif,

     

    I do no see easy method to do this.

    One solution is to create a script which read the values from the excel files and generate some <host_uuid>.I99 files and put them on sector.

     

    For example if the hostuuid of the machine Is CECEAB10-0046-4C7D-0000-000000000000, create a file CECEAB10-0046-4C7D-0000-000000000000.I99 containing these lines with the value for Department :

     

    M000101[User Template]

    M000201[User Template|Company Information]

    M00010500Department|Test_1

     

    Then put this file in sector directory under C:\Program Files\CA\DSM\ServerDB\SECTOR\COLLECT\00000001

     

     

    Engine will collect this file and put the department value in the User Template of the machine :

    Untitled.png

     

     

    You could find the hostUUID on the registry on the machine under HKLM\Software\ComputerAssociates\HostUUID (HKLM\Software\Wow6432Node\ComputerAssociates\HostUUID on 64 bits machine) or in mdb database with this SQL query :

     

    select host_uuid from ca_discovered_hardware where label='computer_name'

     

    Thanks

    Regards,

    Jean-Yves



  • 3.  Re: how is it possible for me to add additional data(field) to agent using excel?

    Broadcom Employee
    Posted Dec 01, 2015 05:58 AM

    HI Razif

     

    do you need any further assistance on this?

     

    Rich



  • 4.  Re: how is it possible for me to add additional data(field) to agent using excel?

    Posted Dec 15, 2015 09:40 PM

    Hi,

     

    I'm looking for one time data upload. is there any tool that we can use, tool like grloader for cmdb.

     

    Regards