Know the deployed package History from SSISDB

Use the below sql script we can find the package and version details which is deployed in the SSIS server. I means we will get the history of the deploy package.

SELECT fld.Name as FolderName ,fld.created_By_Name as folderCreatdBy ,fld.Created_time as folderCreateddate ,proj.name projectName ,proj.created_time ,proj.last_deployed_time ,proj.deployed_by_name ,proj.folder_id ,pkg.[project_version_lsn] ,pkg.[name] as Pakagename ,pkg.[description] ,pkg.[package_format_version] ,pkg.[version_major] ,pkg.[version_minor] ,pkg.[version_build] ,pkg.[version_comments] FROM [SSISDB].[internal].folders fld INNER join [SSISDB].[internal].[projects] proj on proj.folder_id=fld.folder_id INNER join [SSISDB].[internal].[packages] pkg on pkg.project_id=pkg.project_id

See the Output