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



      Example output: