Advertisements
Latest Posts

SQL query to find Orphaned Distribution Point References

helpful tips crossword puzzle

Below query can be used to identify if there are any orphaned rows left in the database for a DP that is no longer in the environment. There could be orphaned rows if the DP was not removed properly.

 

DECLARE @DPName NVARCHAR(100)

SET @DPName = ‘RemoteDP.KARTHI.COM’

SELECT * FROM ContentDPMap WHERE ServerName = @DPName

SELECT * FROM DistributionPoints WHERE ServerName = @DPName

SELECT * FROM DPInfo WHERE ServerName = @DPName

SELECT * FROM PkgServers_G WHERE NALPath like ‘%’ + @DPName + ‘%’

SELECT * FROM PkgServers_L WHERE NALPath like ‘%’ + @DPName + ‘%’

SELECT * FROM PkgStatus_G WHERE PkgServer like ‘%’ + @DPName + ‘%’

SELECT * FROM PkgStatus_L WHERE PkgServer like ‘%’ + @DPName + ‘%’

SELECT * FROM SysResList WHERE RoleName = ‘SMS Distribution Point’ AND ServerName = @DPName

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