ADDMNetworkDevices_ci (Staging Table)

IT Asset Management (Cloud)

Data in this staging table may also be saved in ADDMNetworkDevices.xml on the staging server.

Important: This staging table is only used by Flexera One and is not applicable to IT Asset Management.

BMC Discovery query

This query extracts the known network devices from BMC Discovery, saving the details in the table below:
search NetworkDevice show name, type, vendor, model,  
#InferredElement:Inference:Associate:DiscoveryAccess.endpoint as 'Scanned via', serial as 'Serial ID', key as 'Key'

Mapping into ADDMNetworkDevices_ci

Source alias Cluster_ci property Type Max
Name Name nvarchar 255
Type Type nvarchar 255
Vendor Vendor nvarchar 255
Model Model nvarchar 255
Scanned via IPAddress nvarchar 255
Serial ID SerialNo nvarchar 255
Key Key nvarchar 255

IT Asset Management (Cloud)