DX NetOps Ver. 22.2 / about resolution=HOUR

[MARUBUN SUPPORT]

Hi Team,

Our customer has the following question.
Please advice following question.

[Product]
DX NetOps Ver. 22.2

[Question]
The customer is using an API to get device session information.
Please tell me how to calculate the output/return value when "resolution=HOUR" in "im_ActiveSessions".

The customer is considering the following method for calculating "resolution=HOUR".
1. DX NetOps calculates the average from the data of the previous hour from the timestamp when the API is executed
2. The output/return the results of calculations that are periodically executed inside NetOpS
   (Example: Saves the average value of data from 0 minutes to 59 minutes every hour, and returns the value at the time of the query)
3. If DX NetOps calculates by a method other than 1 and 2, please tell me how to calculate it.

Best Regards,
Marubun Support

[Catalin Farcasanu]

resolution=HOUR specifies the data granularity of the data that is being extracted from the system. So, if you have 5 minute polling and you get 12 values for an hour, if you select resolution=HOUR, then the system will automatically get/compute you the aggregated value for the parameter to be reported. This can either be an Average or a SUM, depending on the type of data that is collected.

[MARUBUN SUPPORT]

Dear Catalin-san,

Thank you very much for your prompt reply.
Our customer has questions related to your answer.

It is a basic question, but I would appreciate your answer.

1. Question-1

If the user wants to calculate the data for one hour, please let me know which of the following methods is used.

* Method-1
Get the average (or total) from the data for the previous hour from the timestamp when the API was executed
   Example.  If the API is executed at 12:30 on 6/1/2023, the value is obtained as follows
    1685581200  2023/6/1  9:30-10:30  Average or total for the period of  9:30-10:30
    1685584800  2023/6/1 10:30-11:30  Average or total for the period of 10:30-11:30
    1685588400  2023/6/1 11:30-12:30  Average or total for the period of 11:30-12:30

   Addendum
    NetOps performs calculations every time the API is executed.

* Method-2
Output the results of calculations that NetOps performs periodically
   Example.  If the API is executed on 2023/6/1 12:30, the value is obtained as follows
    1685581200  2023/6/1  9:00-10:00  Average or total for the period of  9:00-10:00
    1685584800  2023/6/1 10:00-11:00  Average or total for the period of 10:00-11:00
    1685588400  2023/6/1 11:00-12:00  Average or total for the period of 11:00-12:00

   Addendum
    When the API is executed, it does not calculate at that time, but quotes the results that NetOps has calculated and saved in the past.

2. Question-2

Our customer has a question about the "data that is collected" in the answer below.
> This can either be an Average or a SUM, depending on the type of data that is collected.

Please tell me which part "data that is collected" refers to in the example below.
 http://<IP Address>:<Port>/odata/api/sessionmfs?&resolution=RATE&$format=text/csv&$select=DeviceItemID,Timestamp,im_ActiveSessions &

In the case of the above example, please tell me whether it is calculated as average or total.
If the average or total is not specified, it would be helpful if you could tell me the setting to calculate the average/total.

Best Regards,
Marubun Support

[Catalin Farcasanu]

Average of SUM are specified in the Metric Family definition. The type of data defines how the Aggregation is performed.

I don't understand the basic question 1. 

The resolution=HOUR instructs the system to serve the data at that granularity. If you specify resolution=RATE, the system gives you the values, as they are collected. 

Here more info on OpenAPI advanced queries. Here more examples of OpenApi queries.