topic Using DQL or notebooks to pull the friendly name of relationships? in DQL

Using DQL or notebooks to pull the friendly name of relationships?

ChadTurner — Thu, 04 Jul 2024 08:34:58 GMT

Is anyone aware of a DQL statement or notebook that can be formulated to dynamically give the friendly name of entities based off relationships?

For Example HostIDXXXXXX to/from relationships in the api we get the Dynatrace IDs. In the past we had to create an api that would take the result of the Host ID GET then submit multiple gets for the relationship items that were formulated from the first GET, just to get the friendly name.

Re: Using DQL or notebooks to pull the friendly name of relationships?

Maheedhar_T — Wed, 03 Jul 2024 19:35:46 GMT

Hey @ChadTurner ,
Not sure about the Host to process correlation but host to host can be done there are two fields in dql that you can use to filter when you do "fetch dt.entity.host" they are calls and called_by which are pretty much self-explanatory.
calls: The target hosts which our host is calling.
called_by: The hosts to which our host is the target host.
So here's the dql.

maybe you can edit this and add calls and called_by in the same query but yeah this is pretty much it.
Hope this helps.

Regards,
@Maheedhar_T

Re: Using DQL or notebooks to pull the friendly name of relationships?

krzysztof_hoja — Thu, 04 Jul 2024 16:16:09 GMT

If I understand correctly, this could be a solution:

fetch dt.entity.host | filter id == "HOST-6C867CD1BF3229B0" | fieldsAdd dt.entity.process_group=runs[dt.entity.process_group] | expand dt.entity.process_group | fields dt.entity.process_group, dt.entity.process_group.name = entityName(dt.entity.process_group)

First get process groups entity IDs running on host and next lookup for their names. Result looks like this:

I used works "lookup" on purpose, because entityName (and similar entityAttr) function is easy to use wrapper of for lookup command where you can get many more entity properties in one step:

fetch dt.entity.host | filter id == "HOST-6C867CD1BF3229B0" | fieldsAdd dt.entity.process_group=runs[dt.entity.process_group] | expand dt.entity.process_group | lookup [ fetch dt.entity.process_group ], sourceField:dt.entity.process_group, lookupField:id, executionOrder:leftFirst, fields:{process_group.name=entity.name, process_group.softwareTechnologies=softwareTechnologies} | fields dt.entity.process_group, process_group.name, process_group.softwareTechnologies

Kris

Re: Using DQL or notebooks to pull the friendly name of relationships?

ChadTurner — Mon, 08 Jul 2024 13:47:03 GMT

Thank you all for your help on this!