https://community.dynatrace.com/t5/DQL/Get-value-from-key-value-pair/m-p/224267#M269 <P><SPAN>Hi team, want to have the result CS-MONITORING, how</SPAN><BR /><SPAN>fetch dt.entity.host</SPAN><BR /><SPAN>| expand tags</SPAN><BR /><SPAN>| filter contains(tags, "invoiced_team")</SPAN><BR /><SPAN>| summarize str_tags = collectDistinct(tags)</SPAN></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="OustiDiousti_0-1695998820075.png" style="width: 400px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/14381i349321408F3C9E26/image-size/medium?v=v2&amp;px=400" role="button" title="OustiDiousti_0-1695998820075.png" alt="OustiDiousti_0-1695998820075.png" /></span></P> <P>&nbsp;</P> Mon, 02 Oct 2023 07:54:02 GMT OustiDiousti 2023-10-02T07:54:02Z https://community.dynatrace.com/t5/DQL/Get-value-from-key-value-pair/m-p/224267#M269 <P><SPAN>Hi team, want to have the result CS-MONITORING, how</SPAN><BR /><SPAN>fetch dt.entity.host</SPAN><BR /><SPAN>| expand tags</SPAN><BR /><SPAN>| filter contains(tags, "invoiced_team")</SPAN><BR /><SPAN>| summarize str_tags = collectDistinct(tags)</SPAN></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="OustiDiousti_0-1695998820075.png" style="width: 400px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/14381i349321408F3C9E26/image-size/medium?v=v2&amp;px=400" role="button" title="OustiDiousti_0-1695998820075.png" alt="OustiDiousti_0-1695998820075.png" /></span></P> <P>&nbsp;</P> Mon, 02 Oct 2023 07:54:02 GMT https://community.dynatrace.com/t5/DQL/Get-value-from-key-value-pair/m-p/224267#M269 OustiDiousti 2023-10-02T07:54:02Z https://community.dynatrace.com/t5/DQL/Get-value-from-key-value-pair/m-p/224268#M270 <P>Hi&nbsp;<a href="https://community.dynatrace.com/t5/user/viewprofilepage/user-id/55612">@OustiDiousti</a>&nbsp;</P> <P>Please check out our documentation about how to query entities in Grail:&nbsp;<A href="https://www.dynatrace.com/support/help/platform/grail/querying-monitored-entities#entity-tags" target="_blank">https://www.dynatrace.com/support/help/platform/grail/querying-monitored-entities#entity-tags</A></P> <P>Basically you need to expand the array of tags and parse it</P> <P>&nbsp;</P> <LI-CODE lang="markup">fetch dt.entity.host | expand tag_string=tags | filter contains(tag_string,"invoiced_team") | parse tag_string, """(('['LD:tag_context ']' LD:tag_key (!&lt;&lt;'\\' ':') LD:tag_value)| (LD:tag_key (!&lt;&lt;'\\' ':') LD:tag_value)|LD:tag_key)"""</LI-CODE> <P>Best,<BR />Sini</P> Fri, 29 Sep 2023 14:54:51 GMT https://community.dynatrace.com/t5/DQL/Get-value-from-key-value-pair/m-p/224268#M270 sinisa_zubic 2023-09-29T14:54:51Z