Written by

Technical Architect at OPTIMUS IT INFRA
Question prashanth ponugoti · Apr 25, 2022

Settings from ENS_Config.Item returns boxes in place of property values

Hi Community,

Below Query is returning boxes in place of values, I want to list all tragetconfigs , IP addresses, and ports for each business hosts components.

Could you please help me, Otherwise I need to do manually will take a long time to prepare list?

Product version: IRIS 2021.1

Comments

Robert Cemper · Apr 25, 2022

this are not properties but an ERROR Status Object.
the boxes are non-printable binary values from $LB() or similar.

0
Matthew Waddingham · Apr 26, 2022

You can potentially use a $ListToString(.. or LIST(... or some other similar option in Sql to extract the values as part of the query and avoid the special characters. 

0