ioan_bucsa ✭✭✭✭✭

Maybe at some point I will get around to structuring my code and creating a PS module that could be useful to others that know the pain of migrating to IPAM

Same question

Cool. The one thing that's bugging me regarding custom tables the info showing up on the left corner (datasource, sort and group options). Wish there was a way to hide that

Not if you run the SQL query at the end of the original post.

Also, you can use SWQL Studio (https://github.com/solarwinds/OrionSDK/releases) to inspect the syntax for any verb and even invoke it directly:

Actually scratch that; SUBSTRING generates a new column rather than a new row.

Is this still accurate as of 2020.2? We upgraded at the beginning of the month and we noticed that InterfaceTraffic_Details only contains data older than the time of the upgrade. It was being used by another team to extract data, store it to a data warehouse to be used for long-term reports.

Depending on the number of devices that you are trying to monitor and your licensing you could have a look at SAM 2019.4 feature: API Poller. It lets you poll certain statistics from the vmanage API, but unfortunately it does not scale very well (there is currently no way to create a template and assign it to multiple…

What is considered a high volume of Flows Per Second? We run the Orion & NTA DB on the same physical server (which is quite beefy : 2x CPUs w/ 10 cores each and 768GB RAM and about 2.5 TB of storage) but we sometimes experience some NTA slowness. I wonder if this could be solved by moving NTA DB on its own server/DB…

What about us other folks not using ACI?:) Not many options outside Cisco. For example we tried monitoring Viptella gear (which is basically Cisco) and outside basic SNMP hardware details it is pretty difficult (or quite impossible) to poll more advanced stats. 

And another one: New-SwisObject : Unable to create IPAM.Subnet. Details : Error : In property CIDR. Reason : CIDR must be greater than 21.. When adding a Subnet via the API the CIDR must be at least 21 (you cannot add larger subnets) even though the limitation is not there when adding subnets via the GUI ; I was able to…

Got another one: Set-SwisObject : Operation not supported on IPAM.GroupNode At line:23 char:1 + Set-SwisObject $IPAMswis -Uri $URI -Properties @{DisableAutoScanning="false";} + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [Set-SwisObject],…

You can easily create alerts based on SNMP traps using Trap Viewer:

Where exactly do you have to copy the ascx file? Do you have to run Configuration Wizard afterwards? I've tried different things from this thread but I seem to be missing something.

That's basically Real time change detection; you can use Sylog messages or SNMP traps to your NCM server.

I don't think this applies to newer SQL Server versions. All I see in the file is the encrypted password.

Yes and no. Using the API you can only create subnet objects (not supernets or groups) and subnets are limited to /17 (if I remember correctly). So anything larger than a /17 needs to be created manually (as a supernet) or by inserting directly into the DB. This could be solved if the GroupType field would be editable via…

I tried to install the plugin but for some reason grafana does not see it as a datasource (download zip, extract in data/plugins and restarted Grafana). What am I missing? I am using Grafana 6.2.5

Well. I've tried setting other properties and I don't get the error. It may have to do with the fact that I'm trying to update the SNMP community, but like I said, my node is a v2c node, node a v3 node so the error is kinda random...

Today I found another annoying limitation of the API. Since you can only create subnets the maximum CIDR is 21.

Have you tried adding AND DisplayName NOT LIKE '*<Filter_Criteria>*' at the end of your SWQL query?

The DeviceId column in Orion.Volumes looks to be what you are looking for: Depending on your use case, you could either use SWQL to query Orion.Volumes or you could use ${DeviceId} directly in the web console.

We have a similar table showing nodes that have been down (or status = 'Warning') along with downtime and a few other details. The query I've used is: SELECT n.caption as Node ,CASE WHEN n.URI IN (SELECT EntityURI FROM Orion.AlertSuppression) THEN 'Y' ELSE 'N' END as IsMuted ,n.detailsurl as [_linkfor_Node] ,CONCAT('<img…

Short answer: Without any customizations, not really. Longer answer: There are a few possibilities: - Write custom code that periodically queries the ServiceNow API and pulls CIs based on status (or other fields) - ServiceNow has a functionality called Business Rules and this allows you to run custom JS code (post to…

I think you can achieve this by creating an alert: - Trigger condition: filter VMs that you would like to reboot - Reset condition: none - Time of day: specify the interval during which you alert would run - Trigger action: Manage VM - Reboot Personally, I have not using this particular mechanism, but it should work.

Starting with IPAM 2019.4 this is possible by using the CreateSubnetForGroup verb. For syntax check out the SDK Wiki : https://github.com/solarwinds/OrionSDK/wiki/IPAM-2019.4-and-higher-versions-API 

The documetation seems to suggest that subqueries are supported: https://support.solarwinds.com/SuccessCenter/s/article/Use-SolarWinds-Query-Language-SWQL?language=en_US Common SQL Constructs Supported SWQL supports the following constructs from SQL: Note: You must use CRUD operations to create, read, update, or delete…

<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script> <script type="text/javascript"> <!--Insert Chart JS Here --> </script> </head> <body> <div id="VOLUME" style="width: 900px; height: 500px;"></div> </body> </html> Your SWQL query seems to contain some errors though. You might want to…

As a personal recommendation, set the AP Name as the label for your status Custom Poller (it should be in the same MIB). For the SQL Alert select 'Custom Node Table Poller' and the query is: SELECT CustomPollerStatusTable.FullLabel, CustomPollerStatusTable.CustomPollerAssignmentID, CustomPollerStatusTable.CompressedRowID…

As a personal recommendation, select the AP name as the label for the status Custom Poller (Label is also stored in CustomPollerStatusTable). Then you select Custom SQL Alert and Custom Node Table Poller in the trigger condition. The SQL query is : SELECT CustomPollerStatusTable.FullLabel,…