In-depth guides for Microsoft System Center products including SCCM/ConfigMgr, SCOM, SCVMM, and Orchestrator. Written for IT professionals.
If you are using System Center Orchestrator (SCORCH) Runbooks then you may have run into issues where the database is increasing in size due to the large amount of log files being created. This typically occurs when monitoring event logs on servers amongst some other runbook options in SCORCH. If you want to check how … Read more
If you are using System Center Operations Manager (SCOM) then you will find that you will need to apply your correct licence key to take it from an evaluation version up to a full version. To make this a simple process, you can run the following PowerShell command on your Operations Manager server: #Import Module import-module … Read more
If you are installing System Center Operations Manager, there are a number of pre-requisites that you need to install before running the installer. To make the pre-requisites installation easier, you can run the below Powershell command which will download and install all of the pre-reqs for you. Import-Module ServerManager Add-WindowsFeature NET-Framework-Core,AS-HTTP-Activation,Web-Static-Content,Web-Default-Doc,Web-Dir-Browsing,Web-Http-Errors,Web-Http-Logging,Web-Request-Monitor,Web-Filtering,Web-Stat-Compression,AS-Web-Support,Web-Metabase,Web-Asp-Net,Web-Windows-Auth –restart ##This section will … Read more
If you are using System Center Service Manager and creating custom management packs then you will want to seal them with a strong name signature. To do this, you will need to first of all generate the key file to allow you to use it when sealing your management pack. You need to use the … Read more
We have recently been asked to report on Google Earth installations within our SCCM environment. So, as we were already collecting the EXE file information within our hardware inventory, we could make use of the SoftwareFile data in the SCCM SQL database. Also, having spent some time Googling a query for Google Earth, we found that … Read more
If you are looking for HP driver packs then you can use the HP Driver Pack Matrix below: Notebooks & Tablets Windows 10 64-bit Windows 8.1 64-bit HP Elite x2 1012 G1 Tablet HP Elite x2 1012 G1 Tablet with Travel Keyboard sp77863.exe (Updated: 2016-10-07) – HP EliteBook 1030 G1 Notebook PC sp77666.exe (Updated: 2016-10-07) – … Read more
If you are using SCCM and you want to delete a device from your database (for example if you are using OSD and only deploying to Unknown Devices) then you would normally have to go into the SCCM Console, Devices, search for the device and then right click and delete the device which would remove … Read more
We have recently been using a new script that we came across which allows you to run a PowerShell script on your SCCM environment and it looks for all the Dell hardware models that you have and then automatically downloads all the latest drivers and BIOS’s for each machine found. This is an excellent way … Read more
If you are using SCCM for the deployment of software then you may find that with the smaller SSD’s that you may be using that free space is becoming an issue. This can be because the more an end user installs to their machine from your Software Catalog, the more data that is being downloaded … Read more
If you are using Configuration Manager and you want to create a collection based on all Windows 10 installations, you can use this WQL query below: select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.OperatingSystemNameandVersion like “%Microsoft Windows NT Workstation 10%” You can change the “%Microsoft Windows NT Workstation 10%” to create collections … Read more
If you are using Configuration Manager and want to run an SQL query on your database to count the number of different models you have in your organisation, you can use this SQL query below using SSRS to create a custom report: More Queries Our full range of SQL and WQL Collection queries are available here. … Read more
If you are using Configuration Manager and you want to create a collection of all devices that do not have the Configuration Manager Client installed, then you can use this WQL query: More Queries Our full range of SQL and WQL Collection queries are available here. Feedback If you have any questions or feedback about this post, or … Read more