I wrote this report, which lists active advanced alerts, along with information about the host and such. Whenever I atttempt to view this through an account with a limitation applied, I get the following: Incorrect syntax near the keyword 'Where' select NODES.CAPTION, NODES.STATUSLED, NODES.PRIMARY_ROLE...

I'm using this simple query, hoping to find out the daily max usage of any given device in the network. I'm going by this PDF: http://www.cisco.com/web/partners/downloads/765/tools/quickreference/routerperformance.pdf as a reference for estimated packets per second and Mbps. The returned PPS...

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...

I would like to include recent syslog and events in my email events that are sent. For instance, when cpu utilization is high, I would like to see the last 10 syslog messages from that server in the email that is sent. Here is my logic: Node Information: Node: ${Node.Caption} IP Address: ${Node.IP_Address...

Has anyone written a report that tells what alarm actions are configured for each node or interface? Basically I have setup quite a few alarms with various actions. Unfortunately my SQL skills are very sub par and I don’t see a report that will tell me what nodes are configured for what alarm actions...

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...

All, I'm trying to write some SQL that will populate a custom property (called AlertsPerDay) in the Nodes table. What I want is a trigger to count the number of alerts for each Node in the past 24 hours (from the AlertLog table) , and store that variable (in the Nodes table). Then I can write an...