mmatec01

Very nice. Good job.

in SWQL Query to select only records with latest timestamp Comment by mmatec01 June 2017

So that works great. The only wrinkle is the fact that in Web Report Writer I am getting "*Query is not valid" error when I try to insert this SWQL statement as a selection. It works great in SWQL Studio but it fails in Web Report Writer. Just playing with it further it looks like the problem is the following clause in…

in SWQL Query to select only records with latest timestamp Comment by mmatec01 June 2017

Debugged and this works great. Thank you! SELECT N.Caption AS NodeCaption, N.NodeID, N.ChildStatus, N.Status AS NodeStatus, TOLOCAL(N.UnManageFrom) AS UnManageFrom, TOLOCAL(N.UnManageUntil) AS UnManageUntil, TOLOCAL(AE.ObservationTimestamp) AS UnManagedWhen, AE.AccountID AS Who FROM Orion.Nodes N LEFT JOIN…

in SWQL Query to select only records with latest timestamp Comment by mmatec01 June 2017

Well, the SWQL query as such works but it comes back with 0 rows. So there is something missing... debugging...

in SWQL Query to select only records with latest timestamp Comment by mmatec01 June 2017

Actually I think I just found an answer. Right here: Find muted entities - SolarWinds Worldwide, LLC. Help and Support

in Custom report to show SolarWinds objects with current - or scheduled - supressed alerts Comment by mmatec01 May 2017

I am also looking for this kind of information. I may open a case to support.

in Reporting on Oracle DBs - How to pull data from Oracle User Experience Monitor, or query Oracle database(s) directly to use it in a custom report (using SAM)? Comment by mmatec01 February 2017

mmatec01

Comments