CA Client Automation

 View Only
  • 1.  SQL Query to DSM Explorer

    Posted May 25, 2018 10:33 AM



    Is there a way to replicate this MSSQL Query in the DSM explorer:


    select top 10 * from ca_discovered_hardware
    order by creation_date desc



    Ther query designer don't let us edit SQL directly...






  • 2.  Re: SQL Query to DSM Explorer

    Broadcom Employee
    Posted May 25, 2018 10:36 AM

    Create the query in explorer.  Export it then edit it.


    Get Outlook for Android<>

  • 3.  Re: SQL Query to DSM Explorer
    Best Answer

    Posted May 25, 2018 10:43 AM

    You can use this document as a reference, for importing a SQL query, as an advanced argument to the query designer:


    How to create a dynamic group of ITCM scalability - CA Knowledge 


    Check from Step 5 of that document.  The only thing that is really different, is the query you are inputting into the designer.


    You'll need to change "*" in the query to dis_hw_uuid:

    select top 10 dis_hw_uuid from ca_discovered_hardware order by creation_date desc


    DSM Explorer expects that you are returning "computers" as the return type.  Therefore the field you must return needs to be a dis_hw_uuid from ca_discovered_hardware.  Or the object_uuid from ca_agent, if querying on the ca_agent table, since ca_discovered_hardware.dis_hw_uuid == ca_agent.object_uuid



    You cannot specify "*" and have whatever columns returned to DSM Explorer.  It will only recognize the UUID of a computer, and then you can only display fields that are pre-programmed/available in the DSM Explorer column list.

  • 4.  Re: SQL Query to DSM Explorer

    Posted May 25, 2018 10:45 AM

    This document also overview and example of importing a custom SQL query, as an advanced argument, into the query designer...


    How to Create Dynamic Groups for Identifying Dupli - CA Knowledge