BDNA Data Platform 5.4 July 2017 (Oracle)
DISC_WINDOWS_SERVICES - Windows Services 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
SERVICE_ID float 126  √  null Unique service ID
INVENTORY_ID number 18  √  null
DISC_ALL_OS.INVENTORY_ID FK0_DISC_WINDOWS_SERVICES R
Inventory Id for this row
TASK_ID number 18  √  null
DISC_ALL_OS.TASK_ID FK0_DISC_WINDOWS_SERVICES R
Task ID for this row
SERVICE_NAME nvarchar2 256  √  null Windows service name (e.g., AppMgmt, CryptSvc)
DISPLAY_NAME nvarchar2 1024  √  null Windows service display name (e.g., Application Layer Gateway Service, ClipBook)
EXE_PATH nvarchar2 2000  √  null Windows service exe path (e.g., C:\WINDOWS\System32\alg.exe)
SERVICE_TYPE nvarchar2 256  √  null Windows service type (e.g., Own Process, Share Process)
STARTUP_TYPE nvarchar2 256  √  null Windows service startup type (e.g., Automatic, Manual, and Disabled)
STATUS nvarchar2 256  √  null Windows service staus
IS_DESKTOP_INTERACT nvarchar2 256  √  null Allow service to interact with desktop?
OPERATINGSYSTEM_ID number 0  √  null
DISC_ALL_OS.OPERATINGSYSTEM_ID FK0_DISC_WINDOWS_SERVICES R
Operating System ID
DATASRC nvarchar2 25  √  null Data Source for this row (e.g., SCCM, ADDM)

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
INVENTORY_ID + TASK_ID + SERVICE_ID Primary key Asc/Asc/Asc PK_DISC_WINDOWS_SERVICES These unique columns are also nullable

Close relationships  within of separation:
Confidential and Proprietary to BDNA