TheDesktopTeam Classroom – SCCM2012-Requirements

Hi All, on this video video about SCCM2012R2 we’ll be talking about Requisites for the SCCM Site Serer The video was recorded at 1920 × 1080, so full screen recommended. To download the video, right click as save as here and here for the slides. I hope you’ll enjoy and if you have any questions, please contact us or twit your question to @TheDesktopTeam and we’ll try to answer as soon as we can.

Read the complete blog: http://thedesktopteam.com/blog/raphael/thedesktopteam-classroom-sccm2012-requirements/

Read More»

Subselect Query for Reports (SQL)

By Garth Jones This post is a continuation of my series about how queries are processed. Please start with the first blog post in this series for more details. Today’s blog post will show you how to create a subselect query in order to discover which PCs do not have Microsoft Project 2010 installed using T-SQL (generally called SQL) for...

Read More»

Remote Server Administration Tools (RSAT) for Windows 8.1

By Garth Jones I don’t need to tell you that Configuration Manager administrators wear many hats and perform several tasks. One of those tasks is managing users and computers in Active Directory (AD). When I needed to perform this task, I noticed that Remote Server Administration Tools (RSAT) were not installed on my Windows 8.1 x64 PC, so this blog...

Read More»

Extracting the User Name From a Computer

By Garth Jones This question was asked in the Microsoft TechEd forum, “How do I get the user name from the PC name when the PC name has two different formats (XX-XX-XXX-XXXXXXX-X and XX-XX-XXX-XXXXXXX)?” In this particular case an extra character was added to certain PCs to indicate that they were rebuilt in order to avoid duplicate PC names in...

Read More»

SCCM 2012 R2 – Who dun it?! What have your admins been doing?

Players, A client of mine started slowly but surely getting more and more of his staff to start using SCCM 2012 R2. I created some custom RBA for his team, but as soon as I left … it seemed that some of the guys got lazy and just started adding people into the administrators group … So some admins had access over stuff in SCCM that they really should be allowed to touch … Long story short … some collections were deleted (by accident) and we needed to understand why and by whom. The guy wasnt in trouble, we just needed to identify who the admin was, so we can train them on how to manage collections correctly. Now there are many ways of doing this … My client wanted the “easiest way possible” to see “who dun it” in SCCM. So, there are actually some inbuilt reports in SCCM that…

Read the complete blog: http://thedesktopteam.com/blog/heinrich/sccm-2012-r2-who-dun-it-what-have-your-admins-been-doing/

Read More»

SCCM 2012 R2 SQL Query Issues

Players, A client of mine had a issue with a custom SCCM query we created to find malicious software, he wanted to edit it, something went wrong and the console crashed. So we wanted to delete it and start again as we had the query backed up anyway. When we tried to delete it, we got a random error message and it simply wouldn’t move. So we ripped it out of SQL, here’s how we did it. Connect to your SCCM Database (CM_Sitecode), 1. Expand tables2. then right click “dbo.queries” and edit the to 200 rows3. Selected “Custom Query NAME”  then right click and then delete it. You’re also able to edit the query should you need to for SQL it self. Enjoy

Read the complete blog: http://thedesktopteam.com/blog/heinrich/sccm-2012-r2-sql-query-issues/

Read More»

Free Disk Space Data and ConfigMgr 2012

By Garth Jones This question comes up from time to time, “I am not getting Free Disk Space (MB) data in Hardware 01A – Summary of computers in a specific collection report. Why?” The answer is simple. Free disk space data is not collected in System Center 2012 Configuration Manager (CM12) by default, so in order to collect this information...

Read More»

SCCM 2012 R2 Firewall Compliance Settings

Players. I recently needed to create a nice and easy way to check what state of the Windows Firewall settings on devices. This is very straightforward  when you use Compliance Settings in SCCM 2012 R2. In this scenario it was fairly easy as we needed to check if the firewall was on and to see if the connected profile in Windows Firewall is enabled or disabled. In this post I’ll show you how I did this. Configuration Item.  So, step 1 is to create a configuration item. This is used to define a configuration that we want to validate. Basically, the “stuff” we want to confirm is either on or off. We will need to create a single Configuration Item and once we are done creating it, associate it with a Configuration Baseline. But first you will the script below you can also find it here on MSDN. This is the script that I…

Read the complete blog: http://thedesktopteam.com/blog/heinrich/heinrich_pelser-sccm-2012-r2-firewall-compliance-settings/

Read More»

TheDesktopTeam Classroom – SCCM2012-SQL Server

Hi All, on this video video about SCCM2012R2 we’ll be talking about SQL Server The video was recorded at 1920 × 1080, so full screen recommended. To download the video, right click as save as here and here for the slides. I hope you’ll enjoy and if you have any questions, please contact us or twit your question to @TheDesktopTeam and we’ll try to answer as soon as we can.

Read the complete blog: http://thedesktopteam.com/blog/raphael/thedesktopteam-classroom-sccm2012-sql-server/

Read More»

TheDesktopTeam Classroom – SCCM2012-Active Directory

Hi All, this is the 2nd video about SCCM2012R2, now talking about Active Directory The video was recorded at 1920 × 1080, so full screen recommended. To download the video, right click as save as here and here for the slides. I hope you’ll enjoy and if you have any questions, please contact us or twit your question to @TheDesktopTeam and we’ll try to answer as soon as we can.

Read the complete blog: http://thedesktopteam.com/blog/raphael/thedesktopteam-classroom-sccm2012-active-directory/

Read More»

TheDesktopTeam Classroom – Introduction to SCCM 2012 R2

Hi All, the last few weeks we have been busy working on, what we call, TheDesktopTeam Classrom. This is basically a format of online videos we’ll be delivering. We are working hard on the content and will be posting not only videos about SCCM, but also Active Directory, MDT, OS Deployment, etc. The video was recorded at 1920 × 1080, so full screen recommended. To download the video, right click as save as here and here for the slides. I hope you’ll enjoy and if you have any questions, please contact us or twit your question to @TheDesktopTeam and we’ll try to answer as soon as we can.

Read the complete blog: http://thedesktopteam.com/blog/raphael/thedesktopteam-classroom-introduction-to-sccm-2012-r2/

Read More»