Contains information about the software inventory along with the software detection type.
|
Column Name |
Key |
Datatype |
Null |
Description |
|---|---|---|---|---|
|
ComponentOID |
PK,FK |
binary(16) |
NO |
Internal ID number used as primary key. |
|
msProductCode |
|
nvarchar(64) |
NO |
MsProductcode of the software |
|
isMSI |
|
tinyint |
NO |
Flag indication if this software is recognized from the msi |
|
isARP |
|
tinyint |
NO |
Flag indication if this software is recognized from the Add Remove program panel |
|
arpProductCode |
|
numeric(19,0) |
Internal product code specific to a software |
|
|
isOverallReconciled |
|
tinyint |
NO |
Flag indicating if this software is reconciled with finger print software |
|
isComponent |
|
tinyint |
NO |
Flag to indicate if its a component of the product suite |
|
isVirtual |
|
tinyint |
NO |
Flag to indicate if its a virtual application |
|
platformSWName |
|
nvarchar(64) |
|
Software name got from ARP or MSI |
|
platformSWVersion |
|
nvarchar(25) |
|
Software version got from the ARP or MSI |
|
platformSWMfgr |
|
nvarchar(35) |
|
Software manufacturer got from the ARP or MSI |
|
uninstallString |
|
nvarchar(255) |
|
Uninstall string for the software |