ctlswadmin ✭✭✭✭✭

If your new NPM Instance sits on the same network then your device names should auto discover successfully. If they don't I'm sure we can work out a script. Keep us posted.

Give this a try, let me know if it works: Select NodesData.Caption,COUNT (F5_LTM_PoolMember.OrionStatus) AS 'Active Connections' From F5_LTM_PoolMember INNER JOIN NodesData ON F5_LTM_PoolMember.NodeID = NodesData.NodeID Where F5_LTM_PoolMember.OrionStatus = '1' Group by NodesData.Caption,F5_LTM_PoolMember.OrionStatus

Hey rabenbergd, I don't think that your issue is related to windows log files. Few questions to help better understand your issue and help you resolve it. * You started an entirely new DB in moving to Server 2012 correct? * Are you familiar with the 'Solarwinds Database Manager'?* If yes* Open the manager * Expand the…

I will give it thought and come try to come back with an answer later in the week.

Would you like the standard drop down feature to work from the home page? Or are you just seeking to list the groups, and the users be directed to that assigned view?

If you still need help, can you share the column names of this table. I don't have SRM, so don't have anything to reference.

Few questions: * Where in the install process are you seeing this message? * What version of NCM do you have installed? * What version of NPM are you trying to install ? Thanks, David

This query gives you networks by device. Select NodesData.Caption AS 'Node Name',RouteDestination,RouteMask From NodeL3RoutingData Join NodesData ON NodeL3RoutingData.NodeID = NodesData.NodeID Where NodesData.UnManaged ='0'

Hey Alex, The way that I accomplish this task is by descovering target devices, subnets, or networks. If you run a discovery and import all interfaces Orion will filter out dupplicates and only import new interfaces and in turn deliver the result you seek. Depending on your network size you might have to segment the scans.…

Hi Rmurphy, Few questions: When did this stop working? Are your other pollers having issues with this specific service? Have you tested your node against the snpm string ? Is this the only service that is failing to report? Thanks, David

What neighbors are you referring to specifically ?

Try this: Select AuditingEvents.TimeLoggedUtc,Nodes.Caption,AuditingEvents.AccountID,AuditingActionTypes.ActionTypeDisplayName From AuditingEvents INNER Join AuditingActionTypes ON AuditingEvents.ActionTypeID = AuditingActionTypes.ActionTypeID INNER Join Nodes ON AuditingEvents.NetObjectID = Nodes.NodeID Where…

We started having issues after we breached the 50k port mark. Because of that the product is not useful to us.

I would take a jab at this using AlertsHistoryView, Nodes, and Interfaces. If you have the occurrences going to the events table that might be useful too. This article is probably a good source of reference: In need of a report that shows the span of time when an alert is triggered and when its acknowledged.

Hi Justin, Give this a try, if it doesn't work let me know what version of NPM you are running. Select DiscoveryJobs.Name,DiscoveryProfiles(desired column names) From DiscoveryProfiles INNER JOIN DiscoveryJobs ON DiscoveryProfiles.ProfileID = DiscoveryJobs.ProfileID Where (enter your filters here) To add filters on…

Hey Trilobite, Custom properties would be the most effective way. Or, you could filter by vendor. Example: WHERE VolumesForecastCapacity.DaysToCapacityAvg <= 60 AND VolumesForecastCapacity.MetricName = 'Forecast.Metric.PercentDiskUsed' AND DayDiff(VolumesForecastCapacity.MinDateTime, VolumesForecastCapacity.MaxDateTime) >=…

I'm a Report Writer fan This gives you a general idea of what you're looking for.

Scale back on your polling intervals, and set your node status requests to icmp instead of snmp. Add more resources to your server if possible....

How are you pulling your current information? If Report Writer, what report are you running, if custom query can you share the query? Thanks, David

Go to the Orion Report Writer, look for the Availability Section, and open the "Availability - This Year Report". Then change the report name and save as to keep a copy of the canned report, navigate to the time frame section and adjust accordingly. You can add filters using the "filter results".

See if the audit logs caught anything. Look at the events over the past few hours. Change the top number accordingly. This hopefully tells you what change was made and where. (use the db manager) select top 1 * from AuditingEvents

Hi Tacker, I think that you are talking about adjusting the default maintenance time. To change that time navigate to the Solarwinds admin page and look for 'Polling Settings' under 'Threshold & Polling' section. Look for 'Database Settings' and find the 'Archive Time', enter the time you want under that column and hit…

How far back do you want to run reports for? I think that the starting point, if you haven't already done so is adjust your retention settings. Orion will summarize and eventually dispose certain data tied to your request. Also, are you looking for a 95th percentile report specifically ?

Hey Sotherls, I work on multiple SW environments. Every environment I manage publishes reports immediately, if I had to guess a time I would say that it's easily under 1 second. The only thing that comes to mind for latency aside from insufficient resources on your NPM box is the report not saving to the reports folder.

Hi Sk3l3t0r, Assuming that you are on the newer NCM where the NCM db is married to the NPM db. I would approach this in the manner below. Note: I manipulate my devices via custom properties, the query below is written for you to accomplish your work in the same way. Since we have different custom properties ensure to…

Hey Matt, So, your best bet might be using SQL SSRS. Depending on how many customers you have, you can get away with creating individual reports and linking them to a dashboard where they select which report they want to view.

What Solarwinds products do you have ?

It's called StatusLed as you mentioned. Is this a web based report or the report writer ?

Different way to slice the pie, same data: Select SNMPVersion, COUNT(SNMPVersion) AS Total From Nodes Where ObjectSubType = 'SNMP' Group by SNMPVersion,SNMPVersion

Hi Gadbekr, This method will give you hour summarization, if the 30 minute intervals are a must something can be scripted out. Or someone might already have such report on the forum. Step 1: Open the “Orion Report Writer “ Step 2: Select “New Report” and select “Historical – Interface Traffic” Step 3: Navigate to the…