Making IT Happen
All articles about Microsoft System Center range of products.
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 there were not many solutions …
SCCM SQL Query – Google Earth Installs Read MoreIf 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) – HP EliteBook 1040 G3 Notebook …
HP Driver Pack Matrix Read MoreIf 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 it from the SCCM database. …
SCCM – Delete a Device using VBS Read MoreWe 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 of ensuring that you keep …
SCCM – Dell Client Bios & Driver Autodownload Read MoreIf 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 to the CCMCache on their …
SCCM – How to clear CCMCache content older than x days using Compliance Settings Read MoreMicrosoft have now released SQL Server Management Studio (SSMS) 2016 and is ready to download and use. You can get the download by clicking the button below: Download SSMS 2016 SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SSMS combines a broad group of graphical tools with a …
SQL Server Management Studio (SSMS) 2016 Released Read MoreIf you want to deploy the new OneDrive Next Generation Sync Client using SCCM, then there is a excellent guide available detailing how to do this over at scconfigmgr.com You can see the guide by clicking the link below: https://www.scconfigmgr.com/2016/05/24/deploy-onedrive-next-generation-sync-client-with-configmgr/
SCCM – OneDrive Next Generation Sync Client Read MoreMicrosoft have now released an update for Configuration Manager version 1606 to add Apple iOS 10 to the supported platforms list. This update adds the following platforms to the supported platforms list for Microsoft System Center Configuration Manager current branch, version 1606: All iOS 10 iPhone or iPod Touch devices All iOS 10 iPad devices These iOS 10 devices may …
SCCM – Apple iOS 10 Update for Configuration Manager 1606 Read MoreIf 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 for other operating systems as …
SCCM WQL Query – All Windows 10 Installs Read MoreIf 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. Feedback If you have any …
SCCM SQL Query – Count Computers by Model Read MoreIf 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 if you would like us …
SCCM WQL Query – No ConfigMgr Client Installed Read MoreBelow is a full list of SQL Server version numbers dating from version 7.0 through to the current 2016 RTM release. Codename RTM Service Pack 1 Service Pack 2 Service Pack 3 Service Pack 4 SQL Server 2016 NA 13.0.1601.5 SQL Server 2014 SQL14 12.0.2000.8 12.0.4100.1 12.0.5000.0 SQL Server 2012 Denali 11.0.2100.60 11.0.3000.0 11.0.5058.0 11.0.6020.0 SQL Server 2008 R2 Kilimanjaro …
SQL Server Version Numbers Read More
