This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Stored Procedure to Update Fields

jdheltne over 9 years ago

I am looking for a stored procedure in SQL server that I can use to maintain my data in the IPAM and SAM database for certain fields. Specifically, we added 2 custom fields, AD_Site and Site_Code to IPAM and I want to basically update the info based on information in another table, which could be in another database. Im still working out what is the best way to do this, be it a table that has the IPAM folder structure and then the AD_Site and Site_Code mappings in them or whatever. This is just 1 of the maintenance functions I am looking to do.. Has anyone done this and if so, do you have an example?

Thanks,

Jason

Top Replies

HolyGuacamole over 8 years ago +1

Are you looking for a fully automated process? i.e., the SP is also reading from your other database? If not, you can use the import /export custom properties from Manage Custom Properties at least for…

0 njoylif over 9 years ago

This is when NCM DB was separate from NPM...I had a SQL Agent Job to move date between DBs and tables.
NCM IP Addresses / Subnet Masks to NPM DB - interfaces table
it would be similar but you wouldn't need the <DB>.dbo. part. just table names and joins
Cancel
Vote Up 0 Vote Down

Cancel
0 jdheltne over 8 years ago in reply to njoylif

So then as long as I know what to update there is no issue with updating this way?
Cancel
Vote Up 0 Vote Down

Cancel
0 njoylif over 8 years ago in reply to jdheltne

It really depends on the table and target columns. if Orion has the potential to natively update it during the course of its normal operations, I probably wouldn't mess with it, or be sure to test it thoroughly. I mostly update into custom properties, though I now have SPs that update notes and thresholds. Gauge the risk based on your environment and what you are trying to update. outside of that, using SPs to update is common practice.
Cancel
Vote Up 0 Vote Down

Cancel
0 HolyGuacamole over 8 years ago

Are you looking for a fully automated process? i.e., the SP is also reading from your other database? If not, you can use the import /export custom properties from Manage Custom Properties at least for SAM. If you want to leverage naming conventions, and other attributes polled by default, you can also use the Alert Manager as outlined below
TIPS & TRICKS: Custom Property "Policies" using Alert Manager
Another option to consider is API. I have attached the sample PowerShell script that comes with the SDK download - again this will work only for SAM. IPAM currently doesn't have any write APIs.

CRUD.SettingCustomProperty.ps1
Cancel
Vote Up +1 Vote Down

Cancel