ioan_bucsa ✭✭✭✭✭

Nope. I haven't looked into this for quite a while now, but based on your question I'm guessing the triggers are still stored in the same XML format.

Try SysName LIKE '%School%' OR SysName LIKE '%Ysgol%'

Not likely.

Alerting on Cisco thin APs can be a bit of a headache even though it seems quite trivial at a glance. Part of it is because of how Cisco designed the system; basically, when an AP is disassociated from a controller it just removes it from its list of APs (in theory there is a 'Disassociating' operational status for APs,…

While production was down we stood up a VM running Zabbix (never used it before, but all the struggles make you miss Orion even more :) ) plus several dashboards in Grafana that fed off the Zabbix DB so that we could keep a minimal level of alerting going. We rebuilt the severs from scratch and only migrated the Orion DB…

Yup. Same here, we were down for about 2 weeks. 

Have you looked at the Upgrade Advisor? https://support.solarwinds.com/SuccessCenter/s/article/SolarWinds-Product-Upgrade-Advisor?language=en_US

Not that I can think of...I think having the ability to define the group type along with current capabilities would satisfy most of our needs.

@"serena" If only it said that in the message before the login prompt...Oh wait, it does Thanks!

How about if you are trying to run the query via REST? If I use SUM(<nvchar>+0) I get "no viable alternative at input '0' in Select clause". Any thoughts?

@"serena" Nope. It's prompting for user and password and my thwack credentials do not seem to work.

But future version of the API might make those properties editable?

Ok. Tried it and it kind of helps. But there are a few properties that are not accessible (like GroupTypeText). So you can create just subnets (no supernets or groups); I tried doing a create for IPAM.GroupNode but that is not possible. Just to give you a bit of a context: we currently have another IPAM tool that we are…

Thanks. Maybe it will get fixed in a future version.

@"serena" can I please get access to the SAM Beta section? I can't seem to be able to access it

We currently have 5 polling engines (4 APEs), about 30K elements and the total DB size (Orion + NTA) is about 500GB. The DB server is physical and we went with 768GB RAM (which might be a bit oversized at the moment) out of best practices considerations while also leaving some room for future growth (we expect to triple…

I was really looking forward to this release mainly because it was supposed to add "extended API capabilities" such as adding subnets. I installed the Beta and apparently you can add subnets using just an IP and CIDR. The bad news is that those are the only parameters that can be used. So basically you can add subnets with…

Make sure to check 'Allow HTML tags' for table columns that contain HTML code:

Update SNMP Community string using PowerShell This is the issue basically in more detail.

That being said, I'm not sure what might help improve our performance: 1. Separate (smaller) DB servers 2. Instance stacking 3. Somehow increase IOPS (unlikely in the current setup, since we currently have SAN) 4. Performance tuning the existing server/DB

Without massive amount of custom scripting ... not really.

Try this: WHERE n.CustomProperties.SAP_Printer = 'YES' Also, I now notice that you query is SQL, whereas the one I suggested is SWQL, but that should not be a problem since Custom Table supports both.

Well, SWQL has REPLACE. You could insert a SWQL variable and use the function to properly format your output: https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions 

@"cboyce" Tough one. Like @"mesverrum" mentioned, this stuff is tricky even in SQL. Trying to think if there isn't a better approach altogether...

I see... I don't know of any method that you could use in order make use of the 'Custom Query' widget. Maybe someone else could weigh in on this.. I have something similar (a separate DB residing on the same server containing my custom tables) and have used some HTML+JS, ASPX or embedded external sources (Grafana) to…

${N=SwisEntity;M=CustomPollerAssignmentID} is probably incorrect. Try to insert the variable associated with Custom Poller Assignment ID.

12.1

Sorry.. I missed the "report" portion What exactly is missing?

Nor really. This generates the report based on data already in NCM; it does not query/poll the device in real time.

Depends on what version you are running. Anything newer than 7.5 uses the new GUI and has a Settings drop-down menu. Admin rights can be assigned to a certain module only and in that case you will find the NCM Settings list on the Config summary page (top right corner).