BTW, this was for system with less than one gig, but you can modify it. Cesar A. Meaning is NOT in words, but inside people! Dr. Myles Munroe.
> On Mar 10, 2015, at 8:48 PM, elsalvoz <[email protected]> wrote: > > 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. > >
