Since SCCM 1806, Microsoft have included a great tool called CMPivot to perform live queries across all currently connected SCCM clients, excluding those which are offline. Based on the Kusto query language that is also used for Azure Log Analytics, you can build queries to search or report on something…
Manage Windows Defender centrally via SCCM, defining Windows Defender policies for scanning, quarantine, updating, etc... For a complete step by step guide, read more here and here. Best have clients retrieve definition update over the internet instead of SCCM or WSUS as it doesn't require VPN back to…
Enable the ability to report back telemetry, statistics, etc... This is good for inventory or a form of asset management. For a complete set up guides, please refer to here and here. For troubleshooting the Reporting Services, please refer to this site. Create a discrete SQL User…
Prerequisites for installing SCCM: Steps above tested on Windows Server 2016 Standard. Install SQL Server - SQL 2014 or greater (Tested on 2014 SP2); NB: Be sure to install the SQL Instance Collation and subsequent DB's to SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS or else the SCCM install will fail.
Replicating an existing SCCM sever requires some planning and downtime. To minimize the impact, you should provision the successor, along with all the dependencies, SQL instance and accompanying Service Packs/Cumulative Updates; this preparation work will require more effort and does will not impact the…