Tuesday, July 7, 2009

How to Create Custom Address List from Contacts with PowerGUI

Here is the scenario, you are asked to create custom address list from available contacts on the GAL based on specific e-mail addresses.

New-AddressList -Name GmailContacts -RecipientFilter {(ExternalEmailAddress -like '*@Gmail.com')}

Click here to download it

image

As soon as you run this within the PowerGUI SE

image

image

image

Now lets make sure the Address list is providing what we wanted

Double Click and Preview

image

As we can see all Contacts start with @Gmail.com is in the address List already,,,,It is pretty easy and usefully

oz Casey Dedeal,

MVP (Exchange)
MCITP (EMA), MCITP (SA)
MCSE 2003, M+, S+, MCDST
Security+, Project +, Server +

Http://smtp25.blogspot.com (Blog)

Https://telnet25.spaces.live.com (Blog)

Https://telnet25.worldpress.com (Blog)

Exchange Server Remote Connectivity Analyzer Forums

We wont talk about PowerGUI this time (-:, Until tomorrow I mean,,,,,,,,,,,,,,,,, If you have not had a chance to check the Connectivity Analyzer out yet here is the link for it.

image

here is the article on Exchange team website

 

image

This fantastic tool designed to help exchange administrators and it is on the way to get better with your contribution, Exchange team will be opening “Forums” to hear your thoughts and suggestions to make this great tool even better.

So please come back and check in couple week for the URL for the Forums, I will be participating this forums actively and the goal is to hear from you, what you like, what you don't like about the tool and how can MS Team make the tool more productive for us? Your contribution is highly appreciated and I believe will make the product even better

Sit tight (-:

oz Casey Dedeal,

MVP (Exchange)
MCITP (EMA), MCITP (SA)
MCSE 2003, M+, S+, MCDST
Security+, Project +, Server +

Http://smtp25.blogspot.com (Blog)

Https://telnet25.spaces.live.com (Blog)

Https://telnet25.worldpress.com (Blog)

Scheduled task PowerGUI, E-mailing PS Scripts is very easy…..

Now one of the most asked question how do I get this nice report (PS Script) e-mailed to distribution group with scheduled task, we have touched base on this in the past but we will go over one more time.

If you are not a scripting person this post is perfect for you, if you never script anything in your life you are reading right article, I am sure PowerGUI will make you love PS scripts keep reading,,,,,

but first download PowerGUI (-:

The PS script is uploaded on my skydive for you to download

image

After downloading the PS script open with PowerGUI Script editor

image

Now don't forget to change the mail serve name to your own and click on the green arrow to run it

  • Verify the output as below
  • User Name       : Temp11
  • Department      : Temp Employee Office
  • Storage Group   : MAIL2\SG2\SG2-MB1
  • Total Size (MB) : 0
  • itemCount       : 10

 

image

Perfect now we need to add into PSCode a little bit, at the end of last line I will start typing Pipe and export as you see below

image

just because PowerGUI is very hand and smart it is already start helping me, by showing me the possible PS commands associating with export command, this is incredible useful and easy to learn, as you see there is another sub menu help window opened up helping me for my next command which will be “path”

image

If you loose this point your curser back to end of the command the window will re populate for you, same nice future continues to help as shown below

 

image

I finish as fallows

  • |export-csv -Path c:\report\UDSTI-Report.csv

image

after running the script I go back to my script folder to make sure the CSV file is in there

image

Here is my report

image

Now you have the report all you need to do is to run another script to e-mail this to yourself or a DL which is listed here

Send Mail With Attachment Using PowerGUI

image

one you get this working any report you wish to generate will be easy task for you.

As always all credits goes to PowerGUI, if you have not played with PowerGUI , click below link to download and start becoming PS master (-:

image

oz Casey Dedeal,

MVP (Exchange)
MCITP (EMA), MCITP (SA)
MCSE 2003, M+, S+, MCDST
Security+, Project +, Server +

Http://smtp25.blogspot.com (Blog)

Https://telnet25.spaces.live.com (Blog)

Https://telnet25.worldpress.com (Blog)

Wednesday, July 1, 2009

PowerGUI, Get-Mailbox DisplayName,Department,StorageGroup,TotalSize (MB),ItemCount

We wanted to include item count into previous PS Script and here is the new version of it , enjoy

image

image

image

oz Casey Dedeal,

MVP (Exchange)
MCITP (EMA), MCITP (SA)
MCSE 2003, M+, S+, MCDST
Security+, Project +, Server +

Http://smtp25.blogspot.com (Blog)

Https://telnet25.spaces.live.com (Blog)

Https://telnet25.worldpress.com (Blog)

PowerGUI, Get-Mailbox DisplayName,Department,StorageGroup,TotalSize (MB)

One of the question was asked how to get the information about usermail boxes , Storage Groups and the AD Attribute Department all together.

In previous posts we have already covered how to make any PowerGUI script to be e-mailed via windows scheduled task so this query also will be very handy.

Click here

image


Get-Mailbox -resultsize unlimited | select @{Name="User Name";expression={$_.displayname}},@{Name="Department";expression={(get-user $_.alias).department}},@{Name="Storage Group";
expression={$_.database}}, @{Name="Total Size (MB)";expression={(get-mailboxstatistics $_).totalitemsize.value.toMB()}}

 

image

 

image

 

 

image

All Credits goes to PowerGUI

image

oz Casey Dedeal

MVP (Exchange)
MCITP (EMA), MCITP (SA)
MCSE 2003, M+, S+, MCDST
Security+, Project +, Server +

Http://smtp25.blogspot.com (Blog)

Https://telnet25.spaces.live.com (Blog)

Https://telnet25.worldpress.com (Blog)

MVP Award one more year

Here is one of the most happiest news of my life (-:

Dear Oz Casey Dedeal,

Congratulations! We are pleased to present you with the 2009 Microsoft® MVP Award! This award is given to exceptional technical community leaders who actively share their high quality, real world expertise with others. We appreciate your outstanding contributions in Exchange Server technical communities during the past year……….

image

I would like to thank every each of you making me to get here and make me stick around one more great year. I could not have done it without support I always get from my students all my visitors and great friends….

I also would like to thank to some of my MVP pears for their endless support, James Chong (MVP), Andy Grohan (MVP) , Dean Eumura (MVP) …..

Thanks a lot for everyone's support , I will try to do my best to contribute as much as I can this year and will try to spread the love of Exchange (-: as much as I can , As always I am available to help , listen your questions and suggestions and carry your voice to Exchange team at any time.

Two things are keeping me very busy these days Exchange 2010 and Power GUI (-:,

Please visit my blog as I intend to post many articles this year

Thanks Guys,

oz Casey Dedeal

MVP (Exchange)
MCITP (EMA), MCITP (SA)
MCSE 2003, M+, S+, MCDST
Security+, Project +, Server +

Http://smtp25.blogspot.com (Blog)

Https://telnet25.spaces.live.com (Blog)

Https://telnet25.worldpress.com (Blog)