Detroiter

Finally got ahead of you on an answer, aLTeReGo ! Woohoo!

That sounds like a good idea, but your query does not work. You have an INNER JOIN after a WHERE, which SQL does not allow. Is that intended? If not, how should it have been formatted?

In order for my original suggestion to work, you have to convert it to a custom SQL report in Web Report Writer first.

Yes, of course. However, that would be a manual process requiring a human to take some action The request is somethng more "push button". When they roll out their new code, they want something that will apply the template changes made in Dev Orion to the existing (or possibly new) templates in Prod Orion. In that case,…

So I took a stab at this. All the data you want is in the AlertStatus table, including duration which just needed to be converted to Day:Hours,Mins,Sec. But based on your original post, you want something a little more readable. The issue there is that the "ActiveObject" in the AlertStatus table can refer to a NodeID or an…

Evan, Are you looking to disable a SINGLE component out of a list of 100+ in that are all in the SAME application monitor? If that is teh case, you likely will not be able to use the SAM Custom Property method since those are only settable at the Application level, not the Component level. Additionally, you can only…

SAME TIME ANSWER! Heheh.

I will be heading to Austin in August for the Orion 301 class from Loop1. Looking forward to it.

Yes, this would also be extremely helpful for me. I use an UPDATE SQL task to set a "Hardware Model" custom property to the specific HP model name. I would like to be able to use that field to determine what additional UnDP's need to be assigned. Ideally, this would be a SQL stored procedure so that as new systems gets…

Those macro DO work, but do not go quite far enough. I need to include why a component is in a Down state as well. Are those macro based on SQL queries? If so, would it be possible to modify it into a new SELECT query that i can use now?

Are you talking about a multiple object resource on a Details page view or a custom chart in Web Report Writer? If the former, follow Matt's suggestion. If the latter, edit your chart and look for the filter section at the bottom.

A Group is only Down when all members are down at the same time. Or are you looking for something that gives Node Availability for group members and the associated events?

All have been standardized to Eastern. All pollers and database servers are set the same.

Add my name as an interested party as well. This would be very helpful.

I have been experiencing this issue much more frequesntly now that my company is preparing for a data center migration. The issue is two fold as I see it. 1. Loss of monitoring. Clearly this is critical for the reasons sited by the original poster. When the volume data changes, Orion loses sight of it and effetively…

That is unfortunate and hopefully the product guys are looking into it. My alert message does report all three status messages listed but only in comma separated in-line list. It is not pretty, but at least I am not missing anything.

This work around is perfect. I was even able to enable SSL. Thanks!

This is veeeery close. I can see that all the correct messages are being returned but there appears to be a lot of extra formatting data in the returned value. I have included the exact result below. If there is a way to remove the "<StatusOrErrorDescription>" entries, this would be perfect.…

I hate to rez an old topic, but are these grants still all that are needed for Oracle 12c? I had our DBA Team provide them but I cannot get the Tablespace queries to work, says the table or view does not exist. According to them, this account needs "Grant select on sys.v_$tablespace" in addition to those listed. Is that…

The latter. Hoped to avoid having to rebuild the cred library on the new server. But looks unavoidable.

I had that thought, too...no dice. There must be more to it, since the table is "Nodes", but the macro uses "Node". Same for "Volumes" as opposed to "Volume".

Well alright. Guess I know what I will be scheduling up for next weekend. Thanks!

I am on 11.5.

It looks like you enabled the Details Page URL on the Interface column. This line is specific to NODES ONLY. ,'/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N:'+CAST(Nodes.NodeID as varchar(256)) as 'DetailsURL' You could replace it with this if your report is for Interfaces.…

Is that a macro? Nodes.DetailsURL is not a column in my Nodes table. Below is a section on my query. I union that with several other for Node alerts, APM alerts, etc. i even built my own correct URL, but still cannot get it act as a hyperlink. SELECT DISTINCT nodes.caption…

Another odd bit is that this data can be displayed as a TABLE with absolutely no problems. I am at a loss for how to translate that in a chart. 

I added that bit and get the same results when i click "Preview Results". As my screenshot shows, I get four columns (App, DB, Web and Summary Month). Just want those values in a column/bar graph scaled to the values. I cannot seem to figure out why this is so difficult...

I just did an SRM hotfix for 6.4 and am on NPM 12.1. I was able to remove the offending section from my webconfig without issue. My iFrame report displays properly.

I got the same email I have my web.config file ready for editing, but what to change and where is a bit vague. Hopefully my support guy gets back to me soon.

Bumping this topic. I ran into this issue last week. I have an EOC report that displays active alerts, but not those that have been acknowledged. A volume went Critical and the alert was triggered, I have a clear record of that. However, the EOC Team claims the alert never appeared on their screens. The only way for that…