How to Query SPN Records

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...

Read More»

How to install SCCM 2012 R2

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 »

The post How to install SCCM 2012 R2 appeared first on System Center Dudes.

Read More»

How to install SQL 2012 before installing SCCM 2012 R2

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.

Read More»

Requirements and recommendations before installing SCCM 2012 R2

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.

Read More»

SCCM 2012 R2 Step-by-Step Installation Guide

  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 »

The post SCCM 2012 R2 Step-by-Step Installation Guide appeared first on System Center Dudes.

Read More»

SCCM 2012 Useful Resources

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 »

The post SCCM 2012 Useful Resources appeared first on System Center Dudes.

Read More»

Create custom reports with Labels of Asset Intelligence

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.

Read More»

ConfigMgr 2012: Quick Model Count in SQL

Posted in CM2012ConfigMgrSQL

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: […]

Read More»