zackm ✭✭✭✭✭

surely, you just need to identify the node you want and add its particular nodeid in place of the ${NodeID} variable

are those SNMP nodes? also, save your report and test it on the website to ensure functionality. there are known areas (like testing an alert) where the 'test/preview' doesn't give you valid data for your environment.

no idea; it was designed for a custom query resource, but my assumption is it would have worked with a custom table as well. (especially if it previews correctly in the datasource)

I don't think you can create Orion-specific groups, only individual accounts. (Someone else may chime in and correct me on that). Might be a good idea to go into the Feature Requests section.

you could create a warehouse or new table in SQL and use it to store your deleted interface data. You really would only effectively be storing your custom properties this way though. Everything is going to use the InterfaceID, which is a unique key that is not repeated, (i.e., when you delete and re-add an interface, it…

Those are your FriendlyName entries under GroupType 'Group' For Instance: SELECT t.GroupType, g.FriendlyName, g.Address, g.AddressMask, g.CIDR, g.Comments FROM IPAM_Group g JOIN IPAM_GroupType t ON t.GroupTypeID = g.GroupType WHERE t.GroupType IN ('Group', 'Subnet', 'Supernet') ORDER BY t.GroupType, g.FriendlyName Gives…

Sure thing! The Operation ID we need here is the one SW is using as the primary key in that table. The easiest way to get that, outside of SQL, would be to navigate to the operation details page and then grab it off of the URL. (In this case, the OperationID is 13) You could also gather your IDs in SQL with the following…

Try just %SQL% I do not remember having to use the SQL clause in this particular instance.

I would post this in the Report Lab with your sample script and I (or someone else) can take a look at it.

Roger that, here's the issue: In the Alert Engine, Custom SQL and SWQL alerts have a built-in SELECT statement (highlighted below) So, what you are doing right now is this: SELECT VoipCallDetailsAlert.ID, VoipCallDetailsAlert.Name FROM VoipCallDetailsAlertSELECT VoipCallDetails.[FinalCalledPartyNumber], count(*) as…

Absolutely correct. SNMP/WMI statistics polling will exponentially increase the load on your polling engine as well. However, there is not an equivalent to the Node Warning Level with statistics polling. Default is 9 min interface, 10 min node, 15 min volumes. If you need to change any of that for faster responses, I would…

There should be an "AlertLog" table... I have this lying around in my dropbox from years past... select a.alertname as 'Alert Name', x.qty as 'Times Alert Triggered'from alertdefinitions ajoin (select count(1) as qty ,alertdefid from alertlog where logdatetime > (getdate () -30) and message = 'alert triggered' group by…

do you mind sharing your API call here? I've used Unmanage a ton, but my service account for API calls does have elevated permissions. I'd like to try and emulate on our side for you so you can know if it's a bug to be logged with support. CC: tdanner​ or dan jagnow​; they might know off the top of their heads if this is a…

The older Advanced Alert Manager is an application that you would need to RDP to your server to use. The newer version is web-based and can be accessed from your SolarWinds website. Generally speaking, you can call your node custom properties with the following format: ${Nodes.Store_Brand} and ${Nodes.Store_Number} The web…

Can you show us a screenshot of the results of this query? SELECT * FROM CustomPollerStatusTable WHERE CustomPollerAssignmentID = 'e9XXXX2f-0488-4XX4-9XX7-ca3eXXXXX2bb' AND RowID = '20'

For the 2 interfaces, do they have some sort of identifying feature to key off of? ie. - where interface description = 'uplink' or all primary are serial0/1 and all secondary are fa1/0? if not, then you would need to create a custom property for the interfaces and tag them so you can key off of that in the sql query.…

have you tried get-next?

That won't work because you're not doing any math against the data, you're just changing the way it looks. Custom Format {0:0.00} % means "Return an integer with 2 decimal points of precision and then add a percentage symbol at the end" It's not really creating a percentage, it's just appending a symbol to the end of the…

I mean, if we're using broken metrics then I shall rightfully claim my spot as Number B on the boards!

http://thwack.solarwinds.com/docs/DOC-172769

I'm not sure that can be done. What is checked is the only thing in the database. To my knowledge (and I could be wrong) the rest of the items are brought in temporarily through an SNMP/WMI query against the device only when you click "List Resources". If you do not check them and then submit, they will be dropped as they…

So, without seeing the values being returned by your pollers, I am looking specifically at the alert logic right now. This is a replica of your situation, just using a different tabular poller: Now, when we look at the raw SQL syntax behind this alert, we can test and get the following error: Basically, what we are seeing…

this should get you in the right direction: you can use the web report writer to create a custom SQL report and then use this query. selecta.name as 'ALERT',o.entitycaption as 'ALERT OBJECT',o.entitytype as 'ALERT OBJECT TYPE',o.relatednodecaption as 'RELATED NODE'from alertobjects ojoin alertconfigurations a on a.alertid…

SELECT VI.VOIPOPERATIONINSTANCEID ,VT.OPERATIONTYPE AS 'OPERATION TYPE' ,CASE WHEN ST.OPERATIONSTATUS = 'UNKNOWN' THEN 'UNKNOWN.GIF' WHEN ST.OPERATIONSTATUS = 'UP' THEN 'UP.GIF' WHEN ST.OPERATIONSTATUS = 'DOWN' THEN 'DOWN.GIF' WHEN ST.OPERATIONSTATUS = 'WARNING' THEN 'WARNING.GIF' WHEN ST.OPERATIONSTATUS = 'UNREACHABLE'…

Just a cursory glance, but this seems straightforward enough. I would HIGHLY recommend looking at a Web Report for this job. You could easily stack the 3 sections of this query into 3 separate reports (basically removing the UNION statements) and then each one can have its own title. Something like this: -ZackM Loop1…

can you post a screenshot of your SQL results from this query (replacing ID with the GUID from your original query: SELECT * FROM CustomPollerStatusTable WHERE CustomPollerAssignmentID = 'ID'

If you go into Settings > Manage Alerts, you will see the alert management section where you can edit alerts to your heart's content. What you are probably wanting to do is to change the scope of the Node Down alert to ignore APs. Here are some good videos covering this topic in more detail:…

looks like you've found a bug in the web report engine. I'm seeing the same issues on this side. I would suggest opening a ticket with support to get a resolution. in the meantime, you could get a similar report via a custom SQL query as such: SELECT n.Caption 'Device' ,i.Caption 'Interface' ,MAX(In_Maxbps) 'Peak Receive…

You might get some direction here: (page 5) http://www.solarwinds.com/documentation/Netflow/docs/OrionNetFlowSwitches.pdf And here: Catalyst 6500/6000 Switches NetFlow Configuration and Troubleshooting - Cisco Systems

To my knowledge, they have always been in the 'Reports' folder. Have you tried searching your backups for the file extension " .OrionReport " ?