BDNA Data Platform 5.4 July 2017 (SQL Server)
DISC_ALL_OS - Operating Systems information discovered

Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
OPERATINGSYSTEM_ID numeric 20 Unique Operating System ID
INVENTORY_ID numeric 20 Inventory ID for this row
TASK_ID numeric 20 Task ID for this row
HOST_ID numeric 20  √  null Unique host ID
OPERATINGSYSTEM_LABEL nvarchar 512  √  null Operating System label
HOSTNAME nvarchar 2048  √  null Hostname
OSCOMPUTERNAME nvarchar 512  √  null Operating System Computer name
MANUFACTURER nvarchar 512  √  null Operating System Manufacturer name
OPERATINGSYSTEM_TYPE_LABEL nvarchar 2048  √  null Operating System Label (e.g., Vista, XP, etc,)
OS_FAMILY nvarchar 512  √  null Operating System Family (e.g., Windows, Linux)
EDITION nvarchar 512  √  null Operating System Edition (e.g., Professional, Standard; 32-bit x86)
VERSION nvarchar 512  √  null Operating System version (e.g., 5.1.2600, 5.2.3790)
PATCHLEVEL nvarchar 512  √  null Patch Level (e.g., Service Pack 2)
OSBUILDNUMBER nvarchar 512  √  null Operating System build number
HARDWARE nvarchar 512  √  null Hardware information (e.g., Dell Inc. Latitude D620, Compaq ProLiant DL580 G2)
NUMCPUS float 8  √  null Number of CPUS
CPU_SPEED float 8  √  null CPU Speed
OSBITMODE varchar 2  √  null Operating System bit mode (e.g,, 32-bit, 64-bit)
TOTALMEMORY float 8  √  null Total Memory
TOTMEMBUCKET nvarchar 512  √  null Total Memory bucket
TOTALVIRTUALMEMORY float 8  √  null Total Virtual memory
TOTALVISIBLEMEMORY float 8  √  null Total Visible Virtual memory
UPTIME float 8  √  null Total uptime
LASTLOGON nvarchar 512  √  null Last logon information (e.g., januta01, mowdam01a)
LOCALFILESYSTEMSPACETOTAL float 8  √  null Total Local file system space
LOCALFILESYSTEMSPACEUSED float 8  √  null Used Local file system space
LOCALFILESYSTEMSPACEPCT float 8  √  null Percentage Local file system space
LOCALFILESYSTEMSPACEAVAILABLE float 8  √  null Available Local file system space
SERIALNUMBER nvarchar 512  √  null Serial number
SCANDATE datetime 16,3  √  null Last Scan Date
OSCOMPUTERDOMAIN nvarchar 512  √  null Computer Domain
USER_DOMAIN nvarchar 2048  √  null User Domain
LEVEL2 char 1  √  null Level 2
DATASRC nvarchar 50  √  null Data Source for this row (e.g., SCCM, ADDM)
ACTIVE nvarchar 2048  √  null Is this system active?
CPU_RID float 8  √  null CPU table unique identifier
OPERATINGSYSTEM_INSTALLDATE datetime 16,3  √  null Operating system install date
IS_UNIQUE numeric 20  √  null This record is UNIQUE and not deduped with other data source
DEDUPED_HOST_ID numeric 20  √  null If this record is not unique, the host_id for which it is deduped
DEDUPED_TASK_ID numeric 20  √  null If this record is not unique, the task_id from which it is deduped
DISC_ALL_OS_RN numeric 20  √  null Internal column

Analyzed at Thu Jul 20 12:14 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
HOST_ID Performance Asc DISC_ALL_OS_HOSTID
TASK_ID + OPERATINGSYSTEM_ID Performance Asc/Asc DISC_OS_TEMP
OPERATINGSYSTEM_ID + INVENTORY_ID + HARDWARE + HOST_ID + LOCALFILESYSTEMSPACETOTAL + LOCALFILESYSTEMSPACEUSED + TOTALMEMORY Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc REP_IDX__dta_index_DISC_ALL_OS_8_469576711__K1_K2_K15_K4_K25_K26_K19
INVENTORY_ID Performance Asc REP_IDX__dta_index_DISC_ALL_OS_8_469576711__K2_6
INVENTORY_ID + TOTALMEMORY + HOST_ID + LOCALFILESYSTEMSPACETOTAL + LOCALFILESYSTEMSPACEUSED Performance Asc/Asc/Asc/Asc/Asc REP_IDX__dta_index_DISC_ALL_OS_8_469576711__K2_K19_K4_K25_K26
INVENTORY_ID + OPERATINGSYSTEM_ID + HOST_ID Performance Asc/Asc/Asc REP_IDX__dta_index_DISC_ALL_OS_8_469576711__K2_K1_K4
INVENTORY_ID + OPERATINGSYSTEM_ID + HOST_ID + TOTALMEMORY + LOCALFILESYSTEMSPACETOTAL + LOCALFILESYSTEMSPACEUSED Performance Asc/Asc/Asc/Asc/Asc/Asc REP_IDX__dta_index_DISC_ALL_OS_8_469576711__K2_K1_K4_K19_K25_K26
INVENTORY_ID + LOCALFILESYSTEMSPACETOTAL + HOST_ID + LOCALFILESYSTEMSPACEUSED + TOTALMEMORY Performance Asc/Asc/Asc/Asc/Asc REP_IDX__dta_index_DISC_ALL_OS_8_469576711__K2_K25_K4_K26_K19_1_3
Confidential and Proprietary to BDNA