topic Re: DQL query to have specific AWS tag available as value in DQL https://community.dynatrace.com/t5/DQL/DQL-query-to-have-specific-AWS-tag-available-as-value/m-p/247662#M956 <P>Works great! Thanks <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Fri, 07 Jun 2024 09:04:46 GMT aled 2024-06-07T09:04:46Z DQL query to have specific AWS tag available as value https://community.dynatrace.com/t5/DQL/DQL-query-to-have-specific-AWS-tag-available-as-value/m-p/247419#M943 <P>In the old dashboard, I have a dynamic filter set on a specific AWS tag "<SPAN>Tag key: Custom device</SPAN> <SPAN>[AWS]environment"</SPAN></P> <P><SPAN>I'm trying to replicate this behaviour in the new dashboards, using variables<BR /></SPAN><SPAN>However, using DQL I'm failing to write a query to extract the possible values for a specific tag</SPAN></P> <P><SPAN>Here's where I am so far :</SPAN></P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="python">fetch `dt.entity.cloud‌‌sqs` | fields tags</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P>(<EM>not very far along as you can see</EM>)</P> <P>My goal is to have a variable listing all existing values for my "<FONT face="courier new,courier">environment</FONT>" tag</P> Thu, 06 Jun 2024 07:02:11 GMT https://community.dynatrace.com/t5/DQL/DQL-query-to-have-specific-AWS-tag-available-as-value/m-p/247419#M943 aled 2024-06-06T07:02:11Z Re: DQL query to have specific AWS tag available as value https://community.dynatrace.com/t5/DQL/DQL-query-to-have-specific-AWS-tag-available-as-value/m-p/247578#M954 <P>maybe this can help</P><LI-CODE lang="markup">fetch dt.entity.cloud‌‌sqs | fields tags | expand tags | filter contains(tags, "[AWS]environment") | parse tags, """LD ':' LD:value""" | fieldsRemove tags | sort value asc | summarize environments = collectDistinct(value)</LI-CODE> Thu, 06 Jun 2024 15:45:55 GMT https://community.dynatrace.com/t5/DQL/DQL-query-to-have-specific-AWS-tag-available-as-value/m-p/247578#M954 mark_bley 2024-06-06T15:45:55Z Re: DQL query to have specific AWS tag available as value https://community.dynatrace.com/t5/DQL/DQL-query-to-have-specific-AWS-tag-available-as-value/m-p/247662#M956 <P>Works great! Thanks <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Fri, 07 Jun 2024 09:04:46 GMT https://community.dynatrace.com/t5/DQL/DQL-query-to-have-specific-AWS-tag-available-as-value/m-p/247662#M956 aled 2024-06-07T09:04:46Z