topic Field with only a certain key:value tag using DQL in DQL

Field with only a certain key:value tag using DQL

Himavanth_Reddy — Thu, 13 Mar 2025 07:04:44 GMT

I want to get a field with only a certain key:value tag using DQL.
example: Host Name | Host group name | Datacentre:xyz
this Datacentre tag is already defined in my environment.
How to achieve it?

Re: DQL

Kenny_Gillette — Wed, 12 Mar 2025 12:42:53 GMT

Here you go:

fetch dt.entity.host
| fieldsAdd tags, hostGroupName
| filter matchesValue(tags,"TagName")

Re: DQL

PacoPorro — Wed, 12 Mar 2025 12:52:24 GMT

Slightly improved

fetch dt.entity.host | fieldsAdd tags, hostGroupName | expand tags | filter contains(tags,"Datacentre") | fields entity.name, hostGroupName, tags

Re: DQL

Himavanth_Reddy — Wed, 12 Mar 2025 13:21:49 GMT

Working. Thanks!

Re: DQL

Kenny_Gillette — Wed, 12 Mar 2025 14:59:12 GMT

I found a great use case for this today!!! love this