ctlswadmin ✭✭✭✭✭

UIM FogLight Fluke

Downtime

Better servers and increased storage

Go solar.

The 'Received Discards Today' should be set to your custom property. Once you fix that the message should go away.

Can you run this Select Caption,IP_Address,Description,MachineType From Nodes And see if you get results please?

Are you running 11.5.2, and are you familiar with Database Manager? This should render results on 11.5.2 and earlier versions. Select Caption,IP_Address,Description,MachineType From Nodes

This should work. Select Custom Chart as the resource Select Advance Selector Set I want to report on to Interface Click on 'Select Field', and then select your custom property. This will encompass all interfaces added to your custom property.

How much granularity does your organization require, would it be possible to increase the polling intervals? I think that spinning up a vm with multiple low powered hosts could give you what you need. Solarwinds recommends a quad core proc at 2ghz with 3gb of ram to monitor up to 50 transactions that last 30 seconds over 5…

Sorry about that, misunderstood what you meant. All of my reports are sql based, haven't used the web report function in a while. I'll try to figure out how to get around that, keep you posted.

My query is sql based, I don't know if web based reporting handles sql. For the query I posted you would have to create the report via Report Writer using Advanced Sql. Then link the report to one of your webpages.

Once you've created the custom property you can add multiple interfaces at once. Navigate to admin settings Select Manage Custom Properties Select your property and select 'View Edit Values' Identify your interfaces by key words using the search bar, or by the group by function on the right of the screen.

I just noticed that my query didn't copy correctly into my response, and the query was written for the standalone NCM database. I will rework the query for your environment later tonight. Do you have access to sql?

The weight of the job is determined by how lengthy/ complicated your script is, and the frequency of the polls. In my test environment I have 1 poller sitting at 135% with 5 transactions, and another poller at 70% with 5 transactions. My boxes have 32gb of ram with 12 cores at 2.6ghz. Scripts on my test env are configured…

I've been thinking about listing the current unmanaged nodes over the past 60 days. This is what I came up with, I imagine we could tie the current unmanaged nodes to the query below to provide more information. This query shows you the nodes that went into unmanaged over the last 60 days, it's built around events. So if…

I forget that not the db manager doesn't accept all sql syntax. Everything I'm providing is sql, not swql. Can you run select top 1 * from ncm_nodes in the db manager and let me know if it renders results?

Here's a good doc: Create a custom property More information within the doc: Change custom properties values

From what I know, moving nodes to your new polling engine is going to be manual. Once your poller is online play it safe by moving the nodes within manage nodes.

There are a few ways to go about this, this is what I would do. Many ways to peel this apple, if you're looking for something a bit more asthetic it can be done. Just give me the version of NPM you have to make sure everything I provide works on your side. Step 1. Navigate to SolarwindsOrion Alerting, Reporting and Mapping…

Sure, Step 1: Navigate to 'Main Settings & Administration" Step 2: Select "Add New View" under the "Views" section. Step 3: Name your view and use the default "Summary" type and submit. Step 4: Add resource "User Links" and select Preview. Step 5: Select "Edit" Step 6: Define your group names and associate your dashboard…

Run the query below. This should give you the report. If it's still not giving you the correct output can you show a pic of your results? I'm interested on seeing what's to the right of node name. Select caption,unmanaged,UnManageFrom,UnManageUntil From Nodes Where unmanaged like '1'

The query I provided is for SQL, it might run from the database manager. What version of NCM are you running ?

Answering in sequence: I assume it's a matter of selecting ARP and Bridge Table options in the Inventory Job within NCM--is this right? You are correct, selecting ARP will gather the information you seek. Finally, how does the MAC address format play into the inventory or search? xx.xx.xx.xx.xx.xx versus xxxx.xxxx.xxxx…

I would first confirm that your inventory count isn't set too high and uncheck anything that's not needed. Secondly I would verify that NCM can access your devices, review the 'transfer status' page to verify authentication. After correcting authentication errors and reviewing the inventory configuration I would start…

That means you have the slx version, there's no limit to the amount of transactions you can have. Are you seeing error messages anywhere saying that you have a limit ? It could be that you have an old license installed on your server causing issues with an eval license or license with a limit on transaction numbers. If you…

Are you configuring snmpv2 or v3 ?

I ran the query, but the passwords are still encrypted. Any tricks on decryption ?

You can define how long those tables stay populated via the 'Discovery Retention' in the Orion Polling Settings. It's been a while since I played with the NCM tables, your approach gives me more ideas... so thanks !

Run this query on the Solarwinds Database Manager share your output please. SELECT t.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, c.name AS column_name FROM sys.tables AS t INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID WHERE c.name LIKE '%NodeCaption%' ORDER BY schema_name, table_name;

I believe that the NCM db was merged with NPM after 7.3. Do you know what the table name is where ncm node information is stored ?