Here are the two scripts:

• SQL queries to get data from SCOM Databases:

http://gallery.technet.microsoft.com/CPU-Disk-and-Memory-a8a123bc

• PowerShell script to get CPU, Memory and Storage performance values:

http://gallery.technet.microsoft.com/StoragePerfCounters-ec8f6c8f