BDNA Data Platform 5.4 July 2017 (SQL Server) MATCH_SW_ALL_INV_V
|
View Definition:
CREATE VIEW MATCH_SW_ALL_INV_V AS SELECT *
FROM (
SELECT DISTINCT CAT_SW_RELEASE_ID
,CAT_SW_EDITION_ID
,CAT_SW_VERSION_ID
,CAT_SW_VERSION_GROUP_ID
,CAT_SW_PRODUCT_ID
,CAT_TAXONOMY2012_ID
,CAT_TAXONOMY_CATEGORY1
,CAT_TAXONOMY_CATEGORY2
,CAT_MANUFACTURER
,CAT_VERSION_GROUP
,CAT_VERSION
,CAT_PATCHLEVEL
,CAT_EDITION
,CAT_LICENSABLE
,SUITE_ID
,CAT_SW_UUID
FROM MATCH_HOST_SW_PROD
WHERE INVENTORY_ID= INVENTORY_ID
AND NULLIF(MATCH_HOST_SW_PROD.SUITE_ID,-1) IS NULL) inv
Possibly Referenced Tables/Views: