Certain information within XIA Configuration Server is stored as override strings. These allow the XIA Configuration Client to read a value from a target system such as the description of a Windows Server and display it in the user interface whilst allowing the user to manually override and edit this value.



As this information is stored as XML, executing the following query will display XML only

<OverrideString Value="" AgentValue="" Overridden="false" />


SELECT 

  [ItemCore].[ItemID] AS [Item ID],

  [ItemCore].[Name] AS [Item Name],

  [ItemCore].[Description] AS [Description]

FROM 

  ItemCore

WHERE 

  ItemDeletedDate IS NULL




The GetXValue function returns only the value displayed to the user.


SELECT 

  [ItemCore].[ItemID] AS [Item ID],

  [ItemCore].[Name] AS [Item Name],

  dbo.GetXValue([Description]) AS [Description]

FROM 

  ItemCore

WHERE 

  ItemDeletedDate IS NULL