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:
- Find SCCM Database Size using SQL Query
- SCCM SQL Query to Find Last Restart Time of Devices
- SCCM SQL Query: Find Last Heartbeat Time Stamp of Clients
- Find SCCM Application Deployment Details using SQL Query
- SCCM Packages using SQL Query | PowerShell
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.
- 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'
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.
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'
