Search for nodes Raw status based on Date and Time

I am tiring to search for the RawStatus of a Node based on Datetime.

This is what I have so far but I cannot figure out how to modify this to search for the date and time.

SELECT [Node].NodeID
, [Node].CustomPollerStatistics.DateTime
, [Node].CustomPollerStatistics.RawStatus
FROM Orion.NPM.CustomPollerAssignment AS [Node]
WHERE [Node].NodeID = 420

Everything I have try ends in failure.

Any ideas would be greatly appreciated.

Find more posts tagged with

orion swql

swql query

orion_sdk

query

solarwinds sdk

SWQL

Custom Query

orionsdk

SWQL Studio

swql_studio

solarwinds api

sdk

solarwinds orion sdk

orion sdk

Accepted answers

micheal100

I don't have a dataset with custom pollers set up but adding this to the where should get you it

and  addhour(-24,GETUTCDATE()) >= [Node].CustomPollerStatistics.DateTime

All comments

stuartd

[quote userid="37110" url="~/product-forums/the-orion-platform/f/orion-sdk/96481/search-for-nodes-raw-status-based-on-date-and-time"]modify this to search for the date and time.[/quote]

In what way are you trying to modify it? As in get the last 24hrs / 7days / etc, or get between certain time constraints, or ...?

jmpenney01

Yes, the last 24 hours would be good.

I need to compare two values, the current value and the last 24 hours value.

micheal100

I don't have a dataset with custom pollers set up but adding this to the where should get you it

and  addhour(-24,GETUTCDATE()) >= [Node].CustomPollerStatistics.DateTime

stuartd

Thank you Michael

jmpenney01

Yes, thank you very much