The most recent content from our members.
I am trying to find a way to delete a node from Solarwinds, using Powershell, TSQL or SWSQL. I would download a list of Nodes in Active Directory that are currently joined to the domain. This would allow Solarwinds to stop monitoring, and alerting, on Nodes that have been removed from the Domain. This is a common problem…
Hi, We've started using DPA on one of our clients sites and it's helped us a lot by highlighting some issues with some problem queries, we've now hit a bit of a roadblock because the top SQL Statements is now being listed as "/* Commit */" and i have no idea what that means or where it's coming from. When this happens the…
The various SWIS data objects (e.g. Orion.Nodes, Orion.APM.Application, Orion.TechnologyPollingAssignments) appear to be based on views in the SolarwindsOrion database. Sometimes I need to query the Solarwinds database without using SWIS, so I need to write a T-SQL query that returns the same data as a SWQL query. I can…
One of the advantages of having ciulei on your team is that he brings lots of SQL knowledge as a "not currently practicing full-time" DBA. We were trying to build a report that would let us capture nodes that were duplicates. Duplicates by IP were pretty easy: SELECT Caption, IP_Address, OwnerGroup, Comments FROM Nodes…
,1. I saw these previous posts about monitoring SQL Mirrors in SolarWinds http://thwack.solarwinds.com/message/168142#168142 http://thwack.solarwinds.com/message/165415#165415 2. Then I thought of using SolarWinds "SQL Server End User Experience Monitor" to execute a TSQL statement to pull back the status of the servers…
I am doing some integration work with our back end ticketing system for our support teams. This integration step will implement ticket auto-closure .. so that when an advanced alert is cleared .. then the Solarwinds server will signal to corresponding ticketing system to close the associated ticket. I already have the…
Hello, I need help with a report. I'm not an SQL expert and I have difficulties to do this. I want a report each week that tell me average average IN/Out and maximum peak IN/OUT for my interfaces. I used the report "Average and Peak Traffic Rates - Last 7 Days" in solarwinds and customized it a little. But what I don't…
Hi guys. I am in need for an alert that will trigger a VBScript that will update some values in an Orion table. We have two views defined - one view for all our internet connections and one view for all our servers. Once the internet connection dies I do not want to see the servers in that office marked as dead too as that…
I just wrote a question howto do a VBScript that updates some values in the Orion database once a trigger is activated but my main question must be - why can't we choose to run a SQL query in the alert? Wouldn't that be something many people could use? I know I could as that would be much easier than making a VBScript…
It looks like you're new here. Sign in or register to get started.