SCRIPT: How to check SSRS and SSIS usage?

• SSIS:

--SQL jobs which executes SSIS packages

SELECT
    j.name,
    js.last_run_date,
       js.last_run_time, js.command
FROM msdb.dbo.sysjobsteps js
INNER JOIN msdb.dbo.sysjobs j
ON js.job_id = j.job_id
WHERE subsystem = 'SSIS' AND j.category_id <> 3
ORDER BY js.last_run_date DESC, js.last_run_time DESC
 
-- All SSRS packages
SELECT PCK.name AS PackageName
      ,PCK.[description] AS [Description]
      ,FLD.foldername AS FolderName
      ,CASE PCK.paackagetype
            WHEN 0 THEN 'Default client'
            WHEN 1 THEN 'I/O Wizard'
            WHEN 2 THEN 'DTS Designer'
            WHEN 3 THEN 'Replication'
            WHEN 5 THEN 'SSIS Designer'
            WHEN 6 THEN 'Maintenance Plan'
            ELSE 'Unknown' END AS PackageTye
      ,LG.name AS OwnerName
      ,PCK.isencrypted AS IsEncrypted
      ,PCK.createdate AS CreateDate
      ,CONVERT(varchar(10), vermajor)
       + '.' + CONVERT(varchar(10), verminor)
       + '.' + CONVERT(varchar(10), verbuild) AS Version
      ,PCK.vercomments AS VersionComment
      ,DATALENGTH(PCK.packagedata) AS PackageSize
FROM msdb.dbo.sysssispackages AS PCK
     LEFT JOIN msdb.dbo.sysssispackagefolders AS FLD
         ON PCK.folderid = FLD.folderid
     LEFT JOIN sys.syslogins AS LG
         ON PCK.ownersid = LG.sid
WHERE PCK.packagetype <> 6
ORDER BY PCK.name;

• SSRS:

-- Reports with last run date
SELECT
    c.Name, c.[Path], MAX(e.TimeStart) as LastRun
 FROM ReportServer.dbo.Catalog c
    join ReportServer.dbo.ExecutionLog e on c.ItemID = e.ReportID
GROUP BY c.name, c.[Path]
 
-- All reports
SELECT c.Name, c.[Path],
CASE [Type] --Type, an int which can be converted using this case statement.
    WHEN 1 THEN 'Folder'
    WHEN 2 THEN 'Report'
    WHEN 3 THEN 'File'
    WHEN 4 THEN 'Linked Report'
    WHEN 5 THEN 'Data Source'
    WHEN 6 THEN 'Report Model - Rare'
    WHEN 7 THEN 'Report Part - Rare'
    WHEN 8 THEN 'Shared Data Set - Rare'
    WHEN 9 THEN 'Image'
    ELSE CAST(Type as varchar(100))
  END AS TypeName
FROM ReportServer.dbo.Catalog c
WHERE Type = 2