marunderwood

There are no blank spaces between each column. The column width is set on the widest most data and/or heading. (I whited-out the user name in the message below, but see how the "action type" column, which contains "Orion.APM.TemplateModified" is directly next to the audit message "User ... changed template ...". Here's…

I'll give it a try. I never could get an 'email web page' to work on the previous versions.

That didn't work for me when there was more than one alert on the same node. I came up with another solution, see http://thwack.solarwinds.com/ideas/1142#comment-163548 for details.

Thanks for these explanations, although I already understood. What I'm trying to understand is how these relate to the active alert window in the Alert Manager. More specifically, why am I seeing an entry in the Alert Manager - Active Alerts window (on the SolarWinds server in the Advanced Alert Manager), but never getting…

AI needed the same information and created this report. select ad.AlertDefID, ad.AlertName, ad.TriggerQuery from AlertDefinitions ad where Enabled = 1 -- True order by ad.AlertName Message was edited by: Marlene Underwood I think this gives you the Advanced Alerts. Based on a quick test, I think the post above is the Basic…

We're on Orion Platform 2013.2.1, SAM 6.0.2, IPAM 4.1, NCM 7.2.2, NPM 10.6.1, NTA 3.11.0, IVIM 1.9.0 and the 'Order by Eventtime desc' is not working. It appears to NOT be sorting in descending order.

All of these ended up working .... (Fahrenheit: ${SQL:Select CASE WHEN '${SensorUnit}' = 'Degrees Celsius' THEN (CONVERT(int,'${SensorValue}') *(9/5)+32) ELSE 0 END}) Fahrenheit: ${SQL:Select CASE WHEN '${SensorUnit}' = 'Degrees Celsius' THEN (CONVERT(int,'${SensorValue}') *(9/5)+32) ELSE 0 END} Fahrenheit: ${SQL:Select…

Thanks for the response. The 2nd answer is what I am looking for. So, here is some more info. * The \SolarWinds\Orion\APM\SolarWinds.APM.Probes.dll.config is set to: <SnmpProcessProbeSettings BulkSize="10" PollMethod="BulkRow" MaxProcessCount="30000" RetryCount="2" Timeout="2500"/> So, are you suggesting I change the…

Here's another sample of data. Warnings were at: 1:14-15, 2:22-23, and 2:46-47. UnDP shows these warning times (based on local time). 8/8/2014 1:06:08 AMdrsBladeCurrStatus386Dell DRAC4nonCritical44URLdrsGlobalCurrStatus386Dell DRAC4nonCritical44URLdrsGlobalSystemStatus386Dell DRAC4nonCritical44URL8/8/2014 1:18:08…

Hi Rob! We just installed NPM 11.0.1 and now are converting the reports to the web-based Report Schedule Manager. Is there a document on what permissions are needed for the local account? My personal account has no specific server permissions; just access to the web-interface. The admins added a local account to run the…

Any luck? I have one server (since we migrated SolarWinds & upgraded to SAM 6.1.1) that fails a couple times a day. (I have an alert that triggers when the CPU Polling has stopped for > 60 min for the first 10 nodes) I'm having a hard time finding where the error generated is being logged. Maybe aLTeReGo can help. I found…

Another issue we have is the URL's used in the alerts does not contain the full server name, yet our SSL certificate does. So, when the URL is chosen from the email alert, a certificate error pops up. I was able to resolve this by updating the websites table's server name to the full name (servername =…

I finally got it. (You can use this on a NPM page to jump to the IPAM edit page for the Node.) https://server name removed/Orion/IPAM/IP.Edit.aspx?ip=${IP_Address}&RefUrl=IPAddressDetail

Thank you!! I too was getting the "Object reference not set to an instance of an object" ... by adding the statement to convert to string, it now works fine. (Using Powershell v 2.0) $NodeId = get-swisdata $swis "SELECT NodeID FROM Orion.Nodes WHERE IP_Address=@ip" @{ip=$ip} -errorvariable myerrorvariable --- This works…

I figured it out. I had to comment out the WHERE and ORDER BY clause and incorporate the logic in the JOINS. I may have been able to nest this within a select * from (..... ) too, but I didn't try it. p.s. I assume SolarWinds is trying to append a WHERE clause at the end of the SQL statement to incorporate the account…

Did you consider using the 'Do not execute this Action if the Alert has been Acknowledged' check box on the Action's <Alert Escalation> tab? You can also send the 'AcknowledgeURL' variable in your message to simplify marking it as acknowledged.

Vendor Avocent Machine Type AutoView 3200 - KVM

Here is the contents of my StatusInfo table.

Any luck with this? I need the same thing.

Now this is part of NPM 10.7 RC1 Now Available

I'm getting the same error, but we're working on getting our website to monitor properly. So far it's never been "UP". I'm assuming it's a website programming issue.

Look at http://thwack.solarwinds.com/thread/32277. I am going to try this query for my alert: Process: ${ProcessName} PID: ${SQL:select top 1 PID from APM_ProcessEvidence pe join APM_CurrentComponentStatus ccs on ccs.ComponentStatusID = pe.ComponentStatusID and ccs.ComponentID = ${ComponentID} order by avgpercentcpu desc}

I have the same situation. Any luck on how to fix this? Update: After poking around, I found in the VIM_VirtualMachines table where nodeid = 215 (node being reported as virtual, but really isn't) an entry for another server (name = Helper). When I ping HELPER it has a slightly different IP#. This virtual server is…

I agree.

Did you ever resolve this? I'm getting the same error after updating Windows Server 2003 SP 2.

I'm still testing this, but you can give this a try. You'll notice I wrote a couple reports that I reference in the alert. I'm not comfortable with them yet, but you get the idea. Hope this helps!! Future Need: We are currently having some db contention issues due to a new backup software app which is sharing the same…

Having the same issue and it doesn't like Lawrence's suggestion either. I tried it with column names and with the * SELECT TOP 50 * FROM ( SELECT tolocal(EventTime) as EventTimeE , '/NetPerfMon/images/Event-' + TOSTRING(EventType) + '.gif' AS [_IconFor_Message] , Message FROM Orion.Events where NetworkNode=${nodeid} order…

My sql may be a little rusty. Try this. SELECT -- Nodes.NodeID AS NetObjectID, Nodes.Caption AS Name, Nodes.Status, Nodes.MachineType, max(cpu.datetime) as Last_Poll FROM Nodes left join CPULoad_Detail cpu on cpu.NodeID = Nodes.NodeID WHERE (cpu.NodeID is null OR -- (DATEDIFF(mi, DateTime, getdate()) > 10) (DATEDIFF(mi,…

After running some more tests without using the AcknowledgeURL (I just went to the alert page of the web console), I was able to get the note to come out. I changed the substring in the SQL stmt to start in position 1 (instead of 16) because depending on how I enter the text, it's either prefixed with the word…

Why can't I find this conversation? The only way I can find it is because I tagged it. I added it while in the alert lab. Do I need to move it?