4 Replies Latest reply on Jul 1, 2015 9:52 PM by HolyGuacamole

    Stored Procedure to Update Fields

    jdheltne

      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