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?
.png)
Product version: IRIS 2021.1
this are not properties but an ERROR Status Object.
the boxes are non-printable binary values from $LB() or similar.
Have a look at this previous thread.
And there's a built-in capability in IRIS to see ports in use by different components.
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.