Need help with SWQL query for up/down events

FormerMember

I need help developing a custom SWQL based query to show me the following:

Device, UpEvent, DownEvent, Duration, MinResponseTime, MaxResponseTime, AvgResponseTime

1. For the past 24 hours
2. This query is for part time devices so I want to show when they come online, show when they go offline and then the duration of the connection

I have tried to take several of the examples in Thwack already and found some I like however I am finding that while some of the queries work in Orion platform 2018.4 (NPM 12.34) they do not work in Orion Platform 2015.1.2 (NPM 11.5.3). I have spent more hours on this than I care to admit and hoping someone could help me out.

mesverrum

SWQL was a lot less fleshed out in 2015, i suspect you might have better luck just converting those queries back to SQL.  In fact I know that the oldest one that I personally saw was written in SQL and I converted it to SWQL to build many of the ones that float around thwack now.