October 21, 2013 at 9:02 am
we need to provide Volume Capacity every month for every drive and difference between pervious and current growth on the drives.
At present we are doing in the below way,
we create a sql job on central server which will fetch all the disk space and drive information on all server
and will sent to mail in an .xls format.
Server_NameDriveFree_MB Total_MBPercent_Free
After that every month we are doing difference(previous and current month) in below way and updating in the below formate.
March Feb Jan difference
------------------------------------------------------------------ ---------------- ------------------------------------------------
Server, Disk ,Total capactiy ,Free space ,Space used,Free space,Space used,Free space,Space used,Mar13-Feb13,Feb13-Jan13,Mar13-Jan13 ,
Projected growth , Projected growth , Capacity planning
for next 3 months for next 6 months
Instead of doing it manully we need to do it automated.
Can anyone help me to wright the script to do it automated.....
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply