Asset Intelligence Tables and Properties

by
SAM Table Column 1 Column 2 Column 3 Column 4 Column 5 Column 6 Column 7 Column 8 Column 9 Column 10 Column 11 Column 12 Column 13 Column 14 Column 15 Column 16 Column 17 Column 18 Column 19 Column 20 Column 21 Column 22 Column 23 Column 24 Column 25 Column 26 Column 27 Column 28 Column 29 Column 30 Column 31 Column 32 Column 33 Column 34 Column 35 Column 36
v_LU_SoftwareList SoftwareID CommonName CommonVersion CommonPublisher CategoryID OfficialCategoryID FamilyID OfficialFamilyID Tag1ID Tag2ID Tag3ID ConflictStatus                                                
V_LU_Softwarehash SoftwarePropertiesHash Name Version Publisher SoftwareID LastUpdated                                                            
v_GS_INSTALLED_SOFTWARE_CATEGORIZED ResourceID TimeStamp RevisionID AgentID SoftwareCode0 ProductCode0 CM_DSLID0 ProductName0 ARPDisplayName0 ProductVersion0 Publisher0 VersionMajor0 VersionMinor0 ServicePack0 Language0 ProductID0 InstalledLocation0 InstallSource0 UninstallString0 LocalPackage0 UpgradeCode0 InstallDate0 RegisteredUser0 SoftwarePropertiesHash0 SoftwarePropertiesHashEx0 InstallDirectoryValidation0 EvidenceSource0 InstallType0 NormalizedName NormalizedPublisher NormalizedVersion FamilyName FamilyID CategoryName CategoryID SoftwareID
v_GS_INSTALLED_SOFTWARE_MS ResourceID GroupID RevisionID AgentID TimeStamp ChannelCode0 ChannelID0 MPC0 ProductCode0 SoftwareCode0                                                    
v_GS_SOFTWARE_LICENSING_PRODU ResourceID GroupID RevisionID AgentID TimeStamp ApplicationID0 Description0 EvaluationEndDate0 GracePeriodRemaining0 ID0 LicenseStatus0 MachineURL0 Name0 OfflineInstallationId0 PartialProductKey0 ProcessorURL0 ProductKeyID0 ProductKeyURL0 UseLicenseURL0                                  
v_GS_SOFTWARE_LICENSING_SERVI ResourceID GroupID RevisionID AgentID TimeStamp ClientMachineID0 IsKeyManagementServiceMachin0 KeyManagementServiceCurrentC0 KeyManagementServiceMachine0 KeyManagementServiceProductK0 PolicyCacheRefreshRequired0 RequiredClientCount0 Version0 VLActivationInterval0 VLRenewalInterval0                                          
v_GS_SOFTWARE_SHORTCUT ResourceID GroupID RevisionID AgentID TimeStamp BinFileVersion0 BinProductVersion0 Description0 FilePropertiesHash0 FilePropertiesHashEx0 FileSize0 FileVersion0 Language0 ParentName0 Product0 ProductCode0 ProductVersion0 Publisher0 ShortcutKey0 ShortcutName0 ShortcutType0 TargetExecutable0                            
v_GS_SoftwareFile ResourceID FileID ProductId FileName FileDescription FileVersion FileSize FileCount ModifiedDate CreationDate FilePath FileModifiedDate                                                
v_GS_SoftwareProduct ResourceID ProductID CompanyName ProductName ProductVersion ProductLanguage                                                            
v_GS_SoftwareUsageData No Data                                                                      
v_INSTALLED_SOFTWARE_DATA_Summary Count SoftwareCode00 SoftwarePropertiesHash00 ProductName00 Publisher00 ProductVersion00                                                            
v_LU_CAL_ProductList SoftwareCode SoftwareHash ProductCategory LicenseType LastUpdated IsDeleted                                                            
v_LU_MSProd MPC PartNumber MLSFamilyName MLSProductName VersionCode VersionSequence LanguageName ProductDistTypeName LicenseTypeName IsDeleted LastUpdated                                                  
v_LU_SoftwareCode SoftwareCode SoftwareID LastUpdated                                                                  
v_LU_SoftwareIdentity_Local_Repl NO data                                                                      
v_LU_SoftwareIdentity_Repl ID SoftwareID CommonName CommonVersion CommonPublisher CategoryID FamilyID Tag1ID Tag2ID Tag3ID SoftwareCode SoftwarePropertiesHash Name Version Publisher SourceSite LastUpdated IsDeleted rowversion creationversion LocaleID                              
v_LU_SoftwareList_Editable SoftwareID SoftwareCode SoftwarePropertiesHash CommonName CommonPublisher CommonVersion CategoryID CategoryName FamilyID FamilyName OfficialCategoryID OfficialCategoryName OfficialFamilyID OfficialFamilyName Tag1ID Tag1Name Tag2ID Tag2Name Tag3ID Tag3Name State IsDeleted                            
v_LU_SoftwareList_Local No Data                                                                      
v_LU_SoftwareSignature_Repl ID SoftwareID CommonName CommonVersion CommonPublisher CategoryID FamilyID Tag1ID Tag2ID Tag3ID SoftwareCode SoftwarePropertiesHash Name Version Publisher SourceSite LastUpdated IsDeleted rowversion creationversion LocaleID                              
v_ProductFileInfo FileID FileName FileDescription FileVersion FileSize CompanyName ProductName ProductVersion ProductLanguage                                                      
v_SoftwareFile FileID ProductID FileName FileVersion FileDescription FileSize                                                            
v_SoftwareProduct ProductID ProductName CompanyName ProductVersion ProductLanguage                                                              

Leave a Comment