How can I get Dataminer hostname for an element using GQuery?

Solved912 viewsDashboard App Dashboards
1
0 Comments

Hello,

I am building a dashboard where I need the count of active elements per DMA. (I need the DMA hostname to identify it though..)

Using GQuery I can get the Dataminer Host ID per element, but I don’t see a way to get the DMA hostname.

How can I get the DMA hostname?

Thank you.

BR

Bruno Sousa

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 13th July 2023

1 Answer

2
12.83K 2 Comments

Hi Bruno,

DMA information isn’t available yet as a GQI data source. You could duplicate such information in a table parameter and join it on your aggregated result though.

We’ll put this topic on our product backlog and we’ll update this answer once it has been implemented.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 13th July 2023
Bruno Sousa [DevOps Member] commented

Hi Sebastiaan,

“You could duplicate such information in a table parameter and join it on your aggregated result though.”

Could you please share with me an example on how to do this?

Thank you.

BR
Bruno Sousa
Sebastiaan Dumoulein [SLC] [DevOps Enabler] commented

My suggestion depends on the ability to create a custom protocol (containing a table). If you have this, you could create an element and table containing a row for each DMA. In your query, you could join your query onto this table (it’s similar to how joins work in SQL) in order to enhance it with more data.