How to track SQL server and file growth

HI, Forgive me as I try to work through my thoughts here. I am looking for
some help in creating a script that will gather drive data from 3 SQL
servers and record that to a SQL database. The data to be recorded was
originally just (DriveLetter, Size, SpaceUsed, SpaceAvailable). Now it
includes (FileNames, and Sizes) of MDF and LDF files in specific folders. I
started this yesterday and have a VBS script that pulls the original data
and saves it to a CSV file, then I created a VBA macro in an XLS file which
pulls that data in to a spreadsheet and assigns each servers data to a
different tab. But this requires a VBS file on each server and each VBS
file creates their own CSV file (on a central server where the XLS file is
located).. Anyway I would like to change what I have already done so that
there a fewer pieces, more data, and it is saved to an MDF. Can someone
help with this?
I don't know how you built VBS file since you have not shown us the source
so , take a look at
http://www.sql-server-performance.co...ith_dts_05.asp
"WANNABE" <breichenbach AT istate DOT com> wrote in message
news:e2d66s$2GHA.1292@.TK2MSFTNGP03.phx.gbl...
> HI, Forgive me as I try to work through my thoughts here. I am looking
> for some help in creating a script that will gather drive data from 3 SQL
> servers and record that to a SQL database. The data to be recorded was
> originally just (DriveLetter, Size, SpaceUsed, SpaceAvailable). Now it
> includes (FileNames, and Sizes) of MDF and LDF files in specific folders.
> I started this yesterday and have a VBS script that pulls the original
> data and saves it to a CSV file, then I created a VBA macro in an XLS file
> which pulls that data in to a spreadsheet and assigns each servers data to
> a different tab. But this requires a VBS file on each server and each VBS
> file creates their own CSV file (on a central server where the XLS file is
> located).. Anyway I would like to change what I have already done so that
> there a fewer pieces, more data, and it is saved to an MDF. Can someone
> help with this?
>
|||Thanks!!!, that looks like it just what I need. May need a little tweaking,
but so far so good..
Thanks again
======================================
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23piXMw$2GHA.1068@.TK2MSFTNGP05.phx.gbl...
>I don't know how you built VBS file since you have not shown us the source
>so , take a look at
> http://www.sql-server-performance.co...ith_dts_05.asp
>
> "WANNABE" <breichenbach AT istate DOT com> wrote in message
> news:e2d66s$2GHA.1292@.TK2MSFTNGP03.phx.gbl...
>
sql