Table BDNA_PUBLISH.dbo.DISC_WINDOWS_SERVICES
Has Discovered Windows Services 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
SERVICE_ID float 8 Unique service Id
INVENTORY_ID float 8
DISC_ALL_OS.INVENTORY_ID FK0_DISC_WINDOWS_SERVICES R
Inventory Id for this row
TASK_ID float 8
DISC_ALL_OS.TASK_ID FK0_DISC_WINDOWS_SERVICES R
Task Id for this row
SERVICE_NAME nvarchar 512  √  null Windows service name eg:AppMgmt ,CryptSvc
DISPLAY_NAME nvarchar 2048  √  null Windows service display name eg: Application Layer Gateway Service, ClipBook
EXE_PATH nvarchar 8000  √  null Windows service exe path eg: C:\WINDOWS\System32\alg.exe
SERVICE_TYPE nvarchar 512  √  null Windows service type eg: Own Process,Share Process
STARTUP_TYPE nvarchar 512  √  null Windows service startup type eg: Automatic, Manual and Disabled
STATUS nvarchar 512  √  null Windows service staus
IS_DESKTOP_INTERACT nvarchar 512  √  null Allow service to interact with desktop?
OPERATINGSYSTEM_ID float 8  √  null
DISC_ALL_OS.OPERATINGSYSTEM_ID FK0_DISC_WINDOWS_SERVICES R
Operating System Id
DATASRC nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM

Analyzed at Thu Oct 04 14:29 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
SERVICE_ID + TASK_ID + INVENTORY_ID Primary key Asc/Asc/Asc PK_DISC_WINDOWS_SERVICES

Close relationships  within of separation: