Here you go.
WITH diskspace AS (SELECT SYS.Name AS [Server Name],
CASE WHEN RSYS.Is_Virtual_Machine0 = 1 THEN 'Virtual Machine' ELSE
'Physical Machine' END AS [Hardware Type],
vHSLDISK.TimeStamp AS [Scaned Date], vHSLDISK.DeviceID0 AS [System Drive
C:],
vHSLDISK.FreeSpace0 AS [Free space (MB)]/* ,ROW_NUMBER() OVER
(PARTITION BY User ORDER BY vHSLDISK.TimeStamp DESC)*/ ,
ROW_NUMBER() OVER (partition BY SYS.Name
ORDER BY vHSLDISK.TimeStamp DESC) rno
FROM v_FullCollectionMembership AS SYS INNER JOIN
v_HS_LOGICAL_DISK AS vHSLDISK ON SYS.ResourceID =
vHSLDISK.ResourceID INNER JOIN
v_R_System AS RSYS ON SYS.ResourceID =
RSYS.ResourceID INNER JOIN
v_GS_LOGICAL_DISK AS LDISK ON SYS.ResourceID =
LDISK.ResourceID
WHERE (vHSLDISK.DeviceID0 = 'c:') AND (SYS.CollectionID =
'CAS00E1E') AND (vHSLDISK.FreeSpace0 <= 1000))
SELECT [Server Name], [Hardware Type], [Scaned Date], [System
Drive C:], [Free space (MB)]
FROM diskspace
WHERE rno <= 10
--ORDER BY [Free space (MB)] ASC
On Tue, Mar 10, 2015 at 11:50 AM, Sherry Kissinger <
[email protected]> wrote:
> 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.
>
>
>
>
>
