SELECT Distinct SYS.Netbios_Name0, LDISK.Description0, LDISK.DeviceID0,
LDISK.VolumeName0, LDISK.FileSystem0,
LDISK.Size0, LDISK.FreeSpace0
FROM v_R_System SYS
JOIN v_GS_LOGICAL_DISK LDISK on SYS.ResourceID = LDISK.ResourceID
join v_fullcollectionmembership fcm on fcm.resourceid=sys.resourceid
WHERE fcm.CollectionID = 'SMS00001'
and sys.Operating_System_Name_and0 like '%server%'
ORDER BY SYS.Netbios_Name0,
ldisk.deviceid0
and of course, replace sms00001 with whatever collectionid you really want.
Now, I personally think that's a little too much info. I don't really care
about a cdrom drive or 3 1/2 disk...
so I'd probably add into the Where section...and ldisk.DriveType0 = 3so that I
only get fixed disks, not removable or whatever else might be there.
and that doesn't get you 'history'--unless you run it every week and keep the
history yourself or something.
On Wednesday, July 1, 2015 11:42 AM, Duane Roland
<[email protected]> wrote:
Thanks guys, sorry for the late replay I was away for a week on vacation.
What I'm trying to get is essentially the Report that is under:
Home > ConfigMgr_PS1 > Hardware - Disk > Disk information for a specific
computer - Logical disks
But be able to point that to our All Servers collection, instead of one
particular system. Know of a way to do that?
On Tue, Jun 30, 2015 at 1:49 PM, Gilmanov, Nile
<[email protected]> wrote:
In Reports, Hardware - Disk, see the report named “History *” Nile
GilmanovSystems AdministratorWabash National
[email protected] | O: 765.772.2691 | M: 765.414.7402
| F: 765.449.5381 From: [email protected]
[mailto:[email protected]]On Behalf Of Duane Roland
Sent: Monday, June 29, 2015 6:14 PM
To: [email protected]
Subject: Re: [mssms] Server Disk Space Report? I have that enabled but it comes
back with "total free" disk space on the server that is a sum of all volumes.
We would need each volume to have it's own free space total for this to be
effective. On Mon, Jun 29, 2015 at 11:21 AM, Gilmanov, Nile
<[email protected]> wrote:You already have this
enabled?http://e-enfra.blogspot.com/2012/02/sccm-2012-free-disk-space-is-not.html
Nile GilmanovSystems AdministratorWabash National
[email protected] | O: 765.772.2691 | M: 765.414.7402
| F: 765.449.5381 From:[email protected]
[mailto:[email protected]]On Behalf Of Duane Roland
Sent: Monday, June 29, 2015 1:54 PM
To: [email protected]
Subject: [mssms] Server Disk Space Report? I'm fairly new to SCCM 2012 R2 and
I'm wondering if anyone knows of a good server free disk space report that I
can set up to review on a monthly basis. Ideally it would have some history of
the server's previous month's free space so that there is some history
available. Is there a direction that someone can point me in or have one setup
now that they are happy with? Thanks all. Duane
