Find SCF Properties for SCCM DP using SQL Query

Prajwal Desai
Posted by Prajwal Desai
Find SCF Properties for SCCM DP using SQL Query

In this article, I will show you how to use a SQL query to find SCF properties for SCCM DP. The site control file (SCF) in Configuration Manager is an ASCII text file (Sitectrl.ct0) that contains the configuration of each site.

Site control in Configuration Manager defines the settings for a specific site. When working with scripting languages, Windows Management Instrumentation (WMI) is used to access the settings for each site. When using managed languages, the managed SMS Provider library is used to access the settings for each site.

The site control file in ConfigMgr is a collection of resource definitions that contain embedded properties, embedded property lists and multi-string lists. There are two ways to access the site control file in SCCM: Using WMI and Managed Provider.

Before you read further, here are some useful SQL queries that you can run in SCCM:

Ad imageAd image

Find SCF Properties for SCCM DP using SQL Query

Follow the below steps to run the SQL query to find SCF properties for SCCM DP:

  • Launch the SQL Server Management studio (SSMS) and connect to database engine.
  • Expand Databases and right-click SCCM database and select New Query.
Find SCF Properties for SCCM DP using SQL Query
Find SCF Properties for SCCM DP using SQL Query
  • In the query window, paste and execute the below SQL query to find SCF Properties for SCCM DP.

Note: You must replace the value for SRU.ServerName with your distribution point FQDN before you run the query.

SELECT SRU.RoleName, SRU.ServerName, SRUP.* FROM vSMS_SC_SysResUse SRU
JOIN vSMS_SC_SysResUse_Properties SRUP ON SRU.ID = SRUP.ID
WHERE SRU.RoleName = 'SMS Distribution Point'
AND SRU.ServerName = 'SCCM DP FQDN'
Find SCF Properties for SCCM DP using SQL Query
Find SCF Properties for SCCM DP using SQL Query

The SQL query output shows the list of SCF properties for the distribution point server. You can export the results from the SQL query to a .csv file.

Find SCF Properties for SCCM DP using SQL Query
Find SCF Properties for SCCM DP using SQL Query

Running the above SQL query will list the following SFC details about your Configuration Manager distribution point server.

Site Info
BITS download
SslState
InstallInternetServer
IsPeerDP
AllowInternetClients
IsAnonymousEnabled
DPDrive
MinFreeSpace
PreStagingAllowed
IsMulticast
IsPXE
SccmPXE
DPUsageEnabled
IdentityGUID
CertificateContextData
CertificatePFXData
CertificateExpirationDate
Server Remote Name
Server Remote Public Name
ADSiteName
IPSubnets
IPv6Prefixes
TokenAuthEnabled
DoincEnabled
RemoveWDS
IsActive
BindPolicy
SupportUnknownMachines
UdaSetting
ResponseDelay
PXEPassword
CertificateType
CertificateFile
DPShareDrive
TransferRate
Priority
Description
UpdateBranchCacheKey
EnableLEDBAT
LocalDriveDOINC
DiskSpaceDOINC
RetainDOINCCache
AgreeDOINCLicense
DPMonEnabled
DPMonSchedule
DPMonPriority
AvailableContentLibDrivesList
AvailablePkgShareDrivesList
Version
Flags

Find SCF Properties for DistMgr for Current Site

In addition to the above query, you can run the below SQL query to find SCF properties for DistMgr for current SCCM site.

SELECT SD.SiteCode, SC.ComponentName, SCP.Name, SCP.Value1, SCP.Value2, SCP.Value3
FROM SC_Component SC
JOIN SC_SiteDefinition SD ON SD.SiteNumber = SC.SiteNumber
JOIN SC_Component_Property SCP ON SCP.ComponentID = SC.ID
WHERE SD.SiteCode = dbo.fnGetSiteCode() AND SC.ComponentName = 'SMS_DISTRIBUTION_MANAGER'
Find SCF Properties for DistMgr for Current Site
Find SCF Properties for DistMgr for Current Site
Share This Article
Prajwal Desai
Posted by Prajwal Desai
Follow:
Prajwal Desai is a Microsoft MVP in Intune and SCCM. He writes articles on SCCM, Intune, Windows 365, Windows Server, Windows 11, WordPress and other topics, with the goal of providing people with useful information.
Leave a comment