sql query to list system update errors

  • 7022500
  • 22-Dec-2017
  • 22-Dec-2017

Situation

This is an internal TID.  ZCC shows devices with error in System update.  To see details, it's necessary to drill into the error.  SQL query to list errors with details.

Resolution

select zdevice.hostname, updateName, statusMessageKey, StatusMessageParams from zSystemUpdateDeviceInfo join zdevice on zdevice.zuid=zSystemUpdateDeviceInfo.DeviceUID where UpdateStatus = 'ERROR'