Pages

Showing posts with label query. Show all posts
Showing posts with label query. Show all posts

Friday, 28 November 2014

Free Disk Space Collection SCCM 2012

We have been having several users with older PC's complaining of low disk space errors.  These are normally shared Dell PC's with 80GB HDD's.  We have lots of surgerys where tens of nurses will log on and subsequently create a local profile.  As we have cached mode enabled for Outlook (don't ask) this creates massive .OST files in every profile.

I wanted SCCM to keep track of these machines and subsequently run a batch file that clears all the .OST files off the machine.

I wanted a collection that would list all machines with less than 1GB free disk space.  I created the collection courtesy of http://myitforum.com/myitforumwp/2013/12/09/sccm-2012-r2-free-disk-space-report/ but found it was empty no matter what.

I then eventually came across this post http://e-enfra.blogspot.co.uk/2012/02/sccm-2012-free-disk-space-is-not.html instructing that by default the disk space isn't automatically collected by the hardware inventory cycle.

Enable this and just wait for the Harware Inventory Cycle to kick in and the disk space info will become available.

Friday, 15 June 2012

Collection for MAC Address

If you are having issues with machines being renamed and need to locate it in SCCM why not try searching by MAC address?

Use this query and just adjust the MAC accordingly:

select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from  SMS_R_System where SMS_R_System.MACAddresses = "XX:XX:XX:XX:XX:XX"