I have a solarwinds server, that server is going to get split into 2 solarwinds servers. I have 76 NCM jobs and don't want to have to re-create them all by hand on the 2nd solarwinds servers. Is there a way to export/import NCM jobs? Thanks.
The only way I can think of is you're going to have get down and dirty with SWQL Studio.
A quick search in our DB shows me Cirrus.NCM_NCMJobs appears to hold all the relevant information.
Just right-click the table and click on 'Generate Select Statement' and then run it. Highlight and export the ones you want and copy/paste into a spreadsheet. I can even see there is an AddJob verb - but don't ask me how you might actually use that side, but it looks like this thread: ORION NCM : Create jobs through the API could answer those questions.
Thanks for your reply, that looks like it will work, and I appreciate you giving me a working solution, but since I'm a network engineer that doesn't even use windows, i'm not going to try to install software and do a bunch of sql things that I don't understand on a production server. I was hoping that solarwinds itself had an export feature, but it looks like it doesn't, so I'll start going through each job and manually copying them.
I am also a network engineer Tim and have landed in this role with no SQL or SWQL knowledge. Late in my career I have had to start picking it up.
FWIW, the API software (SWQL Studio) can be installed anywhere that can connect to the server. You can also use the provided SolarWinds DB manager, but then you are messing directly with the DB with all the warnings that usually come with that. That uses SQL unlike the API which uses SWQL (subtle but meaningful differences) - I don't have the skill to cross-convert the code to SQL, plus the tables and records are likely similar but different names.Trust me on this one... if you are going to be involved in any meaningful way with SolarWinds from a management perspective, then you will want to get SWQL Studio installed.
