2.13 NC_FileScanData Table

The NC_FileScanData table contains information about files not associated with recognized products.

Column

Key

Type

Null

Description

FileScanDataOID

PK

binary(16)

No

An internal ID number used as a primary key.

FileDate

 

datetime

 

The date the file was first discovered.

FileSize

numeric(19,2)

The size of the file.

FileName

nvarchar(64)

 

The file name.

SubDirectory

nvarchar(255)

 

The folder in which the file resides.

Extension

 

nvarchar(32)

 

The three-character file extension.

FileScanCategory

 

smallint

 

0=None, 1=System, 2=Ancillary, 3=Other

VICompanyName

 

nvarchar(64)

 

Version resource block company name.

VIProductName

 

nvarchar(80)

 

Version resource block product name.

VIProductVersion

 

nvarchar(32)

 

Version resource block product version.

VILanguage

 

nvarchar(16)

 

Version resource block language.

VIFileVersion

 

nvarchar(32)

 

Version resource block file version.

StartupCount

 

int

 

The number of times the application file has been launched.

TotalRuntimeSeconds

 

int

 

The total number of seconds the file has been open.

TotalActiveSeconds

 

int

 

The total number of seconds the file was active.

WorkstationOID

FK

binary(16)

 

The ID that connects to the workstation where this file was discovered.