The most recent content from our members.
With the help of antonis.athanasiou (yay MVP collab!), I came up with the following born out of need: SELECT TriggeredDateTime,OAA.AlertObjects.Node.Caption as [Node] --find nodes,OAA.AlertObjects.Node.CPULoad --change this to any relevant node metric,OAA.AlertObjects.Node.DetailsUrl as [_LinkFor_Node] --add hover…
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]…
IS there any way to add a clickable link on a custom resource like we can embed into reports? this is a major hurdle for me switching and adopting custom resources and swis more fully.
We have around 5k volume elements being monitored on one of our polling engines, which is roughly 50% of the currently elements being monitored on that polling engine. We do not currently need to be monitoring these volumes, and, as many people may already know, removing volumes in bulk is not as easy as it should be, yet.…
In an effort to try to remove custom coded resources and replace them with the native "Custom Query" resource, I have run into an odd issue that I can't find any information on why or how to work around. I am trying to produce a simplified list of nodes and their status, similar to the "Nodes with Problems" resource, but…
Hello Chaps, Have an odd issue where a custom query on the AlertStatus table is showing all alerts triggered 1 hour before they were actually triggered, I have checked the Database directly using the same query (modified) and this returns the expected results which are shown below. Select AlertStatus.TriggerTimeStamp,…
Hello, I am working on making a "Acknowledged Alerts" custom query. I have got a basic one working, which is using the following SWQL: SELECT tolocal(Status.TriggerTimeStamp) AS [Time of Alert], Status.ObjectName AS [Alert], Defs.Name AS [Category], tolocal(Status.AcknowledgedTime) AS [Acked Time], Status.AcknowledgedBy AS…
Hi, I want to filter my Last Events list so that only events with NetPerfMon Event Log text "EXAMPLETEXT" show up. Can I use Custom Query to make this happen? And if so, does anyone bother to help me with the SWQL-script? Thanks, Simon Eidem
I added the Universal Device Pollers for the APC Environment Monitors and would like to create a custom query that displays in tabular format each device and respective temperature etc. eg Hostname Temp (Deg C) --------------------------------------------------------- EMA001 23 What query do i need to run in order to get…
It looks like you're new here. Sign in or register to get started.