Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
curzonhub
Starting Member
12 Posts |
 Posted - 2011-10-31 : 18:28:50
|
| Hi, I have assigned a Task to find the available space,jobs,basically all the common details from all the servers.Our environment is clustered,is there any way I can generate an report OR I have to do It manually?They asked to to give the report on a excel.am |
|
|
vikki.seth
Yak Posting Veteran
66 Posts |
Posted - 2011-11-01 : 07:27:52
|
| More details are required. To get free space on hard disks, you can query xp_fixeddrives SP. To get free space from data/log files, you'll have to query sysfiles. |
 |
|
|
misslee
Starting Member
1 Post |
Posted - 2011-11-01 : 12:27:10
|
| I am looking for the same information, but I have around 50 sql servers/instances with various different versions of SQL and various number of databases and wonder if there is anyway that this can be done automatically. Would this be able to be achieved using a powershell script? |
|
|
|
Sachin.Nand
2937 Posts |
|
|
curzonhub
Starting Member
12 Posts |
Posted - 2011-11-01 : 14:35:09
|
| Hi I Have a powershell script to run ,but can someone guide me how and where to run the script?steps to be done,I have around 48 Instances. Thanksam |
|
|
|
curzonhub
Starting Member
12 Posts |
Posted - 2011-11-01 : 14:35:10
|
| Hi I Have a powershell script to run ,but can someone guide me how and where to run the script?steps to be done,I have around 48 Instances. Thanksam |
|
|
|
|
|
|
Monitor and report