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. |