When developing or troubleshooting, one may choose to override a setting(s) for a device, but sometimes (too often) one may forget to reset the settings back to global. I'd like a way to find/view all devices that have any settings overrides within ZCC.
Done this too many times when testing using system variables or installing agent components.
Here is a db script to run for Overrides until this enhancement is integrated into the ZCC. This is for the internal sybase and syntax should be modified for your db.
SELECT zzo.Name as "Device", zzo.Path, zss.Name as "Setting", zss.ModifiedTime, zss.Data from zSystemSetting zss
INNER JOIN zZENObject zzo
WHERE zss.ObjectUID IN (select ZUID from zDevice)
OR zss.ObjectUID IN (select ZUID from zFolder)
AND zzo.Path NOT like '%/~bundles~%'
ORDER BY zzo.Name