By Garth Jones While trying to understand Kerberos Double Hop authentication, I needed to check the Service Principal Name (SPN) records for one of my servers. Checking these records meant that I would have to verify each service account and this particular server had 6 different instances of SQL. Anyways, I stumbled across this tip about how to query AD...
In the first post of this series, we planned our hierarchy, prepared our Server and Active Directory. In part 2 installed and configured SQL in order to install SCCM. In part 3 we will run the prerequisite checker and install a stand-alone Primary site.Prerequisite Check Before launching the installation, I recommend to launch the Prereqchk tool in… Read More »
In the first post of this series, we planned our hierarchy, prepared our Server and Active Directory. In part 2 we will install and configure SQL before installing SCCM. Click the following link to see all supported SQL versions. For our post, will install SQL 2012 SP2 locally on the same server where the Primary Site will… Read More »
The post How to install SQL 2012 before installing SCCM 2012 R2 appeared first on System Center Dudes.
In the first part of this blog series about SCCM 2012 R2 installation, we will cover hardware requirements, design recommendations and server prerequisites. Hardware Requirements The hardware requirements for a Primary Site server largely depends on the features that are enabled, and how each of the components is utilized. When the number of clients grows and… Read More »
The post Requirements and recommendations before installing SCCM 2012 R2 appeared first on System Center Dudes.
SCCM installation is not a walk in the park and the product itself can be complex for inexperienced administrators. There’s already tons of installation guide available, written by experienced blogger and MVPs but I think that very few gives the whole picture from the start to the last component. Our goal is to bring it a bit further, explaining… Read More »
A new System Center book is set to publish this Friday March 27th. This one has me very excited because the focus is on reporting in System Center. And it is not just one or two System Center components they cover them all. This book dives in and gives you recipes’ as to how to […]
I often get question about where to start or where to find the best resources about Configuration Manager. I decided to build a list of the best tools to help you manage your SCCM environment. This list will evolve with time so bookmark this page and come back on a regular basis. Books To start… Read More »
Usually we use information from Add Remove Programs when it’s time to make software reports. For technical reasons, it’s not always easy to have adequate results. The use of custom labels in Asset Intelligence helps standardize and gather software information. In this post, we will explain how to use the data from custom labels in… Read More »
The post Create custom reports with Labels of Asset Intelligence appeared first on System Center Dudes.
Here is just a quick SQL query you can use to show how many of each model you have in your environment. I’ve got a Manufacturer filter on it, but you could remove that or modify as necessary. 1: SELECT 2: C.Model0, 3: COUNT(*) AS ‘Count’ 4: FROM 5: dbo.v_gs_computer_system C 6: WHERE 7: […]
Recently was standing up a new site and decided to use SQL 2014. According to the support page, SQL 2014 is supported. It is supported to upgrade from SQL 2012 to SQL 2014, but not for new site installs. However, if you use SQL 2014, you will encounter an error during the install process. Additionally […]