Distribution Point

Queries to pull SCCM Package status information on Distribution point

Queries to pull SCCM Package status information on Distribution point 1) Below query will provide the install status (failed,pending,complete) of package and respective count select COUNT(*),InstallStatus from v_PackageStatusDistPointsSumm where PackageID like ‘<PackageID>‘ group by InstallStatus 2) Below query will provide the list of DP’s where package status is completed   select * from v_PackageStatusDistPointsSumm where [...]

Config Manager Registries

Below registry key may help while pulling a data through script from registry Where do you will find the SCCM provider location in registry? (X64 bit) HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicrosoftSMSSetup | Provider Location Where is the path for SQL Log file (LDF) and data file (MDF) location in registry? MDF file:- HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicrosoftSMSSQL Server | Device Path LDF file:- [...]

SCCM package replication facts :- What will happen if you change the “Retry Count” for software distribution Component?

These days I’m working on package replication, One of our SCCM Primary site has 55+  PDP’s. This time, because of some reasons 2 of them went down.Actually both are new protected distribution point. “Number of retry settings was set to ‘100’ and distribution manager was only  retrying package replication only on 2 problem PDp’s.  As [...]