Re: Error on adding external smtp email to user

"Mark D. MacLachlan" <markdmac@live.com> wrote in message news:ehvatZH$JHA.5068@TK2MSFTNGP03.phx.gbl...
>
> Thanks Ace, that one has come in handy at many customer locations for
> me. it is especially helpful when you have been asked to move former
> employee addresses to another user.
>

I can see it's importance. I saved it in my archives.

Similarly, and I'm posting the attached scripts is to share with others as well, I've used the attached 'groups2' script to gather group info for a new or existing customer to see if I can use one of their groups as a dist group that may be a security group so I don't have to create a duplicate, or to enumerate all mailboxes and their sizes from an Ex2003 environment, as well as review the groups looking at a Security Explorer output of file share/NTFS permissions.

I've been wanting to change the attached MBX size script for powershell so I can enumerate and create an Excel sheet of the output. I mean I've been using the following command to look at sizes in PowerShell, such as the following, but the results go to the shell window, where I would like to have it create an Excel sheet.

Get-MailboxStatistics -database “Mailbox Database” | Select DisplayName, LastLoggedOnUserAccount, ItemCount, TotalItemSize, LastLogonTime, LastLogoffTime | Format-Table

But not being a scripter, and I've found the 'groups2' script at http://cwashington.netreach.net, I'm not sure how to incorporate the powershell command into a script to provide an Excel output such as the HTA script does for an Ex2003 environment. What would be nicer, is if I can combine the two into a script (which I don't think is possible) to get an MBX size report in a mixed Ex2003/2007 environment!

Ace

Ace Fekay [Microsoft Certified Trainer] wrote:

> "Mark D. MacLachlan" <markdmac@live.com> wrote in message
> news:ehvatZH$JHA.5068@TK2MSFTNGP03.phx.gbl...
> >
> > Thanks Ace, that one has come in handy at many customer locations
> > for me. it is especially helpful when you have been asked to move
> > former employee addresses to another user.
> >
>
> I can see it's importance. I saved it in my archives.
>
> Similarly, and I'm posting the attached scripts is to share with
> others as well, I've used the attached 'groups2' script to gather
> group info for a new or existing customer to see if I can use one of
> their groups as a dist group that may be a security group so I don't
> have to create a duplicate, or to enumerate all mailboxes and their
> sizes from an Ex2003 environment, as well as review the groups
> looking at a Security Explorer output of file share/NTFS permissions.
>
> I've been wanting to change the attached MBX size script for
> powershell so I can enumerate and create an Excel sheet of the
> output. I mean I've been using the following command to look at sizes
> in PowerShell, such as the following, but the results go to the shell
> window, where I would like to have it create an Excel sheet.
>
> Get-MailboxStatistics -database Mailbox Database | Select
> DisplayName, LastLoggedOnUserAccount, ItemCount, TotalItemSize,
> LastLogonTime, LastLogoffTime | Format-Table
>
> But not being a scripter, and I've found the 'groups2' script at
> http://cwashington.netreach.net, I'm not sure how to incorporate the
> powershell command into a script to provide an Excel output such as
> the HTA script does for an Ex2003 environment. What would be nicer,
> is if I can combine the two into a script (which I don't think is
> possible) to get an MBX size report in a mixed Ex2003/2007
> environment!
>
> Ace
>
>
>

Anything is possible. I've been doing a lot of integration between AD,
VBscript and PowerShell. Its all rather exciting (from a geek
perspective).

Take a look at using the PowerShell -Outfile parameter. You can easily
dump your PowerShell results to a CSV file which can then be
manipulated easily with VBScript and Excel.

--

"Mark D. MacLachlan" <markdmac@live.com> wrote in message news:%23kzq9tO$JHA.1376@TK2MSFTNGP02.phx.gbl...
>
> Anything is possible. I've been doing a lot of integration between AD,
> VBscript and PowerShell. Its all rather exciting (from a geek
> perspective).
>
> Take a look at using the PowerShell -Outfile parameter. You can easily
> dump your PowerShell results to a CSV file which can then be
> manipulated easily with VBScript and Excel.

I can definitely see the excitement. I'm not a scripter, but understand it at a rudimentary perspective, because years ago I was somewhat familiar and worked with Basic, Fortran, Cobol and a little Assembler. Yep, dating myself! But it's been so long ago, that I forget much of the syntax, but I do associate with the old flat-level style (or whatever you want to call it) programming sytles, using Sections, Performs, Gosubs, etc, instead of using simple goto's, which I see a lot of with bat files and some VB script code. But I guess if I devoted some time, I would eventually learn it. I've been so busy with getting two startup-companies going, and trying to gear myself up to teach Ex2007 and the 2008 courses, that I just don't have the time.

Anyway, so you're saying to simply make the command the following and it should work? Boy, that is much easier than that VB script I was using to get MBX size data.

Get-MailboxStatistics -database “Mailbox Database” | Select DisplayName, LastLoggedOnUserAccount, ItemCount, TotalItemSize, LastLogonTime, LastLogoffTime | Format-Table -Outfile c:\mbxsize.csv

Now what happens with a mixed scenario? I know the other script I was using will not pull this data for Ex 2007 users, and I assume the above command will NOT pull this data from Ex2003 users, so I would have to run both to get a complete report. I can imagine this be a little time consuming with 4500 users with a mixed 2003/2007 environment, as one of my former customers I was subbed at.

Ace