SCCM Server-Side Logging How to Turn On Verbose SQL NAL logging

Let’s understand SCCM Server-Side Logging How to Turn On Verbose SQL NAL logging. One old topic and old post. There is a great post from Ismail-TS on “logging” (offline now). I think, there are a lot of topics covered in all the parts related to ConfigMgr logging.

Some of them are still relevant for Configuration Manager CB. I have not checked and confirmed all the registry keys. Please carry out these changes in a staging environment.

In this post, we will see more details about “SCCM ConfigMgr How to Turn On Verbose SQL NAL logging.”

SCCM ConfigMgr How to Turn On Verbose SQL NAL logging

SCCM does not see much information here, you can check the logs for him having trouble Verbose / Debug, or NAL may need to turn on logging. This logging will give you much more detailed information, and it will help your find the source of the problem.

Patch My PC
SCCM ConfigMgr How to Turn On Verbose SQL NAL logging
SCCM Server-Side Logging How to Turn On Verbose SQL NAL logging

Server verbose logging:

1 – open means

0 – off means

SCCM and components:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Tracing\ENABLED = 1 – (REG_DWORD – General SCCM turn on Logging)

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Tracing\ xxxxxxx\ Enabled = 1 – (REG_DWORD – The Role SCCM’de If you change the compositions according to him)

Adaptiva

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Tracing\xxxxxxx\ MaxFileSize = 3000000 – (REG_DWORD – 3 MB large – NAL and Debug Logging for growth with more than it is worth)

Enable Verbose Logging for SCCM Server Components

Follow the method mentioned below to Enable Verbose Logging for SCCM Server Components. You will need to enable the logging level to verbose by changing the value to 0.

LoggingLevel = 0

Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Tracing\SMS_WINNT_SERVER_DISCOVERY_AGENT

SCCM Server-Side Logging How to Turn On Verbose SQL NAL logging
SCCM Server-Side Logging How to Turn On Verbose SQL NAL logging

And make sure you reset the refresh time of that component from the following registry key

Reset Refresh time of the component – Last Refresh Time = 0

Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\COMPONENTS\SMS_WINNT_SERVER_DISCOVERY_AGENT

SCCM Server-Side Logging How to Turn On Verbose SQL NAL logging 1
SCCM Server-Side Logging How to Turn On Verbose SQL NAL logging 4

You can go to Service manager and restart that component Where Is Tools ConfigMgr Service Manager Option In SCCM Console (anoopcnair.com)

SCCM Server-Side Logging How to Turn On Verbose SQL NAL logging
SCCM Server-Side Logging How to Turn On Verbose SQL NAL logging

Important components to be linked to SQL for SQL logging, open the key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Tracing\Sqlenabled = 1 – (REG_DWORD)

Component of SQL and SCCM logs, including:

ciamgr.log – SMS_CI_ASSIGNMENT_MANAGER

Colleval.log – SMS_COLLECTION_EVALUATOR

compsumm.log – SMS_COMPONENT_STATUS_SUMMARIZER

Dataldr.log – SMS_INVENTORY_DATA_LOADER

ddm.log – SMS_DISCOVERY_DATA_MANAGER

Distmgr.log – SMS_DISTRIBUTION_MANAGER

Hman.log – SMS_HIERARCHY_MANAGER

objreplmgr.log – SMS_OBJECT_REPLICATION_MANAGER

offermgr.log – SMS_OFFER_MANAGER

Offersum.log – SMS_OFFER_STATUS_SUMMARIZER

policypv.log – SMS_POLICY_PROVIDER

sinvproc.log – SMS_SOFTWARE_INVENTORY_PROCESSOR

Sitestat.log – SMS_SITE_SYSTEM_STATUS_SUMMARIZER

smsdbmon.log – SMS_DATABASE_NOTIFICATION_MONITOR

statesys.log – SMS_STATE_SYSTEM

Statmgr.log – SMS_STATUS_MANAGER

swmproc.log – SMS_SOFTWARE_METERING_PROCESSOR

wcm.log – SMS_WSUS_CONFIGURATION_MANAGER

wsyncmgr.log – SMS_WSUS_SYNC_MANAGER

SMS Provider

