The most recent content from our members.
How is it possible to add the polled time for a custom poller to this query below? I am unable to use the inbuilt SolarWinds widget as it displays unwanted information (chart values which are presented on a separate widget). SELECT a.CustomPollerName AS Name, a.CurrentValue AS Value FROM Orion.NPM.CustomPollerAssignment a…
Hi Guys, Is there a way where we can add the date and time of when the device was onboarded onto SolarWinds in the device details page? Please let me know .
Hello everyone, I managed to reach a SQL call that helps me a lot, but when using this query the date is coming with a very different time and date, like a week ago. Has anyone had a problem like this using Syslog tables via SWQL? Note: I'm using this in a modern dashboard My query: SELECT TOP 100 DateTime, Level, Message,…
I need to change a datetime format on a specific report. So in timestamp column I tried using all date formats possible, but it still show date as dd/MM/yyyy. What is the porpouse of custom datetime format if it doesnt work.
Hi All - First of all thanks for trying to help me out. We have a Customer owned SolarWinds Orion NPM 12.1 installation which is integrated to an upstream OSS aggregation solution via SNMP. We are leveraging a custom SNMP Alert Template to work around some of the contextualisation issues the default one OOTB provided by…
Hello Everyone, I am trying to reconcile(fetch) list of users from Orion Account table via SWQL query.But i want to get the list of users whose proerties are changes from last X days (Say 10).I.E i dont want whole data and only data modified after certain date. Is there any swql Query which can help me to get Data for…
HI! I have tried to build a simple query to fetch all EventTime from Event - table using the SWQL Studio (SDK 1.5). The query is as simple as this: SELECT EventTime FROM Orion.Events; The result is returned as yyyy-MM-DD HH:mm:ss. I have also tried to query the database directly using: SELECT EventTime FROM dbo.Events…
This is an example script from my toolkit that helps me to quickly review the various different ways of performing date math in sql server. Demo available here
Hey all, Does anyone have a way of showing the current system time on a NOC view? On any other view there is a date line in the upper right that shows the info (such as "Wednesday, July 16, 2014 2:47:58 PM"). However, on the NOC view there is no similiar information anywhere on the view. This is problematic for our usage,…
It looks like you're new here. Sign in or register to get started.