Dashboard Query from a Service

Solved368 viewsdashboard query service
4
3 Comments

Hi all,

I created a service that contains multiple elements; so in this case also multiple tables with filtered parameters/columns/rows. All good at service level.

I would like to use only the data from the service inside of a dashboard. Using services under dashboard I get very few options. Tables in not one of options.

For example I would like to have a table where I can (left) join tables from the service.

But if I want to use a querry with "get parameter table by ID", when I chose the ID's of the service I get an error. (in my example 34907/1084 is the ID of a Service I created and which contains several tables)

How else can I achieve this ?

Thanks.

Daniel Lentoiu Selected answer as best 7th April 2025
Rene De Posada [SLC] [DevOps Advocate] commented

Hi Daniel, are you trying to get the parameters of an enhanced service? Alarms, Elements, etc.? Or is this a regular service?
Daniel Lentoiu commented

Hi Rene. This is a regular service.
I am thinking about using a query to join all the tables and use them in a dasboard.
Thanks.

1 Answer

0
1.89K 1 Comment

Hi Daniel,

If you are trying to get data from the actual elements linked to the service using the service as reference, it is currently not possible via the query UI. I can think of a couple of options to get around this though:

  1. Reference the elements directly using the same filters applied at the service level. This is the faster option, but I recognize that it defeats the purpose of having the services already filtering the data as you want it.
  2. Use a Service Protocol (you could use this one as a starting point: Skyline Service Definition Basic | Catalog) to enhance the service and create the logic needed to give you everything you need in the query. See this resource (Adding a service | DataMiner Docs) where it is explained (step 6) how to create an enhanced service.
    1. From the query UI you would then target the enhanced service element, which will give you the possibility to access the parameters once the service is enhanced.
    2. See attached gif for a short demo of this option.
  3. You could also write an ad-hoc script to retrieve the data as you need it (Configuring an ad hoc data source in a query | DataMiner Docs) and target the service configuration from the code.

Thanks,

Daniel Lentoiu Selected answer as best 7th April 2025