Can anyone tell me that complete requirements for the NetPerfMon User ID for the SQL Database? I am sharing a SQL database server and am having issues with the server team saying that the userid rights need to be changed. They want to remove the admin rights of the user id. Every thime they had done...

Is anyone else getting this error in their swdebugMaintenance.log file? (Yes, I have submitted a ticket to support). 2007-08-10 22:52:00,663 [5] INFO SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Finializing maintenance for VolumeUsage 2007-08-10 22:52:00,679 [5] ERROR SolarWinds.Data.DatabaseMaintenance...

Somehow I have some Orphaned Interfaces. Does anyone know how to clean that up? I'm assuming the SQL statement: UDPATE Interfaces DELETE * WHERE NodeID = '<NodeID of orphaned interfaces>' I know I have some, because I have a custom field that defaults to NULL and shouldn't be empty...

This report shows some WAN ckts > 45% use for a 5 min period. See pic. I have that working, but want to make it more readable by either doing a COUNT on the number of times the >45% hits or rolling those results into a link for the serial interface (some have hundreds of rows) or just showing the...

SQL questions for custom reports...The only lines I've added is in the WHERE section for <NodeID LIKE> part, which is a valid SQL query, but it causes the report to come back empty...any thoughts??? Also, I'm fairly new at SQL and the DateTime in the WHERE command is killing me. If I remove...

I am trying to create a report for any of my routers that have been down for greater than 15 minutes. Since Solarwinds stores availability as a percentage and I need to know the date and time that the device was down, I think the best way is to create the report off of an alert that matches my criteria...

I need to populate an advanced alert email with data from another table in the database. For example, I have an advanced alert on a custom MIB poller for an APC UPS. This alerts when the temp gets over 85 degrees in an IDF. When it triggers, I want it to send an email that says "IDF b28-1 is 87...

Can anyone help me with custom SQL reports? When I create custom reports, I usually start with one of the canned as a template and I have not been able to find/figure out the datetime (where between) stuff and get it working successfully. SELECT Convert(DateTime,Floor(Cast(DateTime as Float)),0) AS SummaryDate...

Hi Harvey, I'm also going through an audit and the sql admins are telling me that having Cirrus connect with the SA account is a security violation. Apparently they are ok with using SA during the install when the DB is being created, but not for regular access. We had this same issue with Orion...

Hi there. We have a sporadic error causing our SQL monitors to fail about 30-35% of the time. The message given is: "There were errors with either issuing the query string or its execution" ...I could understand this being related to network problems, but a) all other monitors are fine, and...