Solved

GraphQL Query

Forum|Forum|11 months ago
May 12, 2025
5 replies
0 views

yaquaholic

Good afternoon,

I've been tasked with extracting performance data, for quarterly customer reviews, and after many hours of PowerBI M Query and trying to wrangle the data into a useable form - I still can't.
When I remembered that with GQL we can extract only what we need.
However I've spent another few unsuccessful hours trying to find the connection between the devices and their performance data.

This is as far I have I got:

query DeviceByOrgID {
devices(search: {organization: {has: {id: {eq: "39"}}}}) {
edges {
node {
id
name
ip
componentChildren{edges{node {id}}}
deviceClass {
description
class}
}
}
}
}

Could anyone show me how to extract some performance data for a device, CPU normalized hourly for example, using GQL?
Even if it's just for a single device.

Thanks

Best answer by miles_cross

Hi - You can try this.

query MyQuery {
devices {
edges {
node {
id
ip
name
metrics(collection: {id: "cpu", duration: "2d", rollupFreq: hourly}) {
info {
label
units {
label
}
}
values {
edges {
cursor
node
}
}
}
}
}
}
}

M

miles_cross
Answer
Forum|Forum|7 months ago
August 29, 2025

Hi - You can try this.

query MyQuery {
devices {
edges {
node {
id
ip
name
metrics(collection: {id: "cpu", duration: "2d", rollupFreq: hourly}) {
info {
label
units {
label
}
}
values {
edges {
cursor
node
}
}
}
}
}
}
}