Packages that may not be necessary on a server (if it’s got low disk space)

select * from v_DistributionPoint dp
left join v_TaskSequencePackageReferences ts on ts.RefPackageID = dp.PackageID
where dp.ServerNALPath like '%UNHAPPYSERVER.DOMAIN%'
and ts.PackageID is NULL
and dp.PackageID not in (
select PackageID from v_DriverPackage
union all
select PackageID from v_BootImagePackage
union all
select PkgID from vSoftwareUpdatesPackage
)
order by 1

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s