cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
3481
Views
3
Helpful
5
Replies

lastReportedAt time value variance

Pmeza
Community Member

Hello,

Question about the time value of 'lastReportedAt'.

I currently have a connection between Tableau Server and Meraki API data. Data is pulled and refreshed every 5 minutes from dashboard.organizations.getOrganizationDevicesStatuses(organization_id, total_pages = "all") . If I pull the data at x time, for example1:30pm, the 'lastReportAt' field shows different timestamps for each unique device (Identified by unique serial number).

Below is an example of 1 pull at 12:21:30pm on 6-21 and the timestamp(UTC time) variance for each serial device:

Each pull is for a unique device.

1st device was reported at 12:20:47 seconds, last device at 12:21:29 seconds.

I have 2 questions. Is the variance in seconds normal? and why is there a variance? I ask because I would assume if the request is being done at 12:21:30pm, then the timestamp would show 12:21:30pm for all of the devices, or in this case 3:21:30pm UTC time.

image.png

Thank you!

1 Accepted Solution

Accepted Solutions

sungod
Level 11
Level 11

lastReportedAt is the time that Dashboard last heard from a device.

Not the time of the API call.

There is no synchronisation of when devices and Dashboard communicate, each is a separate event, so each can have a different LRA time.

View solution in original post

5 Replies 5

Madhan kumar G
Level 5
Level 5

Hi,

You have mentioned "Data is pulled and refreshed every 5 minutes". Where did you set this polling interval?

Hi Madhan, the data is pulled with a Python script every x seconds (in this case 300 seconds) at the 30 second mark of a minute.

sungod
Level 11
Level 11

lastReportedAt is the time that Dashboard last heard from a device.

Not the time of the API call.

There is no synchronisation of when devices and Dashboard communicate, each is a separate event, so each can have a different LRA time.

Pmeza
Community Member

Hi Sungod,

Thank you for the fast reply! That makes sense:)

Pmeza
Community Member

As an update to this thread, I updated the code to pull data at the 55th second mark and now it pulls whatever was reported within that minute instead of showing status from 2 different minutes.

Example showing only what was reported within a specific minute mark.

image.png

Thanks everyone for your help!