zackm ✭✭✭✭✭

The issue is that there is a 'Status' column present in both tables, and you need to identify which one you want to 'SELECT' Try this: SELECT STATUS.STATUSFROM CustomPollerAssignment AS Assignment,CustomPollerStatus AS STATUSWHERE Assignment.CustomPollerAssignmentID = STATUS.CustomPollerAssignmentIDAND Assignment.NodeID =…

Just to add to this thread for future searchers; there are new fields required to make this work in PowerShell. Working example below tested in Platform 2017.1.3 SP3. This was purpose-built for creating a few hundred dependencies for remote sites, you can edit the $dependencyQuery to suit your needs. #region Top of Script…

Try this in the web report writer using a SQL datasource: --Here we are declaring our variables for our reporting time periodDECLARE @startDate DATETIME = (GETDATE()-7) -- 7 days agoDECLARE @endDate DATETIME = GETDATE() -- NowSELECTcar.GroupNamecar.GroupName ' Group Name',cav.DateTime 'Date',avg(cav.Availability) 'Average…

What does the database show? SELECT * FROM Volumes (nolock) WHERE Caption LIKE '%ss2bv4p-dc%' The "StatCollection" column should show you the current polling interval. The default for NPM is 15 minutes, and your screenshots look accurate, so I am not sure why you're only getting results every 30.

what columns do you want in the report?

without custom SQL? sure, we can use SWQL All kidding aside, this is not really accomplished within the native GUI from my experience. If you want to look at customizing something, let me know and I can help you out. -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook:…

email sent with some screenshots of a recent one I am particularly fond of Common comments/complaints/requests from Students and Clients: * Slowness of Network Atlas (NA) * "Antiquated" GUI * Lack of one-way interface utilization color-coding (currently you must be monitoring both ends of a point-to-point link to get…

2 ways that I can see immediately: If you added VLANs to monitoring during your initial discovery for NPM, you can go to 'Manage Nodes' and simply search for the VLAN # as an interface and you will get a result set of all instances you are currently monitoring. You could also do this as a custom report using sql as so:…

Try this (hide the NodeID field from the results set to make the device names hyperlinks to the node details page for each one): SELECT N.NODEID, N.CAPTION AS 'DEVICE', N.LOCATION AS 'LOCATION', CPS.STATUS AS 'CURRENT STATUS', CPS.DATETIME AS 'LAST POLLED'FROM NODES NJOIN CUSTOMPOLLERASSIGNMENT CPA ON N.NODEID =…

My initial thought would be to use NCM to run a report that would pull the NTA desitnation from your devices... Without NCM, I would probably want to go digging through the Fastbit Database. I do not have an additional poller to confirm, but this might get what you're looking for. Just make a web report and set this as the…

Not sure how to do this with an alerting overview, but I know you can setup an embedded report on a dedicated summary page and then just iFrame that. Let me know if that would work and I can find my query for it.

If you only care about the last boot time, this will take care of your needs (with the understanding that the metric is not available for ICMP-only devices) SELECT *FROM dbo.NodesWHERE LastBoot < DATEADD(year, -1, GetDate()) If you need a report that shows all devices with 100% availability for the last 1 year, that's…

wake up and login; welcomed by 301K points TFW 300k no longer means Top 10

A couple of things: 1) Try adding the device through a Network Sonar Discovery versus manually through manage nodes. If ICMP fails during a discovery, you will know upfront versus having to wait for a polling cycle to complete 2) Do you have more than one SolarWinds polling engine? The ICMP will come from the assigned…

for reference; updated videos are available https://www.youtube.com/watch?v=FbSTykGewoA https://youtu.be/oMVuhLL2X20?list=PLSAG2TJPvS5aj8CWVFwnSDmjZZI9D2vru (videos 17 – 22) -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems * Twitter: @Loop1Systems

I would start by checking the Alert Log in the website (by default this is a link from your Home tab menu bar) to get a handle on the root problem. I might even suggest an RDP to your Primary server and then using Advanced Alert Manager to temporarily disable the alert you are receiving (or edit it to add the device name…

So there are a couple of options here: * You can create a custom SQL (or SWQL) alert that joins the Node and Applications tables together to create a single alert* For Example: (note that this is STRICTLY an example and aboslutely is not intended to meat your current goals, it's just a rough draft) SELECT Nodes.NodeID,…

It sounds like the chart is only displaying the top 10 devices. Go to Settings > Web Console Settings and increase the # for the following field: Please note that this is a universal setting that can negatively affect your website load times. I generally try to keep this number to < 20, but every environment will be a…

Most alerts also have what is called a "Reset Action"; this is probably the result of the component going back into the "Up" status, and your tools are telling you all is well again. Couple of notes: * I really prefer to begin the subject of my notifications with either "TRIGGER: " or "CLEAR: "; to avoid confusion. * You…

You're not calling an actual SWIS entity with this line: where AlertHistory.AlertObjects.RelatedNodeID='${NodeID}' The entity is Orion.AlertHistory If you want to use a table alias, try it this way: SELECT h.AlertObjects.AlertConfigurations.Name AS [ALERT NAME] ,ISNULL(h.Message,'') AS [MESSAGE]…

I'm working the same issue at a client's location right now. Would there be any way you could share your device template with me (or the whole community in the content exchange)?

You would want to select the Custom Node Poller as your content type: -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems * Twitter: @Loop1Systems

what you're asking for combines two separate alert conditions unfortunately. node reboots are identified by a change to the LastBootTime of a device. this is gathered through an SNMP (or WMI) query, which means that you're not notified until the node is already back up. because of that, you're not going to find a condition…

I'd back out of the SQL script and use the web report writer to build your own, based on this style: Use Report Manager to configure business hours in web-based reports in Orion Platform - SolarWinds Worldwide, LLC. Help … Ignore the "NPM" part, this works for any data with a timestamp in the Orion platform.

OK. So, without looking at a server to verify, I'm 85% sure that your issue is in your alert trigger query calling for Node.Status = Down. The way groups are created in SolarWinds is by defining their members as objects, not nodes. Objects can be pretty much anything. Nodes, interfaces, app.ication monitors, component…

did you create those groups statically or using dynamic queries?

You can make something like this as a Custom Query Resource that you can then embed on a dashboard SELECT n.Caption AS [DEVICE] -- Device Name ,n.DetailsUrl AS [_LinkFor_DEVICE] -- Create a hyperlink to take you to the node details page ,n.IPAddress AS [IP ADDRESS] -- Device Polling IP FROM Orion.Nodes AS [n] -- We're…

Can you rephrase your question? Using NetFlow Settings > Manage Applications and Service Ports > Add Application brings up this screen: Here, you can define the Application Name ,Service Port, Protocol, and (optionally) define endpoints based on IP Address Groups you have created (NetFlow Settings > IP Address Groups) Is…

Easiest way to ID potential scope issues is to Download and Install the SDK, and then use SWQL Studio to verify your alert scope Click the little drop down arrow on the right, then select "Show SWQL" Remove the "WHERE Status = xxxx" and then run the resulting query in the SWQL Studio app and verify you're seeing the nodes…

Sure thing. There's actually a table in the database called dbo.EventTypes that enumerates this data for you: SELECT EventType, Name FROM dbo.EventTypes You can also tie the enumerated name into event reports as such: SELECTCONVERT(CHAR(24),e.EventTime,113) 'Event Time',n.Caption 'Node',t.Name 'Event Type',e.MessageFROM…