A user has a question about displaying online and offline devices using the ‘last_communication’ property with a range filter. Members suggest using a range filter on any other metric or playing around with the advanced editor to modify the JSON. They also suggest looking at more advanced features and plans for the future. The possibility of linking one table to two indexes is discussed, but is not currently supported. A different solution is being looked into for the future.
Read the entire ‘Displaying Online and Offline Devices with ControlUp’ thread below:
Hey,
I like to see how many devices are online and how many offline. For this, we need to make use of the ‘last_communication’ property with a range filter.
Unfortunately, this property is not selectable in the filter list. Thereby we can’t make the value variable something like, pick ‘currentDateTime’
Hi Rico, This is true we dont support range filter on dates at the moment. @member
Are you trying to do this in real time? Like you want to see you have X devices of which Y are online?
Or are you trying to do this as a time series?
Monday, 10 devices online out of 15 total
Tuesday, 14 devices online out of 16 total
Wednesday, 12 devices online out of 19 total
@member real time. With the builtin session index, we can do a more like time serie when a device is online.
Use a range filter on any other metric. Export the widget. Modify the JSON. Replace your placeholder with last_communication
@member wow you are amazing. Thank you very much! Are there some more hidden filters like "all data from today". For example, I want to so show how many sessions are created today (without the global filter options).
Mess around with the advanced editor (at your own risk). And take a look at some of the more advanced things Chris and Isaiah have done with the AI and scripting reports. Like calculating what percentage of a total some script runs fails, succeeds, etc


Will do, thanks for pointing me to the right position @member. I appreciate your help!
now/d is the solution 🙂
Cool. Play around with both the expert builder and modifying the JSON. Chris and team have a bunch of plans around some of the features currently only accessible via expert builder and/or JSON edits. But it’ll give you early access essentially.
Ahh yeah you can hack the range filter in the Advanced editor looks like there we dont validate on number (yet 😛) no but this is a good solution ! @member
Isaiah already "ruined" my fun by validating the 50 max groupings 😉
Less validation!
Haha I struggle with the max 50 items limit too. But I can see the reason behind it; it’s a dashboard .
Yeah you can see more in reports. A grid viewer with paging is on the backlog !
Is it possible to link 1 table to 2 indexes? For example I want a table with: Device Name, Count (of event IDs), product version
Device Name and Event IDs are linked to the winEvent index. Product version to Installed Applications.
Hi Rico we do not support this. That would mean doing a for each on one table to the other and will result in A LOT of queries and your dashboard will not load anymore. We are looking into a different way to solve this in the future !
Thanks @member! Amazing 🤞
Continue reading and comment on the thread ‘Displaying Online and Offline Devices with ControlUp’. Not a member? Join Here!
Categories: All Archives, ControlUp Dashboards, ControlUp Scripts & Triggers
