Office 365 Admin Centre - Order Users?

[Joanne]

So when I sign into my admin centre I have all users in a big list there.

 

Is there any way I can order them into folders, like Staff, Students etc.?

 

Or is the only way to sync with AD? I do not do this currently.

 

I'm concerned that it is going to be difficult to delete leavers!

[ChrisH]

if you have it through BTLS they have already told me we cannot use AD sync as that is not part of the package we are on!

[Matt_Renato]

You can create custom filters (these are called views in the old admin portal), which might be possible depending on what information you included when you created the accounts originally.

[Joanne]

Oh man!

 

That means that I'm going to have to delete one user at a time for leavers then? Wah.

[robyholmes]

Before i used AD Connect I put 'Pupils 2016' in to Department for our current year 11s say. Then you can create a display filter which filters by that name.

[Joanne]

You can create custom filters (these are called views in the old admin portal), which might be possible depending on what information you included when you created the accounts originally.

 

I have staff and pupils. Unfortunately doesn't help when it comes to deleting a cohort. Maybe I should have thought about this before creating them all

[ChrisH]

Or change your user name convention to include year of entry? That way a partial search will get you 20-30 a page.

[Joanne]

Right so in le future - put the year in the department.

 

Thanks guys!

 

- - - Updated - - -

 

Or change your user name convention to include year of entry? That way a partial search will get you 20-30 a page.

 

Nah the kids can barely spell their names without putting a number in there too!

[Matt_Renato]

The other option is to get your hands dirty with some Powershell.

[ChrisH]

Use the department field for the year group then and use that as a search filter.

[Joanne]

Yeah while I'm quiet I might have a quick run through and add the Class into the department. Will make it easier for the future! Edited April 26, 2016 by Joanne

[Matt_Renato]

How many users do you have? If you can get the details into a CSV then it isn't a very complicated Powershell script to update each user.

[Joanne]

Only 4 year groups with 2 classes in each year... 200ish?

[Matt_Renato]

The below Powershell code will update the depart from a CSV file. The first column in the CSV needs to have the header login and should contain the email address the user logs in with. The second column should have the header department and needs to contain whatever value you want the department to be set to. Change the variable $CSVPath in the code below to point to the location of the CSV file.

 

You might also need to install the Microsoft Online Services Sign-in Assistant which can be found here https://www.microsoft.com/en-gb/download/details.aspx?id=28177

 

### Enter path to CSV
$CSVPath = "C:\Scripts\Users.csv"

### Import the CSV
$CSVImport = Import-CSV $CSVPath

### Connect to O365
Connect-MsolService

### Run through each user in the CSV and update their department
$CSVImport | ForEach {Set-Msoluser -UserPrincipalName $_.login -Department $_.department }

[Joanne]

Hmmm... installed the sign in assistant, but now I can't find it... so this happened...

 

[Matt_Renato]

My bad, you'll need the Azure AD cmdlets for Powershell too.

 

https://technet.microsoft.com/en-ca/library/jj151815.aspx#bkmk_installmodule

[Joanne]

Seems to be running through it now. How exciting. I've not done anything with O365 and powershell before.

[Matt_Renato]

It's useful to be familiar with as there are some things which can't be done through the portal.

[mavhc]

if you have it through BTLS they have already told me we cannot use AD sync as that is not part of the package we are on!

 

Sounds like they're wrong about that, all schools have that option.

[Joanne]

I think it'll be more like they don't want to support it

[Matt_Renato]

Once it's installed and setup it tends to require very little support. The latest version even updates automatically. Edited April 26, 2016 by Matt_Renato
Typo

[ChrisH]

Sounds like they're wrong about that, all schools have that option.

 

I know I can see the option in the panel hence the exclamation. How far you'd get I wasn't willing to try just in case.

[Carrot63]

Hi

This is really helpful for me also thank you and putting info in the department field is a great easy idea.

So my problem is like others I don't have it in currently and would like to use the powershell option to import a csv file with this info in it. I am afraid I am falling at the first hurdle.

 

When I try the login it says I have invalid credentials (see screen shot) however I have entered the correct details and double-checked. Has anyone else experienced this issue? Am I missing something obvious?

 

Thanks

 

[Joanne]

Hi

This is really helpful for me also thank you and putting info in the department field is a great easy idea.

So my problem is like others I don't have it in currently and would like to use the powershell option to import a csv file with this info in it. I am afraid I am falling at the first hurdle.

 

When I try the login it says I have invalid credentials (see screen shot) however I have entered the correct details and double-checked. Has anyone else experienced this issue? Am I missing something obvious?

 

Thanks

 

[ATTACH=CONFIG]36426[/ATTACH]

 

I logged in using the O365 admin account e-mail address and the password for that...

[Carrot63]

Thanks, that is what I have been trying with and it logons to the web portal fine so I am using the correct details it just isn't working via the powershell command.