Detroiter

I use the same type of iFrames for several EOC reports (do not get me started on why....) I included a browser checks since iFrames act differently in IE vs others with regards to size formatting. Here is what I use. <!--[if IE]> <object width = "100%" height = "400" classid="clsid:25336920-03F9-11CF-8FD0-00AA00686F13"…

Is there a method for doing this now that the Custom Property Editor is web-based? I manually modified a Custom Property via SQL Management Studio to avoid an alert storm. When I changed it back, I confirmed the Alerts are firing off of it properly, but I can no longer see it in the Custom Property web editor nor in Manage…

The only question remains - how do I ensure all my new nodes get this ":" assigned by default. Anyway - it is minor problem... I use a SQL Server Agent job that runs nightly and uses a simple UPDATE query to place the ":" where needed. update ORION.dbo.Nodes set Nodes.COLON = ':' WHERE Nodes.COLON IS NULL Glad to see that…

Not surprising. While the workaround I posted DOES get it to go, should this be considered a bug in the latest versions have get addressed in a future patch?

Not sure yet. I have a case open now, but I would recommend NOT upgrading until it is resolved.

I have opened a case on my issue. Hopefully support can shed some light on this.

Yes, Petr, I can see that data in the dbo.APM_ApplicationAlertVariable table. How is that data getting populated within the macro? It would seem to me that rather than having several columns devoted to just Status, one should capture the ErrorMessage column of component status. Is that macro something I can edit manually?…

So I think I am as close as I can get. The final statement below is the one I am going with. The only issue is that I HAVE to send the emails out as "plain text" rather than the preferred HTML. This is the only way I could get the proper carriage returns. This is done with the "CHAR(10) + CHAR(13)" combination. The "<br>"…

I am looking for something similar, but more binary in nature. Every Node Details page lists a "Hardware" field that either reports "Physical" or "Virtual". What is the database query to return just THAT value? I only need a report that shows all my physicals and one that shows all my virtuals, even if that are still "host…

This was the issue. Once I created a duplicate row, I was able to get the chart to display. This shows that the Web Report Designers in very powerful, but also very complex. Thank you for the help, LadaVarga!

Ready for these one, #aLTeReGo? So since the colon is an illegal character, the custom SQL query failed since all the text would be cut off after it. Well I was not going to let this stop me. What I discovered is that if you used the standard macro (${Node.CustomProperty}), you could push ANY character you wanted as long…

While that is helpful, I really need them in the macro list so that they can be set up as email recipients. Is there any timetable for updating the macro list? If not, is there any way to implement it on my own?

AuditEvents...should've looked there. Found the info I needed. Thanks.

That got it. So i was close with my concatenated URL string, i just included the HTTPS which was unneeded. So now i have basically rewritten the EOC Alerts page to include all relevant custom properties and alert ages.

You can count on me to provide some. I would have done so earlier (as I did for the HP stuff that is now so well implemented in SAM), but I did not know you needed them.

I find it better to "trick" Orion into triggering an alert on a device rather than turning it off directly. Simply change the polling IP for a device to something that will fail, 1.1.1.1 or similar. Orion will complain but allow it. Pings will fail, alert will trigger all while teh device in unaffected.

"You just want a "does not contain" right? That's an easy one, just add a none condition group: Trigger Alert when all of the following apply ..custom-property1 is equal to toilet ..interface status is equal to down ..Trigger Alert when none of the following apply ....interface fullname contains bri" Has anyone been able…

Always a bridesmaid....

The only way i have found to completely "hide" a tab is to have no tab menu items in it. However, all menu bars MUST have at least one menu item. But far be it from us to let that stop progress. Now this next part depends on how skilled you are at database modification. IF YOU DO NOT FEEL COMFORTABLE MAKING DATABASE…

Using Node.MachineType LIKE '%Windows%' still does not present any volume alerts. That workaround would not work for me anyway since we have more than 1 UNIX platform team. I tried the second option and that is a good workaround. Since all my advanced alerts are labeled with the platform team that owns the system in…

That seems very odd to me considering the fact that the UnDP app automatically populates the "Description" field with the correct data. I assume that app is getting it from the MIBS.cfg database. If that is the case, couldn't the Trap Viewer also look there for a description? And if it finds one, add it to the email or if…

So here is the SQL query that I use to report on all the availability of all the applications assigned to a particular set of servers. Since I want it to be dynamic, the date variables are used to ensure it always polls the last month's data. Is this what you are looking for? DECLARE @LastMonth1 datetime = (SELECT…

Yes, but the alert timestamps in previous versions were not on UTC, they were on local server time. So now i have to manually update all of my SQL queries to subtract 4 hours from the timestamp? And this is only for the next 6 month until we Fall Back and then i have to do it again to subtract 5 hours? This was exactly why…

Gotta love the old Google machine. Found a working way to strip the XML headers, it and the results are below. Now if only I could get them to display on individual lines...or am I getting greedy? ${SQL:SELECT cast(cast([StatusOrErrorDescription]as nvarchar(max)) + '' as XML) FROM…

I use the AlertLog table. Since that table logs the triggers and resets of all advanced alerts, it was just a matter of correlating the AlertDefID to the advanced alert ID and ObjectID to node ID. Try this, it is a report that counts the total number of minutes for each unique alert between its Triggering and Resetting.…

So I sorted out the Volume one, seems that TESTING the alert definition did not yield the same results are actually triggering the alert. Once I triggered a legitimate alert with the ${Volume.BlahBlah} e-mail address, it worked. What is the format for SAM Custom Properties? I know that in the macros for Nodes and Volumes,…

I should also note, these PDF's DID work prior to upgrading to NPM 12.1

serena There seems to be other issues with the Offline Installers. In my case the Offline Installer for SAM 6.4 HF1 is also forcing me to install NPM 12.2. Should the SAM Offline installer even KNOW about NPM 12.2? I have opened a case tonight because it caused me to have to cancel my SAM 6.4 upgrade since I was not…

Wow...just saw this was a resurrected post from 6 years ago.... Still my post is accurate.

This is the same thing that happened to me on one of hte two instances I upgraded to 10.4.1 over the weekend. The data is still all there (thankfully), but I cannot add an new data to the custom fields. When i attempt to edit an existing node, all of the Custom Property fields are missing there as well.