ctlswadmin ✭✭✭✭✭

I would recommend implementing custom properties, once complete you would only need to include one condition. The one condition would encompass the elements desired, are you familiar with custom properties ?

See if the query below gives you valid data. The logic being that, if a port is still active the last successful scan will be recent, and if the port was active at the time it will be considered to have been in use during that time. AND (LastSuccessfulScan > dateadd(DAY,-90,getdate()) AND Enabled = '1') The query should…

I provided sql syntax, won't work in SWQL studio. It has to be ran on either db manager or sql. Try changing this ADDDAY(-1, GETDATE()) to this: DATEADD(DAY, -1, GETDATE())). If that doesn't work remove a ) from GETDATE())

Ah, I assumed you were referring to the primary polling engine as the NPM server. So, if you're adding a new APE. Build your engine, make sure you have the same versions for all of your products. Then you can either move elements over to your new polling engine from the sw website, or from sql. From the website set your…

Hi Bobwpg, Going on a few assumptions here, that you have a recent version of NPM/NCM and that your question is pending. Step 1. Navigate to the Solarwinds website and hover over 'My Dashboards' Step 2. Hover over 'Configs' and select the 'Configuration Management' option. Step 3: Search for the routers in question, once…

Is your new environment going to be on the same network/ subnet?

I have two options for this approach, will share my proffered method. Step 1: Create a new view Step 2: Add the "Report from Orion Report Writer" to columns 1 and 2 Step 3: Create a report using Report Writer, one report for every section you wish to have. Title them as you want them to appear on the website Step 4:…

You are correct, if you were to click on the eService Server group, Solarwinds will present the group template but it will only show servers that belong to that group. I'm not sure if it's possible to redirect your group to an alternative website as it uses the container ID as a variable to present your webpage. The route…

I'm curious to learn Marc's approach. Bluedott33, try this. * Change the Select Field on the Report Writer to Date and update your filters to reflect the hours you seek. * Navigate to the page you would like your graph located in and "Customize Page" > Add "Custom Chart" * On Report Writer, open your saved report. Select…

Open the Solarwinds database manager and run that query from there. From the NPM server navigate to Start > All Programs > SolarwindsOrion > Advanced Features > Database Manager This will open the Database Manager. Once it's opened Click on Add Default Server Expand the database, then expand the Solarwinds database. Once…

Hey Mikemc, have you been able to figure this out ?

Thought you were pulling the info via snmp, leading to my snmp question. This is a SAM template running WMI correct ?

This should give you what you're looking for Alex. * Run a discovery, don't import anything but make sure it completes * Query the 'DiscoveryProfiles' and identify your latest 'ProfileID' * Run this query, replace the 'REPLACE ME' value (Kind of messy and could use optimizing, but wrote this on the fly) Select…

Very interesting method Craig, thanks for sharing (Will be reading more of your posts). I think this should give you a basic overview of missing devices in Orion as well using the CDP/ NodeIP table. Select IpAddress From NodeCiscoCdpEntries except Select IpAddress From NodeIPAddresses

Give this a try.... (I don't have ospf monitoring so not sure if this will work for ospf, but should work for bgp. You can always add the ospf part to my query, or I can help you write that query if you'd like. Would just need to see a bit of your data to mod the query below) Select Events.EventTime AS Time,Nodes.Caption…

Strange, I think that's it's a silly check box somewhere. The changes shouldn't hurt your alerts, 1 = up and 2 = down. I'm interested to know on what caused the change, keep us posted.

It depends as to what specifically your organization is looking to accomplish. I would talk with engineers of each team and see what they want, then build reports from there.

Can you share the Select Fields, Time Frame, and Summarization info ?

Have you ran the license manager? I'm interested to see if there are discrepancies there.

mcam is correct, the number of active transactions you can have on a given poller is limited by licensing. However, if you do have the SLX license you are limited by the hardware you have installed. Recommendations on a basic config with a 2GHZ (quadcore) proc and 3GB of ram allows you to have 50 transactions lasting 30…

Try the query below with one of your mac's. (I'm on an older verision, you might need to modify the query to fit your environment.) If you are using one of the newer NCM installs you can also view this data from the ARP report, to access the report navigate to 'My Dashboard > Configs > Reports > Group by Category and…

We had everything working fine with 10.7 and hotfix 3 (I think) installed, then we were asked to upgrade to 11.0 to fix issues with UDT. When that broke our env we were asked to upgrade to 11.5. The upgrade did help a bit, however we still have about 10 second load times upon login. I have tried dynamic queries, however…

That explains why they moved away from plain text credential storage. I do think that higher tier organizations have the resources to manipulate their vendor products to fit their needs. We encrypted snmp credentials on 10.7 I believe, might have been an earlier version.

I'm intrested in how you did this, can you share ? Thanks, David

Thanks for the response LadaVarga. The short description portion appears to have canned definitions. Did you have to do anything to allow your short description to define custom values? Thanks, David

Hey Max, I played around with different configurations and I was not able to create one template with your requirements for groups. I'm not sure if this is possible, but if you find out how or anyone else chimes in I would be interested on accomplishing this objective. What I have implemented for groups to work in the way…

This might come in handy. (discovery tables)

This seems interesting, I think that in order to produce something accurate a clear understanding of ones environment is necessary. Would not want to write out a query that probes for something that does not exist in your environment. How many SW products do you have ?

Try the query below. If it doesn't work, change the font in bold to AttemptedDownloadTime If that still doesn't work share your version of NCM. SELECT nn.CoreNodeID AS 'Node ID', nn.AgentIP AS 'IP Address',nn.NodeCaption AS 'Node Name', ca.DownloadTime AS 'Download Time', CA.LastAttemptedDownloadTIme AS 'Last Successful…

Is this what you're looking for? Select Top (5) MACAddress,PortName,LastSeen,IPAddress From UDT_MacCurrentInformation Remove the 'Top (5)' for a full dataset.