select l.SystemName0, L.DeviceID0, L.Size0 from v_gs_logical_disk l where drivetype0 = 3
That's for anything in CM. If you want "just servers" then you'll have to ad in more views and more where statements to limit it to just servers. On Tuesday, March 10, 2015 12:30 PM, David McSpadden <[email protected]> wrote: If I don’t find what I want in the Hardware built in reports I may hit you up for that methodology. From:[email protected] [mailto:[email protected]] On Behalf Of elsalvoz Sent: Tuesday, March 10, 2015 10:00 AM To: [email protected] Subject: Re: [mssms] Disk space in CM12? I think I have one. Now, I just need to find it, I created it at one of my previous gigs. Cesar On Mar 10, 2015 6:32 AM, "David McSpadden" <[email protected]> wrote: Does anyone have a report of File Server Disk space for CM 12?? This e-mail and any files transmitted with it are property of Indiana Members Credit Union, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this email is strictly prohibited. Please consider the environment before printing this email. This e-mail and any files transmitted with it are property of Indiana Members Credit Union, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipient(s) or otherwise have reason to believe that you have received this message in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing, or copying of this email is strictly prohibited. Please consider the environment before printing this email.
