Mass assign Universal Device Pollers in Database

t.m-k

Hi THWACK,

A bit of a niche one, and I am stuck.

I have exported and imported Universal Device Pollers (UDPs) from another SolarWinds deployment. This deployment has the same nodes within it's inventory (long story).

There are ~1100 UDP's and from the previous deployment these made up ~8800 custom poller assignments over hundreds of nodes, which I've seen from the CustomPollerAssignment table.

Does anyone have any Wizard-like SQL queries to assign these UDPs to the same nodes on the new deployment, through the database?

 

Thank you.

--t.m-k

ChrystalT

You should be able to do this via SWQL. I don't have a ready query, but a quick check of the documentation shows it's possible. https://github.com/solarwinds/OrionSDK/wiki/NPM-Universal-Device-Pollers