Schema Definitions
- Steven Hicks
There are 2 types of tables within the uControl database. IMPORT_* tables are used for the initial data import from 3rd parth sources. Data from these import tables are then (If set to Reconcile) processed through the reconciliation engine and placed in to a ASSET_* table.
The following schema definitions are supported out of the box:
Schema | Import Table | Asset Table |
|---|---|---|
Admin Collection | IMPORT_ADMINCOLLECTION | ASSET_ADMINCOLLECTION |
Business Application | IMPORT_BUSINESSAPPLICATIONINSTANCE | ASSET_BUSINESSAPPLICATIONINSTANCE |
Cloud Provider | IMPORT_CLOUDPROVIDER | ASSET_CLOUDPROVIDER |
Cloud Region | IMPORT_CLOUDREGION | ASSET_CLOUDREGION |
Cloud Service | IMPORT_CLOUDSERVICE | ASSET_CLOUDSERVICE |
Cluster | IMPORT_CLUSTER | ASSET_CLUSTER |
Cluster Member | IMPORT_CLUSTERMEMBER | ASSET_CLUSTERMEMBER |
Cluster Resource | IMPORT_CLUSTERRESOURCE | ASSET_CLUSTERRESOURCE |
Cluster Service | IMPORT_CLUSTERSERVICE | ASSET_CLUSTERSERVICE |
Collection | IMPORT_COLLECTION | ASSET_COLLECTION |
Database | IMPORT_DATABASE | ASSET_DATABASE |
Database Detail | IMPORT_DATABASEDETAIL | ASSET_DATABASEDETAIL |
Detail | IMPORT_DETAIL | ASSET_DETAIL |
DiscoveredProcess | IMPORT_DISCOVEREDPROCESS | ASSET_DISCOVEREDPROCESS |
DiscoveredService | IMPORT_DISCOVEREDSERVICE | ASSET_DISCOVEREDSERVICE |
DiscoveryAccess | IMPORT_DISCOVERYACCESS | ASSET_DISCOVERYACCESS |
Disk Drive | IMPORT_DISKDRIVE | ASSET_DISKDRIVE |
Fibre Channel HBA | IMPORT_FIBRECHANNELHBA | ASSET_FIBRECHANNELHBA |
Fibre Channel Node | IMPORT_FIBRECHANNELNODE | ASSET_FIBRECHANNELNODE |
Fibre Channel Port | IMPORT_FIBRECHANNELPORT | ASSET_FIBRECHANNELPORT |
File System | IMPORT_FILESYSTEM | ASSET_FILESYSTEM |
Hardware Container | IMPORT_HARDWARECONTAINER | ASSET_HARDWARECONTAINER |
Hardware Reference Data | IMPORT_HARDWAREREFERENCEDATA | ASSET_HARDWAREREFERENCEDATA |
Host | IMPORT_HOST | ASSET_HOST |
Host Container | IMPORT_HOSTCONTAINER | ASSET_HOSTCONTAINER |
IP Address | IMPORT_IPADDRESS | ASSET_IPADDRESS |
Load Balancer Group | IMPORT_LOADBALANCERGROUP | ASSET_LOADBALANCERGROUP |
Load Balancer Instance | IMPORT_LOADBALANCERINSTANCE | ASSET_LOADBALANCERINSTANCE |
Load Balancer Member | IMPORT_LOADBALANCERMEMBER | ASSET_LOADBALANCERMEMBER |
Load Balancer Pool | IMPORT_LOADBALANCERPOOL | ASSET_LOADBALANCERPOOL |
Load Balancer Service | IMPORT_LOADBALANCERSERVICE | ASSET_LOADBALANCERSERVICE |
Mainframe | IMPORT_MAINFRAME | ASSET_MAINFRAME |
Mainframe Partition | IMPORT_MFPART | ASSET_MFPART |
Management Controller | IMPORT_MANAGEMENTCONTROLLER | ASSET_MANAGEMENTCONTROLLER |
Network Device | IMPORT_NETWORKDEVICE | ASSET_NETWORKDEVICE |
Network Interface | IMPORT_NETWORKINTERFACE | ASSET_NETWORKINTERFACE |
Package | IMPORT_PACKAGE | ASSET_PACKAGE |
Patch | IMPORT_PATCH | ASSET_PATCH |
Printer | IMPORT_PRINTER | ASSET_PRINTER |
Processor Information | IMPORT_PROCESSORINFO | ASSET_PROCESSORINFO |
Runtime Environment | IMPORT_RUNTIMEENVIRONMENT | ASSET_RUNTIMEENVIRONMENT |
SNMP Managed Device | IMPORT_SNMPMANAGEDDEVICE | ASSET_SNMPMANAGEDDEVICE |
Software Cluster | IMPORT_SOFTWARECLUSTER | ASSET_SOFTWARECLUSTER |
Software Component | IMPORT_SOFTWARECOMPONENT | ASSET_SOFTWARECOMPONENT |
Software Instance | IMPORT_SOFTWAREINSTANCE | ASSET_SOFTWAREINSTANCE |
Storage Connection | IMPORT_STORAGECONNECTION | ASSET_STORAGECONNECTION |
Storage Device | IMPORT_STORAGEDEVICE | ASSET_STORAGEDEVICE |
Storage Pool | IMPORT_STORAGEPOOL | ASSET_STORAGEPOOL |
Storage Processor | IMPORT_STORAGEPROCESSOR | ASSET_STORAGEPROCESSOR |
Storage System | IMPORT_STORAGESYSTEM | ASSET_STORAGESYSTEM |
Storage System Group | IMPORT_STORAGESYSTEMGROUP | ASSET_STORAGESYSTEMGROUP |
Storage Volume | IMPORT_STORAGEVOLUME | ASSET_STORAGEVOLUME |
Subnet | IMPORT_SUBNET | ASSET_SUBNET |
Support Detail | IMPORT_SUPPORTDETAIL | ASSET_SUPPORTDETAIL |
Virtual Machine | IMPORT_VIRTUALMACHINE | ASSET_VIRTUALMACHINE |