All articles about Microsoft System Center range of products.
One of the great functions of Configuration Manager 2012 is the Software Catalog. This allows your users to become self-sufficient and stops them from pestering the IT Department every time they want the latest version of Java Client installed! So, apart from all your custom tools and programs, what should you have in your catalogue…
We have been looking for a good Project viewer for years, but never really found one that suits our needs. We have never really understood why Microsoft would release viewers for Word, Excel and even Visio but not for Project! We have tried a number of viewers with the least worst one being OpenProj. However,…
If you are looking at documenting your System Center Configuration Manager 2012 R2 environment then you may want to create some Visio layouts to show your server and role structure. To help you do this, you can now download a Visio System Center Configuration Manager 2012 R2 stencil pack. It is available from TechNet here:…
With the recent release of Dell’s new laptop ranges, Configuration Manager OSD professionals face new challenges. We recently had issues with some of Dell’s new laptops not picking up the network after PXE boot even though we had gone through the normal process of adding the network card drivers to the boot image and ensuring…
We have now updated our Autodesk serial number collection script to include the recently released AutoCAD 2015 and AutoCAD LT 2015. The following additions have been made to the script: AutoCAD 2015 AutoCAD LT 2015 – English AutoCAD LT 2015 – Italian AutoCAD LT 2015 – Polish AutoCAD LT 2015 – Hungarian This is an…
Mimecast have now released version 5.0 of their Outlook Client. This version of the MSO client now supports the following: Large File Sent Large File Receive Microsoft Outlook 2013 Other Microsoft Office 2013 Products (like Project and Visio 2013 no long conflict with it) Windows 8.1/8/7 There seems to be a slight redesign of the…
A free utility to get the WMI information from a computer. This is a great tool for SCCM administrators.
If you are using Configuration Manager, you will be aware that you can create a number of custom reports using the SQL data and SSRS to produce the reports. The best way to start to create a custom report is to ensure that you get your SQL query correct first. We have written hundreds of…
We are asked a lot both in a professional context and through this website about how first line techs can use the remote control functionality that Configuration Manager gives us without giving out access to the full Configuration Manager Console. Well, the answer is fairly simple, if your client machines have the Configuration Manager client…
If you are using Configuration Manager 2012 for Operating System Deployment (OSD) – which is one of the main functions of the system so we will assume that you are – then you may want to monitor the process of your task sequences. To do this, you should go into your Configuration Manager Console and…
An excellent tool to use alongside Configuration Manager is SCCM Client Center Tool. We have been using it for years and it also makes a great tool to hand out to helpdesk staff if you do not want them to have access to the full Configuration Manager Console. The tool has many functions but the…
We are pleased to announce the launch of our daily technology newspaper. Every day our newspaper will be automatically updated with all the latest Configuration Manager, System Center and Technology news pulled from various social media networks. You can view our newspaper by clicking the link below: TechyGeeksHome Daily Technology News
Microsoft has released the technical documentation for System Center 2012 R2. You can download the documentation in PDF, Word or CHM format directly from the Microsoft website using the link below: DOWNLOAD You can also view the TechNet site here: TechNet: Documentation Library for System Center 2012 Configuration Manager
Introduction If you are trying to use any remote tools like sysinternals against Windows Vista, 7 or 8.1 machines then you need to have remote UAC elevation privileges to enable you to carry out changes on the machine you are trying to amend. However, you may find that you are still having problems with connecting…
This is a SQL query for your SCCM database or you can use it to create a report using SSRS. For this work, you must ensure that you have the Logical Disk class enabled in the hardware inventory settings. This will give you the following information: Computer Name Disk Description Drive Letter Volume Name File…
This query will give you the amount of ConfigMgr clients that are installed on machines per AD site. This can be run on your Configuration Manager SQL database or you can use it to build a custom report using SSRS. More Queries Our full range of SQL and WQL Collection queries are available here. Feedback If…
This is a very simple SQL query but still very useful and will give you a lot of information about your Configuration Manager hierarchy. select * from sites Run this on your Configuration Manager database server or you can use it to create a custom report using SSRS. More Queries Our full range of SQL…
Java have now released update 51 of version 7 of their Java Client software. The update is available as an offline installer and using our guide below, you can extract the MSI from it and use it for deployment by using Windows Updates to update current machines or add to your Configuration Manager Application Catalog…
If you want to retrieve the site roles from your ConfigMgr environment, you can use the following SQL query: select SiteCode, RoleName, ServerName from SysResList 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…
If you wish to run a SQL query against your SCCM database to find all machines with SQL installed, then you can use this SQL query below: More SQL 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…
If you need to identify machines that have the Configuration Manager client installed but do not have the System Center Endpoint Protection client installed, then you can use the following 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…
If you have a requirement to identify machines with 4GB RAM or more, then you can use the following WQL query to do this. select distinct SMS_R_System.Name, SMS_R_System.ADSiteName, SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory, SMS_R_System.IPAddresses, SMS_R_System.LastLogonUserName, SMS_R_System.DistinguishedName from SMS_R_System inner join SMS_G_System_X86_PC_MEMORY on SMS_G_System_X86_PC_MEMORY.ResourceID = SMS_R_System.ResourceId where SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory >= 4096000 order by SMS_R_System.Name, SMS_R_System.ADSiteName, SMS_R_System.IPAddresses, SMS_R_System.LastLogonUserName, SMS_R_System.DistinguishedName You can change…
We have been using SCORCH for a while now and have acquired a number of Integration Packs. So, we thought we would zip them all up and add them to our site for you to download and use. Sorry but we cannot remember where most of them have come from as they have been gathered…
If you want to identify machines with a specific piece of software installed, you can utilise the Add/Remove Programs software inventory to do this by using this query. select distinct SMS_R_System.Name, SMS_R_System.OperatingSystemNameandVersion, SMS_R_System.ClientVersion from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = “Microsoft Office Professional Plus 2010” order by SMS_R_System.Name In this…
