Current time vs timestamp

I am trying to show age for specific server from the last time seen to current time.
How do I get current time stamp in NRQL and substract timestamp from this?

example query:

SELECT (latest(current_timestamp) - max(timestamp) ) as duration from NETWORK facet by hostname

There is no Now() function in NRQL to return the current timestamp. This type of delta time is difficult to calculate without querying and then applying that calculation locally.

1 Like