The most recent content from our members.
Hi everyone, I'm trying to create a custom widget that shows a log of AP (Access Point) state changes when viewing the node details page. We monitor our APs as ICMP-only nodes so we can draw them on network maps. In SQL, I managed to correlate the necessary tables to track when APs connect or disconnect from WLCs. Here's a…
Greetings Thwack, Since upgrading to Orion Core 2019.2, NCM 8.0, I've been experiencing issues with SWQL queries against the NCM.Nodes table. Any SWQL query I write in SWQL Studio or in a Custom Query widget that involves the NCM.Nodes table always seems to return 0 rows. This issue even happens in SWQL Studio when I…
Looking for a way in swql to show monthly availability for a group of servers tied together by a custom property . Can either be proportional or chart. I can do it as a timesieries but that doesn't look as sharp as the rest of the dashboard/report card I am creating. Thanks
Hi, I am having trouble converting the nodes last response time from UTC to my Local time in Modern dashboards, below is the query I inserted and showed it is valid before saving, but after saving it I get an error, which seems ToLocal function doesn't work on Modern dashboards! are there any other ways that I can apply…
I have the following query that I've harvested off of THWACK and it works w/o an issue however I'd like to be more granular and filter on the Vendor. SW's is shared by a few teams and each team has it's own dashboard for easy digestion of events and status. I'm not savy w/ SQL or SWQL and I need to recycle this query (if…
One of my SolarWinds priorities is displaying as much actionable information as possible without burning up half the screen with empty panels. This panel has been through a number of revisions, but is (more or less) useful now. This SWQL Custom Query creates a panel that consolidates: * Nodes with High Packet Loss * Nodes…
So I might be thinking about this completely wrong but I have been digging around THWACK and found some really good information and want to make sure what I want to do I can actually do, 1. I setup a custom SAM template and applied it to all of my DCs to monitor for Event ID 4740 when a user gets locked out. 2. I have a…
I'm attempting to get distinct values from an swql query in a custom query widget, but always receive an error after adding the DISTINCT clause. Example: SELECT Caption From Orion.Nodes ---> Returns all node names SELECT DISTINCT Caption From Orion.Nodes ---> "There was an error processing the request" This doc…
Standard MVP collab with dgsmith80 , mesverrum , m_roberts birthed a tiny little volume baby. So, here's a query and a search string to filter for some volumes, based on them being >80% full and <5GB free. This one's a two part query for the search vs the regular part SELECT FullName AS [Node]…
It looks like you're new here. Sign in or register to get started.