alain_p · Network Engineer · ✭✭✭✭✭

NPM

Hi yumdarling, I also got a not so nice X, although I'm quite sure I answered correctly. Please have a look at it. Thank you.

Hi ymdarling, I think a little error got into the question. If we have to select all that apply, we would need some check boxes ;-) Thank you. alain_p

You are absolutely right. Take your time ;-)

Same here. Voted but no green check.

Same here @"yumdarling" please reset todays question. Thank you

Same here

@"yumdarling" the link is indeed working now. Thx

Same here.

Hi stuartd, The field parameter for the column in the database changed to text & also the values stored have changed (MIB by Cisco). Had this issue & changed the value to: NcmEntityPhysical.EntityClass='3' OR NcmEntityPhysical.EntityClass='chassis(3)' Please let me know if this resolves your issue. Kind regards, alain_p

Hi @"tigerr" Could you please share a bit more details of what is missing / not working? On what version are you for NPM & NCM? Tables used are Nodes, NCM_NodeProperties & NCM_Entity_Physical Maybe you could break the SQL into little pieces to get an idea where the DB tables are different. Node status & a clickable URL for…

Hi tigerr, Adding the custom property is this SWQL query is quite easy. Add this 'OrionNodes.CustomProperties.CP1' & replace CP1 with the name of your custom property. If you have multiple, just add more ;-) To get you started with your SQL query: (Replace CP1, CP2 with real values/names) SELECT NPM.Caption AS 'Name' ,…

Hi @"DannyTran", Firstly, create a copy (Duplicate & edit) of the 'Node is Down' alert. You could try and exclude the devices in the alert with adding their names to not match for the trigger. Or an even better solution could be implementing a Custom Property (CP) & add this to the alert trigger. Wkr, alain_p

Hi cwjohnson3rd, I believe there is standard report present in NTA almost meeting your needs. Try this one: "Top 100 Applications - Last 24 Hours" Can be found under: All reports - Group them by Product Look for NTA Reports Regards, alain_p

Hi @"mnsh_majumder", I've just tried re-writing your query, but am not able to test. I believe that the round brackets in the initial query are not completely correct. SELECT n.Caption AS Nodes , n.IP_Address , i.caption , cpa.assignmentname , cps.datetime , cps.Status AS Status FROM Nodes AS n INNER JOIN…

Hi stuartd, Hope I can clarify this. The report makes use of a SQL query, so not SWQL. Since we are getting all info regarding the APs from the CustomPollerStatus table, we need to address the rowID. This rowID helps to keep / bundle the info for a single AP together To test this create a sample report with 2 datasources &…

Yes indeed. The database is also being accessed for that data. If you don't need it, just remove it from the SQL query behind the report. All things with t4 mentioned ;-)

Hi sunvad, Just saw your post. I struggled with this for a bit also. Did find a post on Thwack that helped me out in building the report, but don't remember the link anymore. I modified my report (SQL) a bit & uploaded it here. Hope it helps you out.

@"ipauld" That would be a great feature. It works this way for NPM SNMP communities. Or maybe instead of deselecting the NCM profiles in the discovery job, just a check-box to tick if you do not need to have the node being discovered into NCM. Would speed up the discovery job & then you don't have to edit the node…

Hope this sets you on your way, to achieve what you might be looking for. It's basically adding statements with AND / OR block & using parenthesis. A few lines: aaa new-model (^\w{3}\s\w{3}\-\w{5}$) aaa authentication login CONSOLE local (^\w{3}\s\w{14}\s\w{5}\s\w{7}\s\w{5}$) aaa authentication login VTY group tacacs+…

Adding to @"saw10" 's reply Instead of using a CP, you could add the node (device) status to the mix, either numerical or textual. Hope this helps.

No SAM in use

Hi yumdarling, Same issue here, every questions / item checked gives a red popup & no points awarded. Just wanted to let you know. regards, Alain

Hi makecrazy You will need to join an extra table to get this working. SELECT SI.StatusName AS Status , COUNT(N.Status) AS Total FROM Orion.Nodes N INNER JOIN Orion.StatusInfo SI ON SI.StatusId = N.Status JOIN Orion.NodesCustomProperties AS CP ON N.NodeID = CP.NodeID WHERE CP.City LIKE 'XXXXX' <--- Please replace XXXXX…

Hi Sparveen, A bit more info on how the NCM Device Change templates work & how to create them can be found at documentation.solarwinds.com/.../NCM-examples-config-change-templates.htm To see if anyone has already made a similar template or script you could search on Thwack in: Content Exchange --> Network Configuration…

Hi, I had a same problem on one of the pollers I was upgrading. Apparently 2 Orion Services had restarted. I stopped those & re-ran the config wizard --> succes. Hope you get to the same result.

Hi Marc Thx for pointing that out. It worked like a charm Wkr Alain

Hi @"vinay.by" Thanks for your insight. Really appreciate it. I had found the post you are referencing to from @"mesverrum" , but I was desperate for space. Cleared out some log files & freed up enough space to do my upgrade Will try to get a bigger HDD for the VM though. Alain_p

Hi dcinoc, Not a SWQL expert, but maybe try this: SELECT c.Name, c.Members.Name AS NodeName, CharIndex('-T1DR',c.Members.Name) as DR FROM Orion.Container c WHERE c.Members.MemberEntityType='Orion.Nodes' AND c.Name='Customers' AND c.Members.Name NOT LIKE '%-TIDR' Hope this helps. Wkr, Alain_p

Hi shinska, Some extra info can be found in the cisco release notes for 9300 switches IOS-XE. I assume you are running the devices in Install Mode. Here a link for the: Release Notes for Cisco Catalyst 9300 Series Switches, Cisco IOS XE Fuji 16.9.x They describe a 6 step process on upgrading In a nut shell: ---------------…