Is it possible to display clock in Solarwinds?

Hi all,

The SolarWinds HCO does not have internet access, it operates in offline mode.
Is it possible to display clocks in this mode in a widget?

Thanks in advance!

Kind Regards,

Attila

Find more posts tagged with

Accepted answers

Seashore

Or below to get the current time.

SELECT TOP 1
GETDATE() AS [DatetTime]
FROM Orion.Nodes

Put it in a custom query widget. Not very pretty but works...

All comments

jm_sysadmin

My first thought... No, you can't pull in extra code to make a clock.

Butmaybe you don't need a clock, you need the time. Can you can cheat and do something with the last poll time maybe? We have more than enough nodes polling for the time to appear current.

SELECT TOP 1  N.LastSystemUpTimePollUtc) as Time
FROM Orion.Nodes N 
Order by N.LastSystemUpTimePollUtc DESC

Use the functions here to format it: SWQL Functions · solarwinds/OrionSDK Wiki · GitHub

Seashore

Or below to get the current time.

SELECT TOP 1
GETDATE() AS [DatetTime]
FROM Orion.Nodes

Put it in a custom query widget. Not very pretty but works...

Attila

Thank you for your quick answer!

It is working.

jm_sysadmin

D'oh! yah that's better Seashore

Attila

Thank you for your answer too! Your solution works too.