Example 1: Pass-through Configuration File

Data Platform

The following example is an customized configuration file that you can use as a basis for building your own configuration file.

<?xml version="1.0" encoding="utf-8" ?>

<configuration LoaderConfig="disc4_loader_config_201304" Disc_Source="DISCOVER">

 

<Connection Type="ORACLE">

<Property Name="Host" Value=""/>

<Property Name="Service Name" Value=""/>

<Property Name="User ID" Value=""/>

<Property Name="Password" Value=""/>

<Property Name="Port" Value="1521"/>

</Connection>

 

<Tables>

<Table Type="AddRemove">

<SQL>

<![CDATA[

“
”
]]>

</SQL>

</Table>

“

”

<Table Type="Pass-through" Name="MU_HOST" Dynamic_subtype="Machine" Label="Discovered CPU">

 

<Fields>

<Field Name="MachineID" DataType="NVARCHAR(255)" Nullable="1" DefaultValue="" Comment="" Key_Position="1" FileColumnName="Key-MachineID:MachineID" />

<Field Name="NUMCPUS" DataType="NVARCHAR(255)" Nullable="1" DefaultValue="" Comment="" Key_Position="0" FileColumnName="NUMCPUS" />

<Field Name="NUMCORES" DataType="NVARCHAR(255)" Nullable="1" DefaultValue="" Comment="" Key_Position="0" FileColumnName="NUMCORES" />

</Fields>

 

<SQL>

<![CDATA[

SELECT

MachineID as "Key-MachineID:MachineID",

NUMCPUS,

NUMCORES

FROM (

SELECT DISTINCT

c.OPERATINGSYSTEM_ID as MachineID,

COUNT(c.CPU_ID) as NUMCPUS,

SUM(cpu.CORES) as NUMCORES

FROM BDNA_CPUS c

INNER JOIN BDNA_INV_CATALOG_MAP m ON c.operatingsystem_id=m.inv_asset_id

AND c.inventory_id = m.inventory_id

INNER JOIN BDNA_HW_CPU_INFO cpu ON m.cpu_id = cpu.hw_cpu_id

INNER JOIN (

SELECT OPERATINGSYSTEM_ID, INVENTORY_ID FROM BDNA_ALL_OS WHERE LEVEL2='Y' AND INVENTORY_ID IN (SELECT MAX(INVENTORY_ID) FROM BDNA_INVENTORY_INFO)

)R ON R.OPERATINGSYSTEM_ID=c.OPERATINGSYSTEM_ID

AND R.INVENTORY_ID=c.INVENTORY_ID

GROUP BY c.operatingsystem_id

)T

]]>

</SQL>

 

</Table>

</Tables>

</configuration>