Drives Information

Can any body tell me that Can I know the number of drives in system as well
as the used and free spaces of that harddrive through xp_cmdshell
Thanks
Noor
Hi,
Execute the below command from query analyzer:-
master..xp_fixeddrives
The above command will give you all the local drives and free space in MB.
Thanks
Hari
MCDBA
"Noor" <noor@.ngsol.com> wrote in message
news:OEpjKVnWEHA.3492@.TK2MSFTNGP10.phx.gbl...
> Can any body tell me that Can I know the number of drives in system as
well
> as the used and free spaces of that harddrive through xp_cmdshell
> Thanks
> Noor
>
|||Thanks Hari, but it gave the primary drive letter and it's space. I want the
all available drives and it's spaces.
Thanks
Noor
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:uCgFFknWEHA.3716@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Execute the below command from query analyzer:-
> master..xp_fixeddrives
>
> The above command will give you all the local drives and free space in MB.
> --
> Thanks
> Hari
> MCDBA
> "Noor" <noor@.ngsol.com> wrote in message
> news:OEpjKVnWEHA.3492@.TK2MSFTNGP10.phx.gbl...
> well
>
|||Hi Noor,
master..xp_fixeddrives will give the information for all fixed drives in the
machine.
The network drives will not be listed. For that you can use xp_cmdshell 'dir
driveletter'
Thanks
Hari
MCDBA
"Noor" <noor@.ngsol.com> wrote in message
news:#Q4u3RoWEHA.2844@.TK2MSFTNGP09.phx.gbl...
> Thanks Hari, but it gave the primary drive letter and it's space. I want
the[vbcol=seagreen]
> all available drives and it's spaces.
> Thanks
> Noor
> "Hari" <hari_prasad_k@.hotmail.com> wrote in message
> news:uCgFFknWEHA.3716@.TK2MSFTNGP11.phx.gbl...
MB.
>