SoftwareFileUsage Table
This table contains information about each file relevant to reporting software usage information on each computer.
TenantID
has been set in the SQL Server
connection context information. That setting filters an underlying table to produce this
view of data for the single, selected tenant.
Database Column |
Details |
---|---|
SoftwareFileUsageID
|
Type: integer. Key. Generated ID Auto-generated identity number |
ComputerID
|
Type: integer. Key The id of the computer this information applies to. This id is a foreign
key to the |
UserID
|
Type: integer. Key The id of the user context in which the application was detected.
This is a foreign key to the |
Version
|
Type: text (max 32 characters). Key The version of the software file defined by the vendor. |
SoftwareFileNameID
|
Type: integer. Key The name of the file that was tracked, minus the path.
This is a foreign key into the |
LongName
|
Type: text (max 4000 characters). Nullable The full path and file that was tracked. |
CompanyName
|
Type: text (max 50 characters). Key The company name of the software. |
Description
|
Type: text (max 1024 characters). Key The file description of the software. |
ProductName
|
Type: text (max 50 characters). Key The product name of the software file. |
ProductVersion
|
Type: text (max 32 characters). Key The version of the product of the software file defined by the vendor. |