Making IT Happen
Below 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 MoreIf you want to create a Configuration Manager Collection with all inactive devices in it, you can use the following WQL query. You can also change the last “0” to “1” to create a collection of active devices.
SCCM WQL Query – All Inactive Clients Read MoreThis is more of a reminder for ourselves, but if you are looking to download Microsoft SQL Server 2012 express, for which you can use to install the SQL Console Management Tools as well, then the download link is below: Microsoft SQL Server 2012 Express Download
Microsoft SQL Server 2012 Express Read MoreIf you are getting this error message when you open SQL Server Configuration Manager in SQL Server: Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager. Invalid namespace [0x8004100e] Then there is a simple fix for this. All you …
SQL Server Configuration Manager cannot connect to WMI provider fix Read MoreThere is an excellent Powershell download available giving you 52 operational collections within SCCM. You should go over to the link below and take a look: 52 SCCM Powershell Collections Full list of collections created using the Powershell script are: All Clients All Clients Active All Client Inactive All Clients R2 CU0 All Clients R2 CU1 All Clients R2 CU2 …
SCCM – 52 Operational Collections Read MoreIf you are looking for a SCCM collection query for virtual machines in your environment, then you can use this query below:
SCCM Collection Query – Virtual Machines Read MoreYou may want to create a Configuration Manager Collection based upon an Active Directory Organisation Unit. To do this you can use the following WQL code and then simply amend the last part to be the Organisation Unit that you want to base the Collection on: SELECT SMS_R_USER.ResourceID, SMS_R_USER.ResourceType, SMS_R_USER.Name, SMS_R_USER.UniqueUserName, SMS_R_USER.WindowsNTDomain FROM SMS_R_User WHERE SMS_R_User.UserOUName = “LOCALDOMAIN.COM/COMPANYNAME/TECHYGEEKSHOME” More Queries …
SCCM Collection based on Active Directory Organisation Unit (OU) Membership Read MoreThis is a re-post of a guide that we posted about two years ago, but this happened to us again thisweek so thought it would be good to share again… We ran into an issue where our newly created folders and runbooks in Orchestrator were not showing up in our SCCM (MDT) Execute Runbooks task sequence. We started to run …
Orchestrator Not Showing Newly Created Folders or Runbooks Read MoreWhen running or trying to create a large report in SSRS, you may come across an error stating the below: Error 2: There was an exception running the extensions specified in the config file. Maximum request length exceeded. It took us a while to figure this one out but it is actually very simple. After speaking to our SQL and …
SQL Reporting Services Error – Maximum request length exceeded Read MoreIf you are a Configuration Manager administrator, the chances are that you are using the Application Catalog to allow users to install their own software.A great feature of this is that you can put in specialist or licensed software and add a “Request” button. This means that your end users will only get the software if you approve it. To …
Configuration Manager – How to Change the Approve/Deny Status of an Application Catalog Request Read MoreIn Configuration Manager 2012, there is a section under the Monitoring ribbon called Distribution Status. This will give you a lot of information about your distributions and your distribution points. If you look at Distribution Point Configuration Status, this gives you a good understanding of whether your drivers, packages, applications and images have deployed correctly to your local or remote …
SCCM Query – Report on Distribution Point Statuses Read MoreIf you want to report on machines that have Outlook archive (PST’s) on them, where they are and how big they are, then you can use this guide to create a report that will do this for you using Configuration Manager. First of all, you will need to tell your Software Inventory to look for PST files on machines. To …
SCCM – Report on Outlook Archive PST files on Devices Read More
