Perfect

Thanks Scott

Tried that but record set didn't prove to be correct..

do you have an example using data, and example output I supplied?

Thx.

Any help on this request... I tried to goggle but didn't see examples...

Thanks.

It does just:

Get-ADUser -SearchBase  OU=??,OU=???,OU=User Accounts,DC=???,DC=???,DC=??? (stuff)

Filter * -Properties * | select -property CanonicalName,sAMAccountName,ou,distinguishedName

I get this error:

Get-ADUser : The supplied distinguishedName must belong to one of the following partition(s):

any ideas ???

I'm going with Page compression and simulated on my test server took around 1hr to complete.

Thanks for all suggestions and replies.

What sort of overhead does it have on the server when running, and any idea of duration on a 2.1 billion ow table?

The application has access to use previous tables in trending and analysis... it just has a feature that when a new month starts it defines a new Sql table inside...

Is there a script that will report savings for Page Compression?

Thanks.

Thanks...

The monthly tables are queried often..

Thanks Scott just what was needed.

Scott,

That worked but how can I pull for all equipment_id's using above query. This pulled back just  one ONE piece off equipment.

Thanks for response..

I want the first row, or if nothing found put out a message in table no record recorded.

thx.

Thanks..

$Date = Get-Date

$TimeZone = Get-TimeZone -Id "Central Europe Standard Time"

$OtherDate = [System.TimeZoneInfo]::ConvertTime( $Date, $TimeZone )

$OtherDate

How do I format $OtherDate into the file name, and also account for DST in my...

Thanks for ALL responses with ED B help and suggestion from Jeff I think I have enough info to procceed.

Thanks again.