XIA Configuration Server stores information collected by the XIA Configuration Client within the database as XML data.


For example the following displays abbreviated information collected by the IIS server agent relating to application pools.


<ApplicationPools>

  <ApplicationPool AutoStart="True" ManagedPipelineMode="Integrated" ManagedRuntimeVersion="v4.0" Name="ASP.NET v4.0" QueueLength="1000">

  </ApplicationPool>

</ApplicationPools>


The following example shows how to read each application pool using CROSS APPLY and the T-SQL XML value method.


SELECT 

  [ItemCore].[ItemID] AS [ItemID],

  [ItemCore].[Name] AS [IIS Server],

  [ApplicationPool].value('@Name[1]', 'NVARCHAR(200)') AS [Application Pool Name],

  [ApplicationPool].value('@ManagedRuntimeVersion[1]', 'NVARCHAR(200)') AS [Managed Runtime Version]

FROM IISServers

INNER JOIN ItemCore ON ItemCore.ItemID = IISServers.ItemID

CROSS APPLY ApplicationPools.nodes('/ApplicationPools/ApplicationPool') AS T(ApplicationPool)

WHERE

  [ItemCore].[ItemDeletedDate] IS NULL