Mining SCCM data for your Windows 7 Rollout

As many of you are aware, SCCM tracks and keeps a lot of information about the software that runs the PCs (and servers, but today's focus is PC Centric) in your environment.  Lately, I've been trying to find better and better ways to mine data out of SCCM to determine who has which pieces of software installed and how