cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Is there a default fields return on DQL

henk_stobbe
DynaMight Leader
DynaMight Leader

Hello,

Sometimes I need to do a Fieldsadd, to get extra fields from my query. So I assume there are default fetched fields, and extra?

Who can enlighten me?

 

KR Henk

3 REPLIES 3

ChadTurner
DynaMight Legend
DynaMight Legend

I don't think there is a repo for all the fields present. What I typically do is pull an API call form the target entities and extract the metadata so I can then add in all the desired fields for the ADD Command. 

-Chad

DanielS
DynaMight Guru
DynaMight Guru

Hi @henk_stobbe what I do is to click on options and then I see the Visibility and order section under Columns. For me is the easy way to verify all fields returned.

DanielS_0-1759165432462.png

 

Dynatrace Certified Professional @ www.dosbyte.com

p_devulapalli
Leader

@henk_stobbe You can use the describe to extract the fields that are available for a data object

https://docs.dynatrace.com/docs/shortlink/data-source-commands#describe

From what I understand if you run a fetch against an object like "fetch dt.entity.host" or "dt.entity.kubernetes_cluster" it would by default fetch the entity.name and id fields . If you need the additional fields extracted , we would do a fieldsAdd of the needed fields . 

I guess this is to ensures that only the most needed info is included in the initial query results, reducing unnecessary data transfer and to improve query performance ( Just my understanding, not a official DT statement)

 

Phani Devulapalli

Featured Posts