Drat. Ok, thanks.

Heh..yeah. It felt good to figure it out, but also felt like a big facepalm because I had the same problem 5 days ago and forgot about it. Oh well.....

Aha! I've figured it out.. I was passing in the group name prefaced with the computer name (computername\groupname). I removed this is another script when I was getting t AD...

Hmm...Yeah, if I copy and paste that to a file, it works for me too. My problem must lie elsewhere. I'm reading a list of computers and groups from a...

Well, I spoke too soon. The backtick works when just issueing a command from the PS command line, but I'm trying to use this within a function, so the group...

That fixed it. Thanks!

Shaun

Thanks..Just wanted to make sure i wasn't missing something. Although, we're a fairly decent size shop, we also have untrusted domains and standalone servers, so it seems CMS wouldn't really...

Can someone explain the benefits of a CMS? From the article, it seems the main benefit is the ability to execute queries against multiple servers at once. But I can...

Or, if you have all the servers in a server group in SSMS, just open a multi-server query window in SSMS and run the query once against all the servers....

I created an SSRS report that reads the data table and makes graphs off of that.

Sure. The latest version can always be found here: http://shaunjstuart.com/archive/2011/07/drive-space-monitoring-page/

Eugene - I am unable to duplicate this issue. I created a VM named 1SQLSVR, installed SQL 2008 R2 on it, and loaded my routines. Everything worked correctly.

@VickyHarp on Twitter #sqlhelp found the problem - the clock on the server was wrong. It was 7 hours behind the network time. Changed it and all is working now!!

Thanks...

Yeah, been through all that:

1. Verified.

2. N/A

3. Verified.

4. N/A

5. Verified.

6. Verified.

7. N/A

Nope. Same domains.