SQL Report to list Boundary Group with Site System Details

select sys1.Name, sys1.DefaultSiteCode, (select SUBSTRING(sys2.ServerNALPath, CHARINDEX('\\', sys2.ServerNALPath) + 2, CHARINDEX('"]', sys2.ServerNALPath) - CHARINDEX('\\', sys2.ServerNALPath) - 3 ) + CASE sys2.Flags WHEN '1' Then ' (Slow)' WHEN '0' THEN '' END + '; ' as 'data()' from vSMS_BoundaryGroupSiteSystems as sys2 where sys1.GroupID=sys2.GroupID for XML path('')) as 'Site System', (select sys4.Value + '; ' as 'data()' from... Continue Reading →

Advertisements

SCCM 2012 REINSTALLING A MANAGEMENT POINT ON A SECONDARY SITE

Received the following error in MP Control.log Error :Http test request failed, status code is 500, 'Internal Server Error' Nothing seemed to resolve the issues. Then wanted to re-install the management point but you can’t remove the role. Found an easy way to re-install the management Point. Go to Administration – Server and Site System... Continue Reading →

Create a free website or blog at WordPress.com.

Up ↑