jamison.jennings ✭✭✭✭✭

I took a Querying Microsoft SQL Server class. That opened the door for me to query the database and get those special reports that are always requested.

How to handle Microsoft Server Clusters in AppInsight for SQL

Post NCM 7.4 in the [dbo].[NCM_DeviceTemplates] table. Pre NCM 7.4 in the SWINSTALLDRIVE\Program Files (x86)\SolarWinds\Orion\NCM\DeviceTypes

Do you also have Network Topology Mapper? Similar type of discovery happens with it to make maps

Use Custom SQL Alert with "Custom Node Table Poller" as your SQL condition.

THIS will get you a count P/V: Select t1.V as 'Virtual' ,SUM (t1.P-T1.V) as 'Physical' From (Select Count (nodeid) AS 'P', (Select Count (nodeid) As 'V' from VIM_VirtualMachines) as V from dbo.nodes) T1 group by t1.v, t1.p This will get you "VM hosted by" report: Select VM.Name, H.HostName as 'HostedBy' from…

Tab 1, Edit Availability of Each Node, Filter would be: Caption='Node1' OR Caption='Node2' Tab 2, Edit Availability of Each Node, Filter would be: Caption='Node3' OR Caption='Node4'

Not as much as a log file but a place in the database in dbo.DiscoveredNodes

I was able to do this with Report Writer, Here's the SQL for it. My caveat is that all my UnDP Serial pollers have Serial in the name. This way I didn't have to spell out every one. SELECT Nodes.Caption AS NodeName, Nodes.IP_Address AS IP_Address, CustomNodePollers_CustomPollers.UniqueName AS Poller_Name,…

What version of EOC are you running?

Look for "Custom Poller Thresholds" on your Settings page.

You could query the database or put this in report writer: SELECT Title ,Target FROM ActionDefinitions where ActionType='email';

Do you have NCM 7.7 installed?

are other e-mails coming in? AV preventing SMTP? can you post a screenshot of the e-mail trigger?

AND UnManaged=0

Current - Hardware Status with Problems 11.5.OrionReport

How are you monitoring your databases?

Try this SQL in a report. Select N.NodeCaption, N.OsVersion from dbo.voipoperationinstances V join dbo.ncm_Nodes N on V.Sourcenodeid=N.Corenodeid

Add it as an external node.

Polling is SNMP, NCM uses SSH, won't you need SSH ACL's on your end device to allow from your SolarWinds server?

SELECT KeepAlive FROM [Orion].[Engines]

Why not perform a Network Sonar Discovery on these nodes? Import the custom properties, then mass apply the SAM templates to them?

shuth‌ Posted this a while back: https://thwack.solarwinds.com/docs/DOC-186822

Assuming you are using UnDP to poll, have you tried the "Universal Device Poller Summary Min/Max/Average Chart"

From Orion Core Components Admin guide: Passing Login Information Using URL Parameters The user ID and password can be passed as parameters within the URL. This allows you to create a favorite or bookmark within a browser, or on your desktop. Create a favorite with a link in the following form to pass the login…

Taking a stab at this. I'm assuming it's because a MAC Address wouldn't directly be recorded to the node as much as it would to the interface. Stick this in a Orion Report Writer Advanced SQL report and see if you can get closer to matching up what you want. SELECT N.NodeCaption AS "System Name" , N.AgentIP AS "IP Address"…

On the working side, goto the view and hover one of the resources and find the resource ID for one of your "Missing" resources then open database manager and query the resources table e.g. select * from dbo.resources where Resourceid='Resource id from hover' Then look at the Resource Name for that resourceid. That will be…

Ours working but the account used to send the report is not PIV/Smart card enabled. Don't know if you can run that way in your environment or not.

Assuming your referring to the Routing poller..... Setitngs/Manage Pollers Search for Routing If you want to add, check the box and add your nodes...... If you want to remove, click on the link under "Assignments" remove the ones you don't want.

I have different templates that meet my needs. Since I have SolarWinds: I have a template for monitoring the services on the Primary Poller I have a template for monitoring the services on my additional web Server I have a template for monitoring the services on my additional polling engines Each of the these have…