njoylif ✭✭✭✭✭

Man, that hurt....finally found a way.... Down in the basement of the admin guide...here get this...under network atlas help...orionnetworkatlasagapplicationvariables.htm?Highlight=Built-in SWQL Application Properties SELECT a.Node.Caption AS Other_IPs_Cert_At , '/Orion/images/StatusIcons/small-' +…

oh that would blow proverbial chunks! I just assumed it would...that's what I get hunh? Hopefully tdanner‌ or other SW gurus can chime in with good news Thanks blue

tdanner‌, alexslv‌‌, et. al., - my fine minded friends, the next step in evolution IMHO [or in my current needs] is to tie a custom query [table] resource to an application details view. I tried using: SELECT a.Node.Caption AS Other_IPs_Cert_At , '/Orion/images/StatusIcons/small-' + ToString(a.Node.StatusIcon) AS…

sorry for the delay. moved So essentially, the out of box alerts does not at a glance provide info like node that the troubled component check is tied to (yes, rollover, etc); this also gave me a way to customize the page and allow me to populate it with (I'll upload latest version separately b/c of all custom…

you are correct, the ANDs would not match in that fashion. boils down to order of operation...so you have to put () around the a.name like '' section i.e. WHERE condition.a=x AND condition.b=y AND (a.name like '%DFS%' or a.name like '%registry%' or a.name like '%mufasa%') AND condition.c=z HTH

for your wildcards, try something like: and a.name like '%commonword%' i.e AND a.name like '%MSSQLSERVER%' this works for me in swql studio this worked for me in swql studio for the IN statement: AND a.name in ('Oracle processes','SSL Cert Exp Date') maybe go into swql studio, get results you want then use that format in…

you can't use wildcards (that I know of) with 'IN' statements..as it equates to a bunch of combined '=' statements in 1. thus, if you remove your filter and get the full list, you should be using in your "a.name in (....)" statement the full names of the apps in the "APP" column of original output. is that what you have…

to show up in atlas and web page maps, they need to (or used to) be put here (on web server systems and systems running atlas...i.e. workstation too if run from there) %installDIR%\SolarWinds\Network Atlas\MapsWeb\NetObjects\Scaleable and %installDIR%\SolarWinds\Network Atlas\Maps\NetObjects\Scaleable. they may be actually…

i don't think it will let you use case statements...You'd have to go to a stored procedure for that. I've got a content share for a custom alerts "report" HERE if you'd like to take a look and maybe use as base.

I'm trying to figure out the relationships btn alert "base" object and how to associate to custom properties. i.e. I have app CP for applications called AlertEmails where the app owners email group(s) should be. for a component check...I send TO: ${SQL${Node.Colon}select AlertEmails from APM_ApplicationCustomProperties…

awesome, thanks for sharing...been trying to wrap my head around this stuff...I need to figure out how to use in alerting next

may not be the case, but I had to re-install my systems off R2, but that was because there was a VM issue with R2. you might not be running VM.

give us some more info...what is the sql script you are working with? check out this post

let me know if that gives you what you are looking for. Thx

You can just remove that column...just allows hyperlink to node. see note NOTE: this report includes a custom property called Parent that is the name of the Node the interface belongs to. Just remove that column in the SQL section and you should be good, or send me a message and I'll help you fix it/ add the column if you…

on # 2, it is a pain if you want to change a lot of them, but I created a bunch of custom graphics (usually from vendor stencils) and you can make them any color you want. I used visio to create the image. save it 4 times as "image.vsd, image-up.vsd, image-down.vsd, image-warning.vsd) the native is "unknown"...probably…

yea, hard part is done. now just get into NCM console and schedule a job of type report gen.

odds are that you have a very large amount of syslog messages coming in. I had this issue as well and broke out the syslog from Orion. We now use a syslog-ng server to receive and SW LEM to parse through and report on them; utilizing an agent on the syslog-ng system. Firewalls are a huge offender of message quantities and…

These are based on component object. so same concept but: still failing. if that looks right to you, I'll open a ticket (I put in to: for simulation/testing). thx!

ok, I actually have a different scenario where this would be useful. SELECT isnull(v.AlertEmails,n.alertemails) from volumes v left join nodes n on v.nodeid=n.nodeid where volumeid=${volumeID} anyone have a workaround for the spaces?

yea, I hit them up about this too. basically, if you have IPSLA checks down or UDT with ports down, it will show child status as red. I told them that doesn't make sense if they don't show on the nodes page, what is down. essentially, there is something on that node that is down though. ticket 291925 for UDT if you want to…

go to device tracker tab -> click on "UDT Settings" in top right corner of main window -> Device Tracker Discovery -> click on next EVEN if don't add AD credentials; Then you can select existing devices to scan for ports.

TCK, do you have a sample of SQL code I could use to export/import into another NCM implementation? I'm having trouble with the import (2 separate DBs and need to export/import CIS security rules between the two implementations...Think I'm getting kicked with the autonumber column... Any help would be greatly appreciated.

the answer really depends on what version of NPM you are using. Try starting HERE

please download the report on the content exchange HERE or here is the URL: Let me know if you need a tweak.

tells how to create new ones, location to save wmf files to will be different for 9.5

ditto, drive me nuts :) started using firefox

you've got more than one cell...nodeid and x+y+z try.. ${SQL: SELECT TOP 25 NodeID+' - '+Message_UNICODE + CHAR(13) + CHAR(10) as 'data()' FROM [dbo].[SysLog] WHERE NodeID=456 FOR XML PATH ('')} or try CONCAT()

I *think* LadaVarga​ said in another thread I was working on, that you can't use SWQL like that....try using just ${NodeID}