Tsql script to know Maintenance Plans Owner

Tsql script to know Maintenance Plans Owner

--http://jasonbrimhall.info/2012/06/25/maintenance-plan-owner/

USE msdb;--sql server 2005
GO
SELECT p.name AS PackageName,
p.createdate,
pf.foldername AS PackageType,
sp.name AS PrincipalName
    FROM msdb.dbo.sysdtspackages90  p
    INNER JOIN dbo.sysdtspackagefolders90 pf
        ON p.folderid = pf.folderid
    INNER JOIN master.sys.server_principals sp
        ON p.ownersid = sp.sid
WHERE pf.foldername = 'Maintenance Plans';

**************************************************************************

--Tsql script to know Maintenance Plans Owner
USE msdb; --sql server 2008
GO
SELECT p.name AS PackageName,
p.createdate,
pf.foldername AS PackageType,
sp.name AS PrincipalName
    FROM msdb.dbo.sysssispackages  p
    INNER JOIN dbo.sysssispackagefolders pf
        ON p.folderid = pf.folderid
    INNER JOIN master.sys.server_principals sp
        ON p.ownersid = sp.sid
WHERE pf.foldername = 'Maintenance Plans';