Notes from the Minnesota System Center Users Group

  Last Friday at the Minnesota System Center Users Group I had the pleasure of seeing Wally Mead speak! His session lasted about three hours and he covered Config Manger 2012 SP1. Configuration Manger 2012 – SP1 – probably won’t be released until Windows 8 is released. Windows 8 No more WAIK. WAIK is replaced […]

Windows 8 with Hyper-V

Last Friday at the Minnesota System Center Users Group I had the pleasure of seeing Wally Mead speak!  I noticed that Wally had Windows 8 on his laptop, but he was also using Virtual Machines.  I asked him if those were Hyper-V machines and he said yes.  At this point I was confused!  He told […]

SCCM Client Inventory and WSUS Scan state

Here is a view that you can use to see SCCM Client inventory and WSUS scan state information. CREATE view [dbo].[v_SCCM_Health_Check] as select distinct a.name0 as ‘MachineName’ , a.itemkey , a.operating_system_name_and0 as ‘OperatingSystem’ , os.CSDVersion0 as ‘OS_ServicePack’ , a.client0 as ‘SCCM_Client’ , a.Client_Version0 as ‘SCCM_ClientVersion’ , case when a.User_Name0 like ‘%\%’ then substring(a.User_Name0,charindex(‘\’,a.User_Name0)+ 1,charindex(‘\’,a.User_Name0)) else […]

TechFuseMN – 2012

I will be speaking at TechFuseMN on Thursday May 17th.  Here are links to a couple of the SCCM 2012 tools that I will be using. Right Click Tools – More Right Click Tools (since I have no idea how to get the above one’s to work!)   – RegKeyToMOF – Config Manager […]

Powershell–Schedule a SCCM Advertisement

One of the business units I work with needed to deploy an application using SCCM.  So far so good right?  Then they said that they only wanted it to run between 23:00 and 06:00.  So now you are thinking about putting a Maintenance Window on the collection to accomplish the time restriction requirement right?  Well, […]

Patch Compliance Calendar

I received a request a few weeks ago to create a report that had one row for each server and then one column per month / year.  In the column would be an asterisks if the server is compliant for all that patches for that month (meaning, all that months patches are installed). Well, after […]

Software Update Reports

Do you ever use the Software Updates reports that are built into SCCM?  Have you ever wanted a report that details information about patch compliance on a particular collection of machines?  List Of All Updates This report will list the following information: Bulletin ID – example MS12-006 Article ID – example 2638806 Date Posted Date […]