Detroiter

Yes, this would be oh great use in my environment since we are GCP-centric.

In addition to those mentioned, I am looking forward to mandatory custom properties. We use those to drive alert notification behavior and when they are left blank, alert go and die in the ether. So I have to police other teams to make sure they do it right.....WELL NO MORE! Nice.

I just came across a perfect need for this feature. I have several different application templates that all belong to the same app team. Some they want to be notified on immediately since response time is critical. Others are prone to false positives since they do live app delivery which cycles the JMX connection causing…

Excellent workaround!

This is true for HP servers as well. Two identical servers, one on WMI and one on SNMP. The WMI server does not display any BATTERY information. And as anyone who has worked with HP's in the past knows, those battery fail frequently.

This ability would have a widely felt impact in my environment.

Andy, That is looking like the most probable answer. I deleted a virtual node and readded it without an SNMP string (ICMP only). It showed up as Physical in the Node Details page. Once I re-entered the SNMP string, it recognized it has a VM. If that is the case and it is reading from a particular MIB over SNMP, can that be…

Hmmm...I see what you mean. The filtered query works fine in SQL Management Studio, but when added to an actual alert it does not. Of course this is also relying on the test feature of the advance alert manager which does not always act the same as an actually fired alert would act. I will have to look more into this as…

As I indicated previously, the all of the VIM tables in my database are empty. I assume this is because I have not discovered any of the ESX hosts or VCenter servers. However, dispite that, the Node Details page is still able to discern whether a node is physical or not. Can anyone tell where the Node Details page is…

It is a one man (me) show over here so upgrades have to wait until I can get to them. 

Well I was able to get a work around (thanks to the Alert Lab board) here http://thwack.solarwinds.com/thread/51586 I would still like the feature request to stay open since I believe it warrants a more permanent solution.

No worries. ${SQL:SELECT cast(cast([ComponentName]as varchar(max)) + '' + '--' as XML), cast(cast([StatusOrErrorDescription]as varchar(max)) + '' + CHAR(10) + CHAR(13) as XML) FROM [EG-ORION].[dbo].[APM_AlertsAndReportsData] where ApplicationId = ${ID} AND ComponentStatus != 'up' FOR XML PATH('')}

Read some of the documentation for using Blat. Not sure I can commit the resources to learning that tool not to mention configuring the recipient text files to have the correct DL's based on the APM_CustomProperty table. Is it all possible to duplicate the existing macros to work with the APM_CustonProperty tables?

rsprism, I just spotted this reply, sorry for the delay. I use iFrames inside of custom HTML resources. Here is what i have that works for IE and other browsers since they handle iFrames differently. Gives it a nice big window to work with. <!--[if IE]> <object width = "100%" height = "400"…

Well the more tables that are drawn from, the longer the report takes to generate. Since i cannot create indexes on linked servers, there is not much I can do to optimize the query. But since time is the driving factor, presorting on "Trigger Time Stamp" makes the most since. I fully agree that the EOC is lagging behind…

This appears to be UAC related. In 2008 R2, when UAC is left at the Default level, both RPC and WMI calls fail using a new local admin account, while the built-in works. When UAC is lowered to either the next level down or to OFF, the WMI and RPC calls work as they should. In 2008 NON-R2, since UAC is only a check box, it…

Support got back to me very quickly with a workaround. https://support.solarwinds.com/Success_Center/Network_Configuration_Manager_(NCM)/NCM_Administrator_Guide/180_Configure_automatic_login/030_Using_the_DirectLink_account Never would have found the article because I do not use NCM. But my testing with that account have…

I am still on 6.0, but even on 6.1 i will still need to use the COLON since I use APM Component alerts. the updated macro only applies to APM Application alerts.

It is case# 291330. I have done a bit more testing. I will certainly be sure to share any insights with the community.

Sure. Just add "AND ComponentStatus != 'up' " after the "${ID}" in the WHERE clause. That will filter out any components that are still in an UP state. If you want to see strictly DOWN (as opposed to UNKNOWN, etc), then just tweak that to be "= 'down' " I tested it and that works. Let me know if it works for you, too!

I came across this post because I am having a similar issue. I want to be able to use variables in the Alert Name. I can and do use dozens of variables in the alert triggers and alert actions, but whenever I attempt to include any ${variables} in the Alert Name, it simply passes that text back out. Example: Volume Alert on…

Neither query is working for me. The Physical one just returns all nodes, regardless of whether they are physicals or VM's. The VM report is just blank. When I look directly at the "VIM_VirtualMachines" table, it is empty. I assume this is because I do not have the ESX hosts specified for any of my VM's (yet). So reading…

I certainly do not want to put my Orion install at risk by adding any columns. What about changing what data gets gathered by an existing view? Instead of having "ComponentWithStatus" pull the Status field, could it be redirected to pull the "StatusOrErrorDescription" data? This should not impact performance since its not…

Yes, but I need to use in the To: field of an alert email action as shown below. The full SQL statement gets chopped at the colon.

The query runs fine in my SQL Studio. It was blank due to the WHERE clause, but even commenting those out, I get data back, no errors. Does your work in Studio, but just not in report writer?

Correct. I have all three of my Orion NPM/SAM instances connected as Linked Servers to my main instance. From there i can use UNION ALL to query all of them at once for the same alert age/custom properties information and display it in a single report which I then embed on a custom view on the EOC page. Here is a pic of…

I am having a similar issue. I have created a local account on the Orion nodes I want to use APM for Windows Service checks. However, the account fails on a number of systems. I confirmed I can login interactively with that account and password. I also tested with the built-in administrator account and that works. But the…

My company is having an SMTP server outage so I needed to rollover to a backup temporarily. This UPDATE query worked perfectly. I am now poinitng to the backup and have a way to move them all back once the main server is back online. Thank you very much!

Nice workaround. However, it should be noted that whenever you change the Alert Suppression criteria, Orion will automatically reset all active alerts on that advanced alert definition. This is so Orion can detect whether any active alerts should be suppressed as a result of the new criteria. If this is not a concern for…

SQL statements can be used in Web Report Writer.