zackm ✭✭✭✭✭

Nice catch. Looks like I am going to have to rebuild a bunch of reports too You could either get what you are looking for directly from the 'AlertActive' table, or from the 'AlertStatusView' (it's probably best to go to the view if possible). Just a note, AlertStatusView has a 'TriggerTimeOffset' column that is a…

Re: How do you reference an application custom property in an alert. I would start here. -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems * Twitter: @Loop1Systems

That's an interesting question, but you'd need to provide more details to what exactly you'd like to see as an end-result. The calculation of Availability for a node really only makes sense over time. Every single time SolarWinds polls for availability on a node, the result is binary. Meaning that, in the simple example of…

Can you post a screen shot of your alert trigger as well as the OID that you want to alert on?

You want to use the TCP Port Monitor component. You can define any TCP Port with this monitor. http://www.solarwinds.com/documentation/en/flarehelp/sam/content/orionapmphcomponenttypestcpport.htm -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems *…

Congrats and Welcome!

That's actually a pretty cool idea! The way I would approach this would be to setup an alert on your interface utilization; then use the alert action to email a webpage. Just point that webpage to a report that you build that shows the other interfaces with >50Mbps traffic. -ZackM Loop1 Systems: SolarWinds Training and…

email sent directly

Here's one that will cover the last 7 days for NPM. You can change the time period, but it is dependent on the event log retention settings. Nodes Added and Removed_Last 7 Days

Surely, you need to add multiple Map Resources onto the page in question. * Add resources * Search for "Map" * Select the "Map" resource * Submit * Copy the Map Resource to have multiples * Click "Done" to go back to your main page and then select the maps that you want to display in each resource. -ZackM Loop1 Systems:…

the problem is that the data in that view does not have hours annotated, so your limitation on the hours of the day won't work: 2016-05-17 00:00:00.000 2016-05-10 00:00:00.000 2016-05-05 00:00:00.000 2016-06-03 00:00:00.000 2016-05-13 00:00:00.000 Try this, pulling from the ResponseTime view (which is actually the basis of…

Please see below: Trigger Condition Page: Reset Condition Page: Trigger Action Page: -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems * Twitter: @Loop1Systems

The ConnectNow feature only works with devices that were discovered in NPM using Network Sonar Discovery. From the Network Atlas Admin Guide: Connecting Objects Automatically with ConnectNow Using the ConnectNow tool, Orion Network Atlas can automatically draw lines between directly connected nodes on your network. Notes:…

Try this: SET NOCOUNT OFFSET ROWCOUNT 0DECLARE @StartDate DateTimeDECLARE @EndDate DateTimeSET @StartDate = CAST((ROUND(CAST(GetDate() - 7 AS FLOAT), 0, 1)) as datetime)SET @EndDate = GetDate()SELECT Interfaces.InterfaceId, Nodes.NodeID, Nodes.Caption AS NodeName, Nodes.VendorIcon AS Vendor_Icon, Interfaces.Caption AS…

Without the VNQM module, you are not going to see the VoIP resources referenced above. You should investigate creating a universal device poller from the either ccmPhoneTable (1.3.6.1.4.1.9.9.156.1.2.1) and ccmGatewayTable (1.3.6.1.4.1.9.9.156.1.3.1) or the ccmRegisteredPhones or ccmRegisteredGateways scalar OIDs…

There are a host of legacy reports still available under the category "Historical IP SLA Operation reports" from the old Report Writer application. What you are asking for is also fairly easily accomplished via SQL, but if memory serves it is easiest to group your report results by operation type(s). What kind of…

Using SQL: SELECTn.Caption 'Device',n.IP_Address 'IP Address',c.Name 'Connection Profile',p.LoginStatus 'Login Status',p.DeviceTemplate 'Device Template'FROM NCM_NodeProperties pJOIN NCM_ConnectionProfiles c ON c.ID = p.ConnectionProfileJOIN NodesData n ON n.NodeID = p.CoreNodeIDORDER BY c.Name, n.Caption -ZackM Loop1…

Are you trying to group the results based on the "ResponsibleTeam" custom property that comes builtin with the product? Try this out: SELECT ISNULL(cp.ResponsibleTeam,'No Team Selected') 'Responsible Team' ,ac.Name 'Alert Name' ,ao.EntityCaption 'Alert Object' ,ac.ObjectType 'Object Type'…

Can you post the SQL query? -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems * Twitter: @Loop1Systems

Are you looking for something more like this? selectc.name as 'group name',n.caption as device,round(avg(r.availability),2) as 'avg availability'from Containermembersnapshots sjoin containers c on c.containerid=s.containeridjoin nodes n on s.entityid = n.nodeidjoin responsetime r on r.nodeid=n.nodeidwhere…

Have you looked at Orion.TopologyConnections and Orion.TopologyData? Do you have a screenshot of the resource you're referencing? I can't recall if NPM on its own has a specified "CDP" resource, I'm pretty sure NCM has something like that. ( Cirrus.CiscoCDP in SWQL )

That's a SQL View Basically a predefined compilation of tables that the developers create for ease of use and abstraction. -ZackM Loop1 Systems: SolarWinds Training and Professional Services * LinkedIN: Loop1 Systems * Facebook: Loop1 Systems * Twitter: @Loop1Systems

1) Do you continue to visit the solarwinds.com website? How often? What kind(s) of content do you normally go looking for on solarwinds.com? 2) How often do you log into the customer portal? Other than product upgrades, what other content do you visit the customer portal for? 3) How long after you became a customer did you…

First of all, thanks for the mention As to your questions: * What SQL version and architecture are you using (separate database, named instances, etc.)? - SQL 2008 Standard x64 using MS Failover Clustering - Named Instances; separate Warehouse and Production DBs * What architecture have you found helps in the speed…

You need to change your Volume Types into an "OR" block this is what you have right now: Department_Email = email@domain.com ANDSupportEnvironment = Production ANDVolumeType = Fixed Disk ANDVolumeType = Mount Point You cannot have a Volume that is both a Fixed Disk AND a Mount Point (which is why you are getting 0 results)…

One of my favorite SQL Procs First, you create a PROC in SQL Server Management Studio: CREATE PROC Update_CaptionAS@Caption nvarchar (50),@Ip_Address nvarchar (50) AS Update Nodes Set Caption = @Caption Where IP_Address = @Ip_Address Then you run the procedure as follows: EXEC Update_Caption 'newhostname','xxx.xxx.xxx.xxx'…

The easiest and most upfront way would be to trend you elements count per month manually. SELECT ServerName, Elements, Nodes, Interfaces, Volumes FROM Engines Create a custom SQL report using the above script and then schedule it to run on the 1st of every month and manually compile the 24 months of data. Otherwise, you…

Are you saying that the following happened? * NodeA went Down * Alert1 was triggered * NodeA was Unmanaged * Alert1 still exists If that is the case, then the answer is "it depends." You would need to look at your Alert Reset condition in the Advanced Alert Manager. Out of the box, the Node Down alert only reset when the…

Couple of places I would check first: * Orion Database Maintenance Schedule* Settings > Polling Settings > Database Settings - Archive Time (Default is 2:15am) * NCM Jobs* Configs Tab > Jobs > Look for the Default Database and Archive Maintenance, Nightly Inventory, and Nightly Config Backup jobs All of these jobs (and any…

Can you be a bit more descriptive in your first criteria? What do you consider "Historical Interface Bandwidth"? Last 24 hours, 7 days, 3 months, year?