I was building a query that showed all site systems with their roles for one of our sites (SCCM 2007 SP2 R2, one site server, 8 BDP's) and came up with no entries for the site server, when I looked in v_RA_System_SystemRoles, there's only ResourceID's for two of the BDP's in the View, nothing else. Site seems to work fine, clients seem fine, no obsolete or unapproved clients. What do I need to do to fix this? Thanks.

Are you looking for something liek this? http://anoopmannur.wordpress.com/2011/08/19/configmgr-sccm-very-useful-report-of-servers-with-site-system-roles-details/Anoop C Nair - Twitter @anoopmannur MY BLOG: http://anoopmannur.wordpress.com SCCM Professionals This posting is provided AS-IS with no warranties/guarantees and confers no rights.

No, the problem is, the site server ResourceID is not IN the View, ANY report won't show that server. But, this IS a neat report, thanks.

Hi Bill, I checked it in my environment, BDP role is displayed in v_RA_System_SystemRoles view. I think you can check your BDP status, is the BDP client still active and is BDP working for software distribution? Or try to delete and recreate the BDP. Hope this will help. Thanks

Any errors in compmon.log or ntsvrdis.log?Torsten Meringer | http://www.mssccmfaq.de