Replace :
- NameBDDEPM => your Database Name
- NamePath => Specific path
An execute this SQL script in SSMS
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | SELECT MIN(pfh.FULL_PATH) as FULL_PATH, p.NAMEFROM [NameBDDEPM].[dbo].[PACKAGE_FILES_HASH] pfhJOIN [NameBDDEPM].[dbo].[PACKAGE_FILES] pfON pfh.PACKAGE_FILES_HASH_IDN = pf.PACKAGE_FILES_HASH_IDNJOIN [NameBDDEPM].[dbo].[PACKAGE] pON pf.PACKAGE_IDN = p.PACKAGE_IDNWHERE LOWER(pfh.FULL_PATH) LIKE '%NamePath%'GROUP BY p.NAME |
Warning : Works only with packages having additional files
0 Comments