ConfigMgr Technical Previews 1805 and 1806

Technical Previews 1805 and 1806 have been released and each introduced some cool features I cannot wait to test out.

Technical Preview 1805

  • CMPivot – This has to be the coolest feature add in a long time and will be a game changer.  Gone should be the days of the Slow Moving System (SMS).  It is a query tool that lets admins get real-time data on clients.  You are able to query against connected devices and no longer have to wait for inventory.
  • Current logged in user – Get information on the current logged in user of a system in the console.
  • CMTrace – This lovely log viewing tool in now installed by default with the client install

Read up on other changes at https://cloudblogs.microsoft.com/enterprisemobility/2018/05/14/query-real-time-client-data-with-configuration-manager-technical-preview-1805/

Technical Preview 1806

  • 3rd Party Updates – You can now subscribe to 3rd party update catalogs from within the console and publish to your software update points.  ConfigMan will also sync with the catalog periodically to keep them up to date.  I haven’t had a chance to test and see if this requires SCUP to still be installed somewhere.
  • Package conversion manager – This tool in now part of ConfigMgr and can be used to convert classic packages to modern applications.

 

 

Translating error codes to error messages in your ConfigMgr reports.

I was recently working on a set of custom reports on the configuration baseline and configuration item compliance. I noticed some systems failed on a few configuration items so I decided to bring in the ErrorCode info in from the v_CIErrorDetails view.  Unfortunately, as nice as error codes are to have, we don’t know what all of them mean so plain text reason for an error is helpful.  I am going to show you one way to do just that.

Continue reading “Translating error codes to error messages in your ConfigMgr reports.”

Getting IP or subnet to sort correctly in a SQL query

I recently was working a SQL report that listed our SCCM subnet boundaries so that we could start to combine then into larger IP ranges. The issue is that IP addresses and subnets are not sorted properly. In researching a solution, I found a couple but this is the one I like that most. Continue reading “Getting IP or subnet to sort correctly in a SQL query”

SCCM Run Script Examples

One of my favorite, if not my favorite, features of SCCM current branch is the ability to run PowerShell scripts against a system or collection from within the console. You just have to create a new script in the console and, when you run it against a system or collection, the script runs on the system(s) locally. This is a great way to automate some of those routine tasks you may have. Continue reading “SCCM Run Script Examples”

PowerShell Script to Automate Running ContentLibraryCleanup.exe Against All DPs in SCCM Site

This is a rough script that automates the running of the content library cleanup tool available after SCCM Build 1702. The script will connect to a SCCM site to build a list of distribution points to run against. This needs to be ran on the primary site server under account with full admin rights in SCCM. It checks four possible locations for the PS module and the cleanup tool. The script prompts for the SCCM site code, the FQDN of the primary site server, and if you want the tool to delete orphaned content or just log to the tools default log location. Continue reading “PowerShell Script to Automate Running ContentLibraryCleanup.exe Against All DPs in SCCM Site”

PowerShell Script to Look for Installed KB

This is a basic PowerShell script that can be used to determine if a KB related update is installed. You can use it to check and run an uninstall command or as part of a SCCM Compliance Settings configuration item. Yes, you can add updates directly to configuration baselines, but I am still learning PowerShell and wanted to do it the hard way. Plus, you can add additional script to it look at other things besides the presence of a KB to include installed software, state of a service, or registry settings. The compliance can also be switched around where having the KB installed is not complaint and then a remediation script can be used to uninstall the KB. Continue reading “PowerShell Script to Look for Installed KB”

SCCM Compliance Settings Scripts to Alter Service State

Previously I showed how I used SCCM Compliance Settings and Boundary Groups to apply BITS settings. This time I have a discovery and remediation script that can be used with enforce a specific state on a service. If you want to make sure a client’s App-V service stays up or Windows Defender is disabled because you are using another security suite, this could be of help. The script uses variables so someone could easily set the state of the service and start type to what they want. Continue reading “SCCM Compliance Settings Scripts to Alter Service State”