njoylif ✭✭✭✭✭

we'll do, thanks.

I have to agree. You guys have come a long way with your products and are much better with your support, this area could definitely use some attention. thx

beautiful!!! Thanks

I don't believe you'll be able to do it through this mechanism. Reason being: the select statement is hard coded. In order for this to work, you have to compare one row of the table to another, and the only way I know to do this is via comparing one instance of the table to another; iterating one row of instance 1 against…

I have no idea where I got this from - I didn't write it. I'm sure someone on thwack wrote it, but here's the SQL that I think you want. SELECT [N].[Caption] AS Caption , ISNULL([PortsTotal].[PortCount], 0) AS PortCount , ISNULL([PortsActive].[PortCount], 0) AS ActivePortCount , (ISNULL([PortsTotal].[PortCount], 0) -…

node details page shows violations - perfect. I'll look forward to hearing about the map. maybe even a section under the map that shows that same resource? thanks

That's a nice way to do it...I'll have to chew on that. I've been going down a similar road. Hard to read, but... I've had problems with nesting and using "IS NULL" logic. good times. <table border="1" style="width:100%;border-collapse:collapse;white-space:pre-line;padding:10px"><tr style="vertical-align:top"><td…

Piggybacking on the SQL theory, you could create a custom field in the DB and group your devices accordingly. Then use SQL to set the polling frequency. Definitely a good idea and worth SW adding to the feauture enhancement list in my book! Let me know if you want example or some SQL help.

ok, it will need to look like "${AlertName}" just to be clear and make sure you put something unique in the title of the alert to differentiate this one. the logic is correct.

also, please put the alertname macro in the alert message body to verify not triggering on another alert; in case you copied this one, etc.. perhaps a screenshot of the alert trigger criteria would help also.

I have done editing of all of my menus in 9.5 sp4, so definitely open a ticket.

I figured as much, but was hoping. I'll put in a feature request

here is a link to my data in/out which rolls everything up into one... Here is a link to wan utilization count per month where utilization > 45%...should be able to tweak for adding up your data) Hope that helps

How about now? tdanner? This would be immensely powerful and we have a need to automate this in one small area.

hunh...looks like I'm late to the game on this one...see RichardLetts‌ post HERE he goes into excellent detail/depth

yea, realistically, i utilized most of these implementations from other users like adatole‌. Always good to cruise Thwack....daily. Actually, I get the "all RSS Feed" so I don't miss great ideas and other useful tidbits. Thwack is an excellent resource mostly because so many people are so active...Thanks all.

Yea, the last page of the SDK download (pg 8 I think) shows tdanner‌ indicating they are working on 11.5/SAM 6.2 docs for SWQL alerting. I tagged him in that and this post asking if they've got any updates/ETAs. I'm trying to use within the context of the alert (reset criteria in this case).

Yea, something like that or, integrate check boxes into the resource list...?? Thanks

depends on what you need. the view will [probably] be a few tables mashed together. I typically go into SSMS (sql mgmt server client tool) and create view to query to see what the logic is that builds the table. see if it gives you what you need (assuming you have access or can get from DBAs). Great opportunity to learn…

I had one for windows that I cleaned up custom properties, etc... this is from the report writer app. Nodes_and_Apps_assigned.OrionReport

excellent, thank you for posting the fix!

aLTeReGo​, any updates, on roadmap? My system siezed up and I had no idea until network guys came over to ask about something and I tried to get into it. Not confidence inspiring...they don't use much as it is

correct, and SW would not show the red dot indicating child object status down issue, but grey or blue (whichever it is) :) thx

did you try creating (in dev environment) a new SQL alert, then customizing the query through SQL? does it prevent that? I know that is not ideal, but if this is pressing, I'd try that and/or open a ticket. I do suspect this won't work b/c of though trigger query design though.

I'm not seeing a problem at this point; can get to KBs and drop downs for ticket worked for me. try again?

ok; probably time to open a ticket then. If you do as well, please post ticket number here. Thanks!

tdanner‌, would you take a quick look? trying to send "detached resource" SWQL table in alert action -> send web page... is this possible? thx

if using a syslog server w/ agent rather than the systems sending directly, you'll use "detectionIP" for source. filter by those and see what information you get from there to drag and drop "fields" highlighted..."InferenceRule" or "EventInfo" Event Info doesn't appear to be avail (or I'm missing it), but if you start with…

Yea, there was a major performance hit going to 9.5 (i think) when they migrated the maps into the DB. It has gotten much better since then, but is still painful if you have a lot of objects nested in a lot of maps, basically all culminating onto one map.... For a while there, I created a page with 5 frames and pointed…

Hot standby will take over if one of your "operating" polling engines fails if you are monitoring 250 nodes and 10,900 interfaces currently, you will want an additional polling engine at a minimum. SW recommends max 8000 elements per engine (element is node, interface, volume, etc..) In addition to that, you have to…