28 Feb 2025
08:22 AM
- last edited on
03 Mar 2025
11:10 AM
by
MaciejNeumann
I am trying
//metrics/query?metricSelector=(remote_unix.cpu_utilization:
splitBy(dt.entity.remote_unix:host):avg):names&from=2025-02-21T00:20&to=2025-02-26T23:55&resolution=1d"//
but result time is from
22-02-2025 00:00
23-02-2025 00:00
24-02-2025 00:00
25-02-2025 00:00
26-02-2025 00:00
27-02-2025 00:00
instead of 21st to 26 why is that and
how to remove metric id from output .
api returns following columns
metricId
dt.entity.remote_unix:host.name
dt.entity.remote_unix:host
time
value
28 Feb 2025 08:52 AM
Hi
can you use this query? I'm curious to know if something changes using UTC
/metrics/query?metricSelector=remote_unix.cpu_utilization:splitBy(dt.entity.remote_unix:host):avg&from=1632096000000&to=1632700800000&resolution=1d&fields=dt.entity.remote_unix:host.name,time,value
To remove the metricId from the output, you can use the fields parameter to specify the fields you want in the response.
In this example fields=dt.entity.remote_unix:host.name,time,value specifies the fields to include in the response, excluding the metricId.
28 Feb 2025 12:24 PM
1740032221000 - GMT: Thursday, February 20, 2025 6:17:01 AM
1740593821000- GMT: Wednesday, February 26, 2025 6:17:01 PM
from=1740032221000&to=1740593821000&resolution=1d" ^
but still it returns
time
21-02-2025 00:00
22-02-2025 00:00
23-02-2025 00:00
24-02-2025 00:00
25-02-2025 00:00
26-02-2025 00:00
27-02-2025 00:00
your field selection worked