cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Highlighted
Level 10

Re: Need Help Converting SQL Report Writer Code to SWQL - Down Time Duration

Is there a chance this table of functions could be added to the KB article: SolarWinds Knowledge Base :: How to use SolarWinds Query Language (SWQL)

0 Kudos
Highlighted
Level 19

Re: Need Help Converting SQL Report Writer Code to SWQL - Down Time Duration

Thanks for the tip. I sent a note to our doc team to get that article updated.

0 Kudos
Level 10

Re: Need Help Converting SQL Report Writer Code to SWQL - Down Time Duration

Is there a complete list of functions anywhere.  I have spent a lot of wasted time trying to locate things on this site and to be honest, this site has bits and pieces of information all over the place which makes it time consuming to locate.

0 Kudos
Highlighted
Level 19

Re: Need Help Converting SQL Report Writer Code to SWQL - Down Time Duration

The complete list of functions is in this thread just above. It will be in the Orion SDK document as well as soon I can finish the SDK 1.8 release.

0 Kudos
Highlighted

Re: Need Help Converting SQL Report Writer Code to SWQL - Down Time Duration

tdanner - thanks for adding the functions into the SDK Tech Reference doc - I see ToLocal() and changetimezone() which are helpful - but is there any plans to really support dateadd for when we want more flexibility then simply UTC <-> local time or timezone changes?

0 Kudos
Highlighted
Level 19

Re: Need Help Converting SQL Report Writer Code to SWQL - Down Time Duration

We didn't have plans for a DATEADD function yet, but that's a very reasonable thing for us to include. I opened a feature request for it. 308248 is the internal case number.

0 Kudos