HKEY_LOCAL_MACHINE\Software\Microsoft\SMS\Providers\Logging Level = 1 – (REG_DWORD)

HKEY_LOCAL_MACHINE\Software\Microsoft\SMS\Providers\SQL Cache Logging Level = 1 – (REG_DWORD)

HKEY_LOCAL_MACHINE\Software\Microsoft\SMS\Providers\Log Size MB = 1 – (REG_DWORD)

SCCM log with logging provider are as follows:

Smsprov.log

NAL logging:

Sometimes it may be enough, and NAL logging verbose logging information in the pop-up. Caution: NAL logging Log file too big for him, keeping detailed logs have benefits.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NAL\Logging

– DataType: REG_DWORD – Log To = 3

– DataType: REG_DWORD – Verbosity = 7

NAL logging, set the values:

NAL_LOG_VERBOSITY_LEVEL_1 = Errors

NAL_LOG_VERBOSITY_LEVEL_2 = Warnings

NAL_LOG_VERBOSITY_LEVEL_4 = Information

NAL_LOG_VERBOSITY_LEVEL_7 = Errors, Warnings, Information

SCCM loglarımız with NAL logging are as follows:

compsumm.log – SMS_COMPONENT_STATUS_SUMMARIZER

Distmgr.log – SMS_DISTRIBUTION_MANAGER

inboxmgr.log – SMS_INBOX_MANAGER

ntsvrdis.log – SMS_WINNT_SERVER_DISCOVERY_AGENT

sitecomp.log – SMS_SITE_COMPONENT_MANAGER

Sitestat.log – SMS_SITE_SYSTEM_STATUS_SUMMARIZER

smsexec.log – SMS_EXECUTIVE

IMPORTANT:Registry changes to work:

Stop the SMS_SITE_COMPONENT_MANAGER

Stop the SMS_EXECUTIVE

Start the SMS_EXECUTIVE

Start SMS_SITE_COMPONENT_MANAGER

SCCM Agent (Workstation):

CCM for the verbose logging:

For Administrator Key, “full rights” to provide the necessary – there is no default.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\CCM\Logging\@GLOBAL

Set of the following values:

LogEnabled = 1

LogLevel = 0

LogMaxSize = 40000000

LogDirectory = c: \windows\system32\ccm\logs (If you want to print the logs to a different location)

LogMaxHistory = 1 (Although the size of the logs is filled with incense,> here is one: will be holding an old log. Example: Execmgr.log and will execmgr.lo_.
Verbose logging is not enough DebugLogging CCM:

This is necessary to create the reg KEYI:

HKEY_LOCAL_MACHINE \SOFTWARE\Microsoft\CCM\Logging\DebugLogging

– DataType: REG_SZ – Enabled = TRUE

WMI:

SCCM agent is based entirely WMI WMI is useful to turn verbose logging:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\WBEM\CIMOM\Logging = 0 – (REG_SZ – Disabled)

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\WBEM\CIMOM\Logging = 1 – (REG_SZ – Error only)

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\WBEM\CIMOM\Logging = 2 – (REG_SZ – Verbose)
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\WBEM\CIMOM\Log File Max Size = 4000000 – (REG_DWORD – If you need to WMI 2)

IMPORTANT: To study the changes of registry and WMI:

Restart the Computer

Other important components are: WSUS + SCCM component:

Set HKLM\SOFTWARE\Microsoft\SMS\Components\SMS_WSUS_SYNC_MANAGER

– DataType: REG_DWORD – LogLevel = 3
LOG_SUMMARY = 1;

LOG_DETAIL = 2; default

LOG_VERBOSE = 3;

LOG_DEBUG = 4;

Author

Anoop is Microsoft MVP! He is a Solution Architect in enterprise client management with more than 20 years of experience (calculation done in 2021) in IT. He is a blogger, Speaker, and Local User Group HTMD Community leader. His main focus is on Device Management technologies like SCCM 2012, Current Branch, and Intune. E writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc…

1 thought on “SCCM Server-Side Logging How to Turn On Verbose SQL NAL logging”

  1. HKEY_LOCAL_MACHINE \ SOFTWARE \Wow6432Node\ Microsoft \ SMS \ Tracing
    On 64 bit Servers… The “The Tracing” reg location is little different 🙂

    Reply

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.