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.

SCCM Report for all machines with IE9

If you know the steps to create a report then the SQL query you could use would be somthing like:

SELECT DISTINCT a.Name0 AS [Machine Name],
c.FileVersion AS [IE Version],
d.Caption0
FROM v_GS_SoftwareFile c INNER JOIN
v_GS_SYSTEM a ON c.ResourceID = a.ResourceID INNER JOIN
v_GS_OPERATING_SYSTEM d ON a.ResourceID = d.ResourceID INNER JOIN
v_FullCollectionMembership b ON a.ResourceID = b.ResourceID
WHERE     (c.FileName = 'iexplore.exe') AND (c.FileVersion like '9.%')
ORDER BY a.Name0

Please note this has a little bug where it will report multiple instances of the same machine due to the fact that SCCM will have polled every version of IE9 (each incremntal update etc)

It would be better to export this data in to Excel and then delete the duplicates in the name column...