Table BDNA_PUBLISH.dbo.DISC_ALL_OS
Has Discovered Operating Systems information

 Generated by
SchemaSpy
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 float 8
DISC_CDROMS.OPERATINGSYSTEM_ID FK0_DISC_CDROMS R
DISC_CPUS.OPERATINGSYSTEM_ID FK0_DISC_CPUS R
DISC_DISK_PARTITIONS.OPERATINGSYSTEM_ID FK0_DISC_DISK_PARTITIONS R
DISC_HDDS.OPERATINGSYSTEM_ID FK0_DISC_HDDS R
DISC_LOGICAL_DISKS.OPERATINGSYSTEM_ID FK0_DISC_LOGICAL_DISKS R
DISC_VIDEO_CONTROLLERS.OPERATINGSYSTEM_ID FK0_DISC_VIDEO_CONTROLLERSS R
DISC_WINDOWS_MONITORS.OPERATINGSYSTEM_ID FK0_DISC_WINDOWS_MONITORS R
DISC_WINDOWS_NICS.OPERATINGSYSTEM_ID FK0_DISC_WINDOWS_NICS R
DISC_WINDOWS_SERVICES.OPERATINGSYSTEM_ID FK0_DISC_WINDOWS_SERVICES R
Unique Operating System id
INVENTORY_ID float 8
DISC_CDROMS.INVENTORY_ID FK0_DISC_CDROMS R
DISC_CPUS.INVENTORY_ID FK0_DISC_CPUS R
DISC_DISK_PARTITIONS.INVENTORY_ID FK0_DISC_DISK_PARTITIONS R
DISC_HDDS.INVENTORY_ID FK0_DISC_HDDS R
DISC_LOGICAL_DISKS.INVENTORY_ID FK0_DISC_LOGICAL_DISKS R
DISC_VIDEO_CONTROLLERS.INVENTORY_ID FK0_DISC_VIDEO_CONTROLLERSS R
DISC_WINDOWS_MONITORS.INVENTORY_ID FK0_DISC_WINDOWS_MONITORS R
DISC_WINDOWS_NICS.INVENTORY_ID FK0_DISC_WINDOWS_NICS R
DISC_WINDOWS_SERVICES.INVENTORY_ID FK0_DISC_WINDOWS_SERVICES R
DISC_HOSTS.INVENTORY_ID FK2_DISC_ALL_OS R
MATCH_INVENTORY.INVENTORY_ID FK1_DISC_ALL_OS R
Inventory Id for this row
TASK_ID float 8
DISC_CDROMS.TASK_ID FK0_DISC_CDROMS R
DISC_CPUS.TASK_ID FK0_DISC_CPUS R
DISC_DISK_PARTITIONS.TASK_ID FK0_DISC_DISK_PARTITIONS R
DISC_HDDS.TASK_ID FK0_DISC_HDDS R
DISC_LOGICAL_DISKS.TASK_ID FK0_DISC_LOGICAL_DISKS R
DISC_VIDEO_CONTROLLERS.TASK_ID FK0_DISC_VIDEO_CONTROLLERSS R
DISC_WINDOWS_MONITORS.TASK_ID FK0_DISC_WINDOWS_MONITORS R
DISC_WINDOWS_NICS.TASK_ID FK0_DISC_WINDOWS_NICS R
DISC_WINDOWS_SERVICES.TASK_ID FK0_DISC_WINDOWS_SERVICES R
DISC_HOSTS.TASK_ID FK2_DISC_ALL_OS R
MATCH_TASK_DET.TASK_ID FK0_DISC_ALL_OS R
Task Id for this row
HOST_ID float 8  √  null
DISC_HOSTS.HOST_ID FK2_DISC_ALL_OS R
Unique host Id
OPERATINGSYSTEM_LABEL nvarchar 512  √  null Operating System label
HOSTNAME nvarchar 2048  √  null Host Name
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(eg: Vista, XP etc)
OS_FAMILY nvarchar 512  √  null Operating System Family eg: Windows, Linux
EDITION nvarchar 512  √  null Operating System Edition eg: Professional,Standard (32-bit x86)
VERSION nvarchar 512  √  null Operating System version eg: 5.1.2600, 5.2.3790
PATCHLEVEL nvarchar 512  √  null Patch Level eg: Service Pack 2
OSBUILDNUMBER nvarchar 512  √  null Operating System build number
HARDWARE nvarchar 512  √  null Hardware information eg: Dell Inc. Latitude D620, Compaq ProLiant DL580 G2
NUMCPUS float 8  √  null Number of CPUS
CPU_SPEED float 8  √  null CPU Speed
OSBITMODE float 8  √  null Operating System bit mode eg: 32bit, 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 eg: 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
LEVEL2 char 1  √  null Level2
DATASRC nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM
ACTIVE nvarchar 2048  √  null Is this system active?
OPERATINGSYSTEM_INSTALLDATE datetime 16,3  √  null

Analyzed at Thu Oct 04 14:29 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
OPERATINGSYSTEM_ID + TASK_ID + INVENTORY_ID Primary key Asc/Asc/Asc PK_DISC_ALL_OS
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

Close relationships  within of separation: