Idea ID: 2780493

Report on Devices with Settings overrides

Status : Waiting for Votes
Waiting for Votes
See status update history
over 3 years ago
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.

Labels:

ZENworks Control Center
Parents
  • 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 ON zzo.zuid=zss.objectuid 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
Comment
  • 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 ON zzo.zuid=zss.objectuid 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
Children
No Data