Exchange 2007 PowerShell..

Hopefully someone here is familiar with the Exchange 2k7 PowerShell..





I'm trying to export to CSV the LastName/FirstName of all users whose
mailboxes are not using the default database quota.


$allmbx= get-mailbox -resultsize unlimited| where
{$_.UseDatabaseQuotaDefaults -eq 'False'}



$allmbx | get-user -resultsize unlimited | select-object LastName, FirstName
| Export-Csv c:\defsize.csv





It generated the CSV alright, but it appeared to contain a lot more people
than I would've expected. I did a quick check on a handful of them and they
all had the default database quota parameter set to True.





Thanks in advance!

Never mind. I needed to add a "$" before False. That is,

$allmbx= get-mailbox -resultsize unlimited| where
{$_.UseDatabaseQuotaDefaults -eq $false}



"jim" <jim@nospam.com> wrote in message
news:eSywCFMOHHA.3212@TK2MSFTNGP02.phx.gbl...
> Hopefully someone here is familiar with the Exchange 2k7 PowerShell..
>
>
>
>
>
> I'm trying to export to CSV the LastName/FirstName of all users whose
> mailboxes are not using the default database quota.
>
>
> $allmbx= get-mailbox -resultsize unlimited| where
> {$_.UseDatabaseQuotaDefaults -eq 'False'}
>
>
>
> $allmbx | get-user -resultsize unlimited | select-object LastName,
> FirstName | Export-Csv c:\defsize.csv
>
>
>
>
>
> It generated the CSV alright, but it appeared to contain a lot more people
> than I would've expected. I did a quick check on a handful of them and
> they all had the default database quota parameter set to True.
>
>
>
>
>
> Thanks in advance!
>
>
>

That is correct.

'False' -ne $false


--
............... All new, all fresh ..............
http://www.leedesmond.com/weblog/



"jim" wrote:

> Never mind. I needed to add a "$" before False. That is,
>
> $allmbx= get-mailbox -resultsize unlimited| where
> {$_.UseDatabaseQuotaDefaults -eq $false}
>
>
>
> "jim" <jim@nospam.com> wrote in message
> news:eSywCFMOHHA.3212@TK2MSFTNGP02.phx.gbl...
> > Hopefully someone here is familiar with the Exchange 2k7 PowerShell..
> >
> >
> >
> >
> >
> > I'm trying to export to CSV the LastName/FirstName of all users whose
> > mailboxes are not using the default database quota.
> >
> >
> > $allmbx= get-mailbox -resultsize unlimited| where
> > {$_.UseDatabaseQuotaDefaults -eq 'False'}
> >
> >
> >
> > $allmbx | get-user -resultsize unlimited | select-object LastName,
> > FirstName | Export-Csv c:\defsize.csv
> >
> >
> >
> >
> >
> > It generated the CSV alright, but it appeared to contain a lot more people
> > than I would've expected. I did a quick check on a handful of them and
> > they all had the default database quota parameter set to True.
> >
> >
> >
> >
> >
> > Thanks in advance!
> >
> >
> >
>
>
>

The type for UseDatabaseQuoteDefaults is a Boolean.

You can confirm using

(get-mailbox "Joe Doe").UseDatabaseQuotaDefaults.GetType()

The potentially treacherous "feature" in PowerShell is that in code
you use $true or $false. In the console the Boolean values are
displayed as True or False.

Andrew Watt MVP

On Mon, 15 Jan 2007 11:21:48 -0500, "jim" <jim@nospam.com> wrote:

>Hopefully someone here is familiar with the Exchange 2k7 PowerShell..
>
>
>
>
>
>I'm trying to export to CSV the LastName/FirstName of all users whose
>mailboxes are not using the default database quota.
>
>
>$allmbx= get-mailbox -resultsize unlimited| where
>{$_.UseDatabaseQuotaDefaults -eq 'False'}
>
>
>
>$allmbx | get-user -resultsize unlimited | select-object LastName, FirstName
>| Export-Csv c:\defsize.csv
>
>
>
>
>
>It generated the CSV alright, but it appeared to contain a lot more people
>than I would've expected. I did a quick check on a handful of them and they
>all had the default database quota parameter set to True.
>
>
>
>
>
>Thanks in advance!