http://blogs.technet.com/jonathanalmquist/archive/2009/04/25/all-disk-sizes-gb.aspx/*Get each logical disk size, for each agent computer, by OS version. This helps in calculating the Logical Disk Free Space Monitor from my earlier post .&#160; You can copy results into Excel, sort by system and non-system drives, and perform an averageen-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.technet.com/jonathanalmquist/archive/2009/04/25/all-disk-sizes-gb.aspx#3287391Fri, 16 Oct 2009 22:41:03 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3287391rdurbin<p>What database are you running this query against?</p>http://blogs.technet.com/jonathanalmquist/archive/2009/04/25/all-disk-sizes-gb.aspx#3287422Sat, 17 Oct 2009 03:02:43 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3287422jtalmquist<p>Hi rdurbin,</p> <p>This queries the OperationsManager database. &nbsp;Keep in mind, these are typed views, and assume that you have the Windows Server Operating System MP imported, as well as Windows Server 2000, 2003 and 2008 discovered logical disks. &nbsp;If there are only W2K3 server disks in your environment, then there will only be one MTV_LogicalDisk view (i.e., no _0 or _1).</p> <p>It's a quick and dirty query. :)</p> <p>-Jonathan</p>