https://community.dynatrace.com/t5/DQL/Variable-based-on-Tags-in-Segments/m-p/275886#M1991 <P>I would like to create a variable to be used in a segment that lets me filter based on tags. The idea is the tag is [AWS]ID and the values are X, Y, Z, I want to be able to filter by X,Y,Z and get their related hosts. I attempted to use the solution in&nbsp;<A href="https://community.dynatrace.com/t5/DQL/Create-a-variable-with-the-values-of-a-specific-tag/m-p/218061/thread-id/135" target="_blank" rel="noopener">https://community.dynatrace.com/t5/DQL/Create-a-variable-with-the-values-of-a-specific-tag/m-p/218061/thread-id/135</A>&nbsp;but it's repeating the [AWS]IDs so it looks like we have multiples of one ID rather than individual IDs.</P><P>My original DQL was:</P><LI-CODE lang="javascript">fetch dt.entity.host | fieldsAdd tags | expand tags | fields tags</LI-CODE><P>And the solution from the above link that I tried was:</P><LI-CODE lang="markup">fetch dt.entity.host | expand tags | summarize tags = collectDistinct(tags) | expand tags | parse tags, """((LD:tag (!&lt;&lt;'\\' ':') LD:value)|LD:tag)""" | fields tag = replaceString(tag,"""\:""", ":"), value = replaceString(value, """\:""", ":") | filter toString(tag) == "[AWS]ID" | fields value</LI-CODE><P>&nbsp;</P> Thu, 24 Apr 2025 19:43:54 GMT StephenHughes 2025-04-24T19:43:54Z https://community.dynatrace.com/t5/DQL/Variable-based-on-Tags-in-Segments/m-p/275886#M1991 <P>I would like to create a variable to be used in a segment that lets me filter based on tags. The idea is the tag is [AWS]ID and the values are X, Y, Z, I want to be able to filter by X,Y,Z and get their related hosts. I attempted to use the solution in&nbsp;<A href="https://community.dynatrace.com/t5/DQL/Create-a-variable-with-the-values-of-a-specific-tag/m-p/218061/thread-id/135" target="_blank" rel="noopener">https://community.dynatrace.com/t5/DQL/Create-a-variable-with-the-values-of-a-specific-tag/m-p/218061/thread-id/135</A>&nbsp;but it's repeating the [AWS]IDs so it looks like we have multiples of one ID rather than individual IDs.</P><P>My original DQL was:</P><LI-CODE lang="javascript">fetch dt.entity.host | fieldsAdd tags | expand tags | fields tags</LI-CODE><P>And the solution from the above link that I tried was:</P><LI-CODE lang="markup">fetch dt.entity.host | expand tags | summarize tags = collectDistinct(tags) | expand tags | parse tags, """((LD:tag (!&lt;&lt;'\\' ':') LD:value)|LD:tag)""" | fields tag = replaceString(tag,"""\:""", ":"), value = replaceString(value, """\:""", ":") | filter toString(tag) == "[AWS]ID" | fields value</LI-CODE><P>&nbsp;</P> Thu, 24 Apr 2025 19:43:54 GMT https://community.dynatrace.com/t5/DQL/Variable-based-on-Tags-in-Segments/m-p/275886#M1991 StephenHughes 2025-04-24T19:43:54Z https://community.dynatrace.com/t5/DQL/Variable-based-on-Tags-in-Segments/m-p/275888#M1992 <P>Adding the dedup command at the end of your query might help.</P><LI-CODE lang="javascript">fetch dt.entity.host | expand tags | summarize tags = collectDistinct(tags) | expand tags | parse tags, """((LD:tag (!&lt;&lt;'\\' ':') LD:value)|LD:tag)""" | fields tag = replaceString(tag,"""\:""", ":"), value = replaceString(value, """\:""", ":") | filter toString(tag) == "[AWS]ID" | fields value | dedup value</LI-CODE><P>&nbsp;</P> Thu, 24 Apr 2025 19:50:03 GMT https://community.dynatrace.com/t5/DQL/Variable-based-on-Tags-in-Segments/m-p/275888#M1992 marco_irmer 2025-04-24T19:50:03Z https://community.dynatrace.com/t5/DQL/Variable-based-on-Tags-in-Segments/m-p/275890#M1993 <P>Thank you, that helped!</P> Thu, 24 Apr 2025 19:59:48 GMT https://community.dynatrace.com/t5/DQL/Variable-based-on-Tags-in-Segments/m-p/275890#M1993 StephenHughes 2025-04-24T19:59:48Z