Hi,
I wanted to extract the type, edition and versions out from the technologies to be different columns in a table as well as do a bar chart specifically for type.
"<strong>monitoringMode</strong>": "FULL_STACK",<br>"<strong>lookup.entityId</strong>": "PROCESS_GROUP_INSTANCE-61A60B5D26F3BB1B",<br>"<strong>lookup.entityName</strong>": "com.dynatrace.easytravel.weblauncher.jar easytravel-*-x*",<br>"<strong>lookup.softwareTechnologies</strong>": [<br>"type:QOS_LOGBACK,edition:null,version:1.2.3",<br>"type:APACHE_TOMCAT,edition:null,version:7.0.93.0",<br>"type:JAVA,edition:OpenJDK,version:11.0.5",<br>"type:JDK_HTTP_SERVER,edition:null,version:null",<br>"type:APACHE_TOMCAT,edition:null,version:null",<br>"type:JAVA,edition:null,version:null",<br>"type:APACHE_HTTP_CLIENT_SYNC,edition:null,version:4.5.10"<br>],
Secondly, is there any way for me to change the name lookup.softwareTechnologies to just softwareTechnologies. As I couldn’t access it with the “.”
<span>monitoringMode</span>: record.<span>values</span>?.<span>monitoringMode </span><span>as string</span>,<br><strong>softwareTechnologies: record.values?.softwareTechnologies,<br><br>Failed with : <br><font color="#FF0000">softwareTechnologies: record.values?.lookup.softwareTechnologies,</font></strong>
DQL:
<span>fetch dt.entity.host, timeframe:"2023-03-01T00:00:00Z/2023-04-05T12:00:00Z"</span><br>|fieldsAdd osVersion, cpuCores, memory = (memoryTotal/1000/1000000), ipAddress, monitoringMode<br>|lookup [fetch dt.entity.process_group_instance<br>|fieldsAdd softwareTechnologies, tags |filterOut contains (entityName, "OneAgent") OR contains (entityName, "Linux") OR contains (entityName, "sshd") OR contains (entityName, "Short-live") OR contains (entityName, "master") ], sourceField:tags, lookupField:tags

