BDNA Data Platform 5.4 July 2017 (SQL Server)
DISC_VIDEO_CONTROLLERS - Video Controllers 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
VIDEOCONTROLLER_ID numeric 20 Video controller ID
NAME nvarchar 1024  √  null Video controller name
ADAPTERCOMPATIBILITY nvarchar 512  √  null Adapter compatibility (e.g., Microsoft, NVIDIA, ATI Technologies Inc.)
ADAPTERDACTYPE nvarchar 512  √  null Adapter DAC Type (e.g., Integrated RAMDAC, Internal DAC-400 MHz)
ADAPTERRAM float 8  √  null Adapter RAM
CURRENTREFRESHRATE float 8  √  null Video controller current refresh rate
CURRENTVERTICALRESOLUTION float 8  √  null Video controller current vertical resolution
DESCRIPTION nvarchar 2048  √  null Video controller description
DEVICEID nvarchar 2048  √  null Video controller device ID
DRIVERDATE datetime 16,3  √  null Video controller driver date
DRIVERVERSION nvarchar 512  √  null Video controller driver version
INSTALLEDDISPLAYDRIVERS nvarchar 2048  √  null Video controller installed display dirvers (e.g., nv4_disp.dll, igdumdx32.dll, igd10umd32.dll, etc.)
VIDEOMODEDESCRIPTION nvarchar 1024  √  null Video controller video mode description (e.g., 1440 x 900 x 4294967296 colors, etc.)
VIDEOPROCESSOR nvarchar 1024  √  null Video controller video processor (e.g., GeForce Go 7300, MOBILITY RADEON X300-0x5460)
DATASRC nvarchar 50  √  null Data Source for this row (e.g., SCCM, ADDM)
OPERATINGSYSTEM_ID numeric 20  √  null Operating System ID for this video controller
TASK_ID numeric 20 Task ID for this row
INVENTORY_ID numeric 20 Inventory ID for this row

Analyzed at Thu Jul 20 12:14 PDT 2017

Confidential and Proprietary to BDNA