0 Replies Latest reply on May 29, 2007 9:24 AM by Sean Berry

    How to dump all the properties before a destructive upgrade

    Sean Berry

      Here's a quick query for 6.3.3 to dump out the set of all device property values in well-formed CSV format, suitable for reimport with blcli Utility bulkSetServerPropertyValues

       

      Add the columns "Server Name,Property Name, Property Value" to the top.

       

      select '"'||trim(d.name)||'","'||trim(p.name)||'","'||trim(dpv.value)||'"'

      from device d, property p, device_property_value dpv

      where d.device_id = dpv.device_id

      AND p.PROPERTY_ID = dpv.PROPERTY_ID

       

      Example output:

       

      "spnweb01-1","CPU_SPEED","500"