SCCM 2012 Basic All-in-one Hardware Report

SELECT  distinct
 CS.name0 as 'Computer Name',
 CS.domain0 as 'Domain',
 CS.UserName0 as 'User',
 BIOS.SerialNumber0 as 'Bios serial',
 SE.SerialNumber0 as 'System Enclosure serial',
 CS.Manufacturer0 as 'Manufacturer',
 CS.Model0 as 'model',
 OS.Caption0 as 'OS',
 RAA.SMS_Assigned_Sites0 as 'Site',
 RAM.TotalPhysicalMemory0 as 'Total Memory',
 sum(isnull(LDisk.Size0,'0')) as 'Hardrive Size',
 sum(isnull(LDisk.FreeSpace0,'0')) AS 'Free Space',
 CPU.CurrentClockSpeed0 as 'CPU Speed'

SCCM 2012 Reporting for dummies: Creating your own SSRS reports

Original Article: http://myitforum.com/myitforumwp/2012/10/29/sccm-2012-reporting-for-dummies-creating-your-own-ssrs-reports/

So we’ve talked about reviewing reports out of the box using the SCCM console as well as using the web browser. We’ll now get to the nitty gritty and create our own reports using SSRS. I’m sure you’re all eager to learn as you’ve come this far in my “Reporting for Dummies” series.

Using SCCM to migrate client computers from Java version 6 to version 7

Original article can be found here: http://seth.killey.me/?p=753


I’m in the process of upgrading all client computers from Java version 6.31 to Java 7.4.  Like all major version upgrades of Java if you simply install the new version the old version will remain installed.  Therefore, I’ve included instructions that allows you to remove the old version of Java, install the latest version, and then apply an update policy to fit your needs.

Using SCCM 2007 / 2012 to deploy Java Runtime Engine Updates

Original article can be found here: http://seth.killey.me/?p=288

Here’s some instructions for updating staff computers to the latest version of JRE using Microsoft System Center Configuration Manager 2007 / 2012. These steps will allow you to silently deploy JRE

LAST TESTED: JRE 7.55 on Windows 7

For info on upgrading from version 6 to version 7


Subscribe to RSS - 2012