Environment
Novell ZENworks 11 Configuration Management Support Pack 1 - ZCM 11 SP1
Novell ZENworks 11 Configuration Management Support Pack 2 - ZCM 11 SP2
X Novell ZENworks 11 Configuration Management Support Pack 1 - ZCM 11 SP1
X Novell ZENworks 11 Configuration Management Support Pack 2 - ZCM 11 SP2
Situation
WIS error when running a report that contains managed device zuid.
Resolution
View the sql of the report. Choose the option to enter custom sql. Replace binaryToHexString with dbo.binaryToHexString.
For example, for a report containing machine name, primary user and zuid:
SELECT
zZENObject1.Name,
zZENObject6.Name,
dbo.binaryToHexString(zDevice1.zuid)
FROM
zZENObject zZENObject6 RIGHT OUTER JOIN zReference zReference4 ON (zReference4.ZUID=zZENObject6.ZUID)
RIGHT OUTER JOIN zDevice zDevice1 ON (zDevice1.PrimaryUser=zReference4.ZUID)
INNER JOIN zZENObject zZENObject1 ON (zDevice1.ZUID=zZENObject1.ZUID AND zZENObject1.PrimaryType = 'Device')
WHERE
( zZENObject1.Path like '/~dev%' )
zZENObject1.Name,
zZENObject6.Name,
dbo.binaryToHexString(zDevice1.zuid)
FROM
zZENObject zZENObject6 RIGHT OUTER JOIN zReference zReference4 ON (zReference4.ZUID=zZENObject6.ZUID)
RIGHT OUTER JOIN zDevice zDevice1 ON (zDevice1.PrimaryUser=zReference4.ZUID)
INNER JOIN zZENObject zZENObject1 ON (zDevice1.ZUID=zZENObject1.ZUID AND zZENObject1.PrimaryType = 'Device')
WHERE
( zZENObject1.Path like '/~dev%' )