Hello,

Is there a command that would allow me to check the whole of AD with some criteria which would allow me to check which users do not have a mail enabled account.

So I will export it to a CSV file however I just dont know how to find a mail enabled user.

I would have the criteria based on title which is fine This I can do..

Get-QADUser -Title "teacher", "staff" | where {mailenableduser =false}| Export-Csv "C:\NonMailEnabledUsers.csv"

Something like the above but where the mailenableduser=false would be whatever I require.

I hope someone can assist.

James

Hi Again James,

Mail Enabled users are users without mailbox in local exchange organization and have an external email address where the mails would be forwarded.
Mailbox Users are users with the mailbox in local exchange organization servers.

#To get the mail enabled users try below. This will filter only mail enabled users from AD and will not return mailboxes.
Get-User -reslutsize unlimited | where {$_.RecipientType -like "MailUser" -and ($_.title -like "teacher" -or $_.title -like "staff")} | export-csv c:\mailenabledusers.csv

#To obtain mailboxe users. This will return only mailboxes.
Get-User -Resultsize unlimited | where {$_.RecipientType -like "MailboxUser" -and ($_.title -like "teacher" -or $_.title -like "staff")} | export-csv c:\MailBoxUsers.csv

Get-QADUser can not differentiate btwn Mail enabled user and Mailbox user.

Output files can be used to pipe into other cmdlets.

Thanks.

Hello,

I have come accross some code I think from this site from a google link...
#Add-PSSnapin Quest.ActiveRoles.ADManagement $User = Get-QADUser -Title "teacher", "staff" -SizeLimit 0 | Select RecipientType if ($user.RecipientType -ne "userMailbox") | Select-Object FirstName,LastName,SamAccountName,ParentContainer | Export-Csv "C:\NonMailEnabledUsers.csv"

However its throwing me up the following error:

Missing statement block after if ( condition ).
At C:\nonmailenabledteachers.ps1:5 char:44
+ if ($user.RecipientType -ne "userMailbox") | <<<<

Does anyone know why?

Many Thanks

James

Hello,

Sorry I thought that was the right terminology! My Mistake I apologise. I am indeed after the mailbox users which have a mailbox on the local exchange.

I have the following:

Get-User -ResultSize unlimited | where {$_.RecipientType -notlike "MailboxUser" -and ($_.title -like "teacher" -or $_.title -like "staff")} | Select-Object FirstName,LastName,SamAccountName,ParentContainer | Export-Csv "C:\NonMailBoxUsers.csv"

Would this give me all the teachers and staff which DO NOT have a mailbox on the local exchange.

As it seems to be pulling rather alot of users which I find hard to believe.

Many Thanks

James

Oh and sorry I posted after yourself I didnt get the refreshed page!

James

See if this helps:

Get-User -RecipientTypeDetails user -filter {Title -ne "teacher" -AND Title -ne "staff"} | select firstna
me,lastname,samaccountname,DistinguishedName

Shay,

Would that not give me all the accounts which DONT have a title of teacher or staff?

Many Thanks

James

Yes is should, and that do no have a mailbox account. Give it a try and judge by the result :)

James:

If you want Staff and Teachers, try this:

Get-User -RecipientTypeDetails user -filter {Title -eq "teacher" -OR Title -eq "staff"} | select firstname,lastname,samaccountname,DistinguishedName

Karl

Hello,

That seems to work fine I have found out why there are so many results! Its becuase we imported loads of users last night but I didnt know!

They match the schools who have been imported. I will give them accounts and re run my script.

Many Thanks for your time and assistance

James

Hey...

Is there a way to pull from a txt file with get-content... find the users  (listed in the text file) that do not have mailboxes and then pipe that out to a file? The first text file would have a bunch of SAM account names and so would the results text file.

I'm trying to do this based on what i'm seeing here and it just isn't working.

Here's an example of what I have been trying to do.
get-content C:\migration\checkmbx.txt | get-user RecipientTypeDetails user | ft SamAccountName,ServerName| out-file C:\migration\withoutmbx.txt

I would like to query users in a specific group or OU that are not mail enabled users. I have some students who have an AD account but have not been mail enabled.

Try this:


Karl

You can also mix quest with Exchange via a calculated property:

Get-qaduser -sizelimit 0 | select-object name, displayname, samaccountname, description, notes, department, email, @{name="ExchangeVersion"; expression={ (get-mailbox $_.samaccountname).exchangeVersion}} | export-csv -notype "h:\mailboxes.csv"

In this case I will instruct the customer to filter their spreadsheet on 'ExchangeVersion' to get the mail-enabled users. I also add a 'where-object' into this script as well.