BDNA Data Platform 5.4 July 2017 (SQL Server) MATCH_SW_RECENTLY_USED_APPS - Recently used apps information matched
|
View Definition:
CREATE VIEW MATCH_SW_RECENTLY_USED_APPS AS SELECT ID,INVENTORY_ID,TASK_ID,CAT_SW_UUID,HOST_ID,HOSTNAME,MANUFACTURER,SOFTWARE,FAMILY,COMPONENT,PATCHLEVEL,VERSION,
VERSION_GROUP,EDITION,FOLDERPATH,LAUNCHCOUNT,LASTUSERDOMAIN,LASTUSERLOGON,LASTUSERNAME,LASTUSEDDATE,CAT_MANUFACTURER_ID,
CAT_SW_PRODUCT_ID,CAT_SW_VERSION_GROUP_ID,CAT_SW_VERSION_ID,CAT_SW_EDITION_ID,CAT_SW_RELEASE_ID,CAT_TAXONOMY2012_ID,DATASRC FROM MATCH_SW_RECENTLY_USED_APPS_237467998 UNION ALL SELECT ID,INVENTORY_ID,TASK_ID,CAT_SW_UUID,HOST_ID,HOSTNAME,MANUFACTURER,SOFTWARE,FAMILY,COMPONENT,PATCHLEVEL,VERSION,
VERSION_GROUP,EDITION,FOLDERPATH,LAUNCHCOUNT,LASTUSERDOMAIN,LASTUSERLOGON,LASTUSERNAME,LASTUSEDDATE,CAT_MANUFACTURER_ID,
CAT_SW_PRODUCT_ID,CAT_SW_VERSION_GROUP_ID,CAT_SW_VERSION_ID,CAT_SW_EDITION_ID,CAT_SW_RELEASE_ID,CAT_TAXONOMY2012_ID,DATASRC FROM MATCH_SW_RECENTLY_USED_APPS_237470163 UNION ALL SELECT ID,INVENTORY_ID,TASK_ID,CAT_SW_UUID,HOST_ID,HOSTNAME,MANUFACTURER,SOFTWARE,FAMILY,COMPONENT,PATCHLEVEL,VERSION,
VERSION_GROUP,EDITION,FOLDERPATH,LAUNCHCOUNT,LASTUSERDOMAIN,LASTUSERLOGON,LASTUSERNAME,LASTUSEDDATE,CAT_MANUFACTURER_ID,
CAT_SW_PRODUCT_ID,CAT_SW_VERSION_GROUP_ID,CAT_SW_VERSION_ID,CAT_SW_EDITION_ID,CAT_SW_RELEASE_ID,CAT_TAXONOMY2012_ID,DATASRC FROM MATCH_SW_RECENTLY_USED_APPS_9999
Possibly Referenced Tables/Views: