#Tip of the Day

Check out for the most useful #ConfigMgr tips and tricks !!! 

Tip of the Day #1

You can cut/paste pretty much anything from the SCCM Console (CTRL+A/CTRL+C) to Excel or any text editor (CTRL+V). Useful if you quickly need to export a list of devices, packages, patches, applications, drivers or collections.


Tip of the Day #2

You can use the "Merge selected files" option in CMTrace to open multiple logs in one pane. Handy for watching the progress of something that spans multiple processes


Tip of the Day #3

Anything you extend in the SMS_Def.mof shows up in CMPivot as a querable class. I added a class to the HINV called "aaa" and it shows up immediately.


Tip of the Day #4

You can use the Render operator in SCCM CMPivot to visually display your query result? Type on the last line of your CMPivot query: render barchart


Tip of the Day #5

You can use CMPivot to query who is in Administrator on all of your machines, live.


Tip of the Day #6

You can open the SCCM Client agent directly, use run "control smscfgrc"


Tip of the Day #7

Always keeps in mind the maximum number of an incremental collection is 200! Depending on the number of collections, clients, frequency, and complexity. Maintain your incremental collection using "CEViewer" tool.


Tip of the Day #8

You can add multiple resources to a collection by separating their names by a comma. (Right-click on the collection and press add resources)


Add the following devices:



Tip of the Day #9

CMTrace has an Error Lookup option to convert error codes into words. Press CTRL + L and paste the error code.


Tip of the Day #10

Type in "CCM" in the run command and hit ENTER to bring up your local "C:\Windows\CCM" folder


Tip of the Day #11

You can see which store procedure's run console dashboards. Dashboard HTML files are installed with the console. Right click on a dashboard and find out the source

SQL Query: 

 SELECT * FROM Console_DashboardCharts


Tip of the Day #12

You can keep more logs on your SCCM site server Turn on ArchiveLogging !

 Check this registry key

HKLM\SOFTWARE\Microsoft\SMS\Tracing,  ArchiveLogging=1, ArchivePath=<local drive\folder>  


Tip of the Day #13

Enable debug mode in console. This will allow you to see the different Properties, Methods and Instances which you’d normally use WBEMTest or similar to view.

  Add "sms:debugview" to the end of the console extension properties. 

 “C:\Program Files (x86)\Microsoft Configuration Manager\AdminConsole\bin\Microsoft.ConfigurationManagement.exe” SMS:DebugView"  

Well documented HERE


Tip of the Day #14

You can see the impact of each SCCM update. Add the impact column to the Updates and Servicing node so you know what components are part of that SCCM upgrade


Tip of the Day #15

If you need to search for Servername or Ip Address etc. in SCCM Logs use the "Find in Files" Feature to find it in all Logfiles.


Tip of the Day #16

You can see the SQL code behind any action in the admin console. View the "SMSProv.log" and search for 'Execute SQL' to find the query