SQL Query to DSM Explorer

[Remy Dessureault]

Hi 

 

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...

 

 

Thanks!

 

Remy

[lecri01]

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

 

Get Outlook for Android<https://aka.ms/ghei36>

[Brian_Fontana]

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.

[Brian_Fontana]

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