CA Client Automation

 View Only
  • 1.  List of Computers and Related user Accounts

    Broadcom Employee
    Posted Jan 13, 2021 02:17 AM
    Hi Team,

    I would like to generate a report for List of  computers and Related user Accounts for each computer.
    We need this info to provide Asset Owner in Asset Portfolio Management.

    Does anyone has the query on how to get his info?
    Or maybe you can provide me the table name for relation between computers and Related user accounts.

    Thanks in advance.

    Regards,
    Pavel.


  • 2.  RE: List of Computers and Related user Accounts

    Broadcom Employee
    Posted Jan 13, 2021 02:25 AM
    Hi Pavel,

    You can try querying ca_discovered_hardware  (for machines)  and ca_link_dis_hw_user (it has the reference link between machines and the users).  The users data itself  can be picked up separately from ca_discovered_user table.

    Hope the above information will help for framing queries.

    Thanks,
    Rekha




    This electronic communication and the information and any files transmitted with it, or attached to it, are confidential and are intended solely for the use of the individual or entity to whom it is addressed and may contain information that is confidential, legally privileged, protected by privacy laws, or otherwise restricted from disclosure to anyone else. If you are not the intended recipient or the person responsible for delivering the e-mail to the intended recipient, you are hereby notified that any use, copying, distributing, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you received this e-mail in error, please return the e-mail to the sender, delete it from your computer, and destroy any printed copy of it.





  • 3.  RE: List of Computers and Related user Accounts

    Broadcom Employee
    Posted Jan 13, 2021 05:00 AM

    Hi Pavel,

     

    You can use the standard query builder and a "linked" query.

     

    Rgds,

    Steve.