Admin Settings - Discrepancies Between Library and Branch Settings

This shows all administration settings where branch settings are different from their parent library’s setting for the same attribute. This is useful for determining if some branches aren’t inheriting settings anymore, or otherwise monitoring purposeful differences.

I’ll note, the verbiage for the settings isn’t always clear, and you may need to hunt down some settings based on the Mnemonic and AttrDesc, though the AttrClassDec should help. Also some setting values may be IDs for other tables (i.e. a PolarisUserID) that you may need to look up separately.

Admin - SA Setting Branch-Lib Discrepancies.sql (2.3 KB)

2 Likes