- What Grafana version and what operating system are you using?
v8.2.6 -
What are you trying to achieve?
Join query on windows metrics to view processes by the service display_name -
How are you trying to achieve it?
using a join query - What happened?
Found duplicate series for match group - What did you expect to happen?
unique - only one pid can exist on instance - Can you copy/paste the configuration(s) that you are having problems with?
sum((rate(windows_process_cpu_time_total{mode!=“idle”}[$__rate_interval])) * on(instance, process_id) group_left(display_name) windows_service_info{display_name=~“$process”}) without (mode,process_id)
- Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
“found duplicate series for the match group {instance="host1", process_id="0"} on the right hand-side of the operation: [{name="windows_service_info", display_name="", env="prod", host="host1", instance="host1", job="", name="", process_id="0"}, {name="windows_service_info", display_name="process1", env="prod", host="host1", instance="host1", job="job1", name="ame_46", process_id="0", region="us"}];many-to-many matching not allowed: matching labels must be unique on one side”
- Did you follow any online instructions? If so, what is the URL?