Drive Space Monitoring Gets An Update

FYI, I wrote a part 2 to this article on my blog at http://shaunjstuart.com/archive/2010/10/im-published/[/url] which details how I used the data this collects to make a SSRS report.

Shaun

bwolf Newbie Points: 7 More actions · Answer 4

Very cool. Not seeing the attached script either.

davids-1023752 Valued Member Points: 65 More actions · Answer 5

davids-1023752

Valued Member

Points: 65

October 4, 2010 at 7:41 am

#1231001

Thanks

Mat Raftree Grasshopper Points: 10 More actions · Answer 6

We had to roll our own solution since we are using windows mountpoints for mapping new SAN luns into our clusters. Any chance you will be adressing that issue?

shaun.stuart SSCertifiable Points: 7033 More actions · Answer 7

Probably not, since I don't have a setup like that that I can test with. Sorry!

CJ_Cerro Valued Member Points: 72 More actions · Answer 8

Mat Raftree (10/4/2010)
We had to roll our own solution since we are using windows mountpoints for mapping new SAN luns into our clusters. Any chance you will be adressing that issue?

It can be done in Powershell using the "win32_mountpoint" class... I've been experimenting with it myself as I have the exact same problem. 🙂

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

Thanks for the article.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

mcvilbar Say Hey Kid Points: 701 More actions · Answer 10

Though, I did not test it yet on my environment right now but I'm very thankful and very grateful to Shaun for having this kind of article... Thanks a lot Shaun!!!! 🙂

shaun.stuart SSCertifiable Points: 7033 More actions · Answer 11

shaun.stuart

SSCertifiable

Points: 7033

October 4, 2010 at 7:38 pm

#1231412

Glad to help!

AmcAmx SSC Veteran Points: 269 More actions · Answer 12

Still can't get the files. Anyone else have any luck ?

Oops ! my bad... I have it working now...

ThanX for the great script

AmcAmx

Dominic-230373 Newbie Points: 8 More actions · Answer 13

It works fine for usual drives with a drive-letter

As soon as a disk has been mounted as a subfolder in a existing drive and the databases are within the mounted drive....it doesn't work.

Regards,

Dominic

Dominic-230373 Newbie Points: 8 More actions · Answer 14

DAMM!!!....sorry guys....I saw now the similar posts :-S

d trotman Valued Member Points: 58 More actions · Answer 15

Great article and scripts. I'm in the process of trying them out now. Just a small issue. Please remember the square brackets [] in your dynamic SQL either side of the servername. That way server instances will get taken care of also.