How to query SSIS jobs information from SQL Server

Query to find the SSIS jobs data in MS SQL Server.

WITH ChildFolders
     AS
     (
         SELECT PARENT.parentfolderid,
                PARENT.folderid,
                PARENT.foldername,
                CAST('' AS SYSNAME)  AS RootFolder,
                CAST(PARENT.foldername AS VARCHAR(MAX)) AS FullPath,
                0                    AS Lvl
         FROM   msdb.dbo.sysssispackagefolders PARENT
         WHERE  PARENT.parentfolderid IS NULL
         UNION ALL
         SELECT CHILD.parentfolderid,
                CHILD.folderid,
                CHILD.foldername,
                CASE ChildFolders.Lvl
                     WHEN 0 THEN CHILD.foldername
                     ELSE ChildFolders.RootFolder
                END                   AS RootFolder,
                CAST(
                    ChildFolders.FullPath + '/' + CHILD.foldername AS VARCHAR(MAX)
                )                     AS FullPath,
                ChildFolders.Lvl + 1  AS Lvl
         FROM   msdb.dbo.sysssispackagefolders CHILD
                INNER JOIN ChildFolders
                     ON  ChildFolders.folderid = CHILD.parentfolderid
     )
SELECT F.RootFolder,
       F.FullPath,
       P.name         AS PackageName,
       P.description  AS PackageDescription,
       P.vermajor AS MajorVersion,
       P.verminor AS MinorVersion,
       P.verbuild AS BuildNumber
FROM   ChildFolders F
       INNER JOIN msdb.dbo.sysssispackages P
            ON  P.folderid = F.folderid
WHERE  P.name IN (
            'HR_Job',
            'Accounting_data_upload',
            'data_for_webshop',
            'data_to_warehouse',
            'data_from_branches'
            )
ORDER BY
       F.FullPath ASC, P.name ASC;