Improve company productivity with a Business Account.Sign Up

x
?
Solved

list of users that we on Exchange online in a excel format

Posted on 2011-09-15
8
Medium Priority
?
671 Views
Last Modified: 2012-05-12
1.      Save below script to note pad document as a .ps1 file.
2.      Save to desktop.
3.      Run PowerShell migration tool.
4.             Then go to start
5.             All Programs
6.             Microsoft Online Services  
7.             Migration
8.             Migration command shell
 
$owaserver = "red002.mail.microsoftonline.com"
$AdminCredential = get-Credential
$colUsers = get-msonlineuser -Credential $AdminCredential -Enabled `
| Select-Object @{name='DisplayName';Expression={$_.displayname}}, `
@{name='Identity';Expression={$_.identity}}, `
@{name='IsActive';Expression={$_.isactive}}, `
@{name='PasswordExpirationDate';Expression={$_.passwordexpirationdate}},`
@{name='LastSignedInDate';Expression={$_.lastsignedindate}},`
@{name='CreatedDate';Expression={$_.createddate}},`
@{name='FirstName';Expression={$_.FirstName}}, `
@{name='Lastname';Expression={$_.LastName}}
$colusers | Export-Csv "-$((Get-Date -uformat %Y%m%d%H%M%S).ToString()).csv" -NoTypeInformation

The script is only exporting 252 users out of 320 users, Attched screen shot of the warning. This is been run in the migration console for Microsoft's BPOS.
What needs to be change on the script above to allow all 320 users to be pulled.

 Powershell warning
0
Comment
Question by:Rickdangerousire
8 Comments
 
LVL 10

Assisted Solution

by:Benjamin MOREAU
Benjamin MOREAU earned 500 total points
ID: 36545347
Try to add :

Get-MSOnlineUser -ResultSize 9999 ...
0
 
LVL 16

Expert Comment

by:Dale Harris
ID: 36545376
Can't you use "0" as a universal "unlimited feature"?  I don't know because I haven't tried it, but that's how you can specify it in other commands.

DH
0
 

Author Comment

by:Rickdangerousire
ID: 36545420
script was ran after this was added, came back with errors

$colUsers = Get-MSOnlineuser -Credential $AdminCredential -resultsize 999999 -Enabled `
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
LVL 49

Assisted Solution

by:Akhater
Akhater earned 500 total points
ID: 36546144
please run the below alone does it return the same warning ?

 $colUsers = get-msonlineuser -Credential $AdminCredential -Enabled -ResultSize unlimited

0
 
LVL 16

Accepted Solution

by:
Dale Harris earned 500 total points
ID: 36546174
according to a microsoft page, it's supposed to be <Int32>.

This would tell me ResultSize cannot be a string.  Int32 maximum value in case you're wondering: 2,147,483,647

I think your ` at the end might be causing you some issues.

If you're troubleshooting this one command and waiting for us to help, it might be beneficial to try to troubleshoot your command one step at a time.

So I would do something like this:

Get-MSOnlineUser

What does that return?

Then

Get-MSOnlineuser -Credential $AdminCredential

Then

Get-MSOnlineuser -Credential $AdminCredential -Enabled

Then

Get-MSOnlineuser -Credential $AdminCredential -Enabled -resultsize 999999

HTH,

Dale Harris
0
 
LVL 9

Assisted Solution

by:chrismerritt
chrismerritt earned 500 total points
ID: 36546416
Not used MSOnline, but in regular Exchange powershell this error shows up if you don't include a switch for -ResultSize.

What happens if you enter this?

$Mailboxes = get-msonlineuser -Credential $AdminCredential -Enabled
$Mailboxes.count

How many objects does that return? if you then run this what is returned?

$Mailboxes = get-msonlineuser -Credential $AdminCredential -Enabled -ResultSize "Unlimited"
$Mailboxes.count
0
 

Author Comment

by:Rickdangerousire
ID: 36554496
Thanks for the help everyone. The issue was internal with user names, however all of the above worked once that other issue was fixed.
0
 

Author Closing Comment

by:Rickdangerousire
ID: 36554506
Very long day, My writing was not the best. Thanks again.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

The article is for all the Exchange users seeking smooth and effective EDB to PST conversion. Exchange Server is the most widely used platform for messaging with collaborative sharing, Exchange online, secure working environment, etc.
Microsoft has decided to launch the Exchange Server 2019 this year for its on-premise users. What’s new now Microsoft is going to serve its users? How good is it going to be on the current Exchange Server 2016? This blog is going to answer all queri…
Watch the video to know how one can repair corrupt Exchange OST file effortlessly and convert OST emails to MS Outlook PST file format by using Kernel for OST to PST converter tool. It can convert OST to MSG, MBOX, EML to access them. It can migrate…
Watch the video to know the process of migration of Exchange or Office 365 mailboxes in absence of MS Outlook. It is an eminent tool which can easily migrate Public, Archive user mailboxes from one another Exchange server and Office 365. Kernel Migr…

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question