Try this ? select PSD.PackageID,p.Name,psd.SiteCode,s.ServerName,(p.sourcesize)/1024 as 'Size in MB', PSD.SourceVersion,PSD.SummaryDatefrom dbo.v_PackageStatusDetailSumm PSD,v_Site S,smspackages pWhere PSD.Targeted=0 and PSD.SiteCode=s.SiteCode and p.PkgID=PSD.PackageID and p.Name not like '%xxxx%' order by PackageID
Eswar Koneti www.eskonr.com From: [email protected] To: [email protected] Date: Wed, 25 Sep 2013 11:58:51 -0400 Subject: [mssms] Package Report HelloI’m looking for a report of all packages NOT assigned to a DP �C Does anyone have a similar report? Thanks
