+ Post New Thread
Results 1 to 9 of 9
Cloud Services Thread, O365 User admin in Technical; Hi all, We use O365 for staff members, mainly for Lync as we have Exchange on-prem. We are toying with ...
  1. #1

    Join Date
    Sep 2011
    Location
    Cambridgeshire
    Posts
    182
    Thank Post
    2
    Thanked 14 Times in 13 Posts
    Rep Power
    14

    O365 User admin

    Hi all,

    We use O365 for staff members, mainly for Lync as we have Exchange on-prem.

    We are toying with the idea of giving all our students email addresses in O365 and as an extension that will allow them Office 2013 Proper, as we licence the desktop for FTE.

    (Got to love end of month IT meetings!)

    What options do we have for student import, considering, and here is the kicker, we keep them all in a nice bespoke SQL database and not in any proprietary MS software such as AD.

    We would like it to be an automatic user add, but we know this probably isn't feasible, so maybe a batch import once a month or so.

    Any genius scripts out there or DirSync alternatives for non-AD?

    Any help appreciated,

    Thanks

    James

  2. #2

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    16,108
    Thank Post
    892
    Thanked 1,754 Times in 1,512 Posts
    Blog Entries
    12
    Rep Power
    458
    Do your students not have AD accounts?

    Is that SIMS your talking about?

    I bet these guys can do it - SalamanderSoft Limited

  3. #3

    Join Date
    Sep 2011
    Location
    Cambridgeshire
    Posts
    182
    Thank Post
    2
    Thanked 14 Times in 13 Posts
    Rep Power
    14
    Nope and Nope!

    We have a web based admin system that we have built in house, with logon coordinated between our admin and moodle sites.

    So all students have a 6 digit "Moodle" number and their own password, this is kept in SQL 2008

    This is always our problem when we want to use "off the shelf"! Everyone assumes we either user Sims or AD!

  4. #4
    Marshall_IT's Avatar
    Join Date
    Jul 2011
    Location
    Leeds
    Posts
    540
    Thank Post
    78
    Thanked 78 Times in 63 Posts
    Blog Entries
    1
    Rep Power
    21
    I don't think there is anything off the shelf that will work for you.

    Is the SQL ms? If so you should be able to query it with powershell and then take that list into office 365.

    Set it as a scheduled task and you'll be automated.

  5. #5

    Join Date
    Sep 2011
    Location
    Cambridgeshire
    Posts
    182
    Thank Post
    2
    Thanked 14 Times in 13 Posts
    Rep Power
    14
    Yes it is MS SQL. Probably outside my scripting expertise!!

  6. #6
    jonawd's Avatar
    Join Date
    Dec 2009
    Location
    Hayfield, High Peak
    Posts
    45
    Thank Post
    4
    Thanked 7 Times in 7 Posts
    Rep Power
    11
    If you are not using a Directory system such as AD, I think your probably down to looking at custom scripts.
    It shouldn't be too difficult to build the queries required from your database to create a csv for importing into Office 365, which you could then do through PowerShell with something like this:


    Import the users from a CSV
    Code:
    import-csv $path | foreach { 
    New-Msoluser -userPrincipalName $_.UserPrincipalName -displayname $_.displayname -firstname $_.firstname -lastname $_.lastname -password $_.Password -usagelocation "gb" 
    }
    License the users
    Code:
    import-csv $path | foreach { 
    set-msoluserlicense -addlicenses "$server" 
    }

    Out of curiosity, do you not use a Directory service at all for managing your clients login's etc.? Or is it that you use something like Novell instead?

  7. #7

    Join Date
    Sep 2011
    Location
    Cambridgeshire
    Posts
    182
    Thank Post
    2
    Thanked 14 Times in 13 Posts
    Rep Power
    14
    We run AD for our staff, but our students are kept in a bespoke admin database with an SQL backend, which Moodle talks to for their login, as Moodle is the only service we currently offer them.

  8. #8
    jonawd's Avatar
    Join Date
    Dec 2009
    Location
    Hayfield, High Peak
    Posts
    45
    Thank Post
    4
    Thanked 7 Times in 7 Posts
    Rep Power
    11
    Ok, so your pupils don't login to computers, just moodle. Interesting setup!

    In that case, your probably down to 2 options as far as I can see:

    1) Import your pupils into Active Directory (even if they are never used here) and DirSync
    2) Import your pupils directly into Office365.

    As you've got a bespoke system for their data, you'll have to extract that either way, so once you've got that out, importing into either AD or Office 365 shouldn't be too difficult. There are more 3rd party options for importing into AD, so that may be easier than scripting O365.

    Personally, I'd put them into AD as you can manage them more easily from here (new accounts, removing leavers etc.) rather than having to update Office 365 with import scripts every time.

  9. #9

    Join Date
    May 2011
    Location
    Jus North of London, close but not too close
    Posts
    812
    Thank Post
    181
    Thanked 63 Times in 60 Posts
    Rep Power
    36
    TBH If they do not at the moment exist in AD I wouldn't bother putting them in AD you are adding a layer of complexity,

    I would however as others have said just upload them with a powershell script. You will need to use scripts if you don't want to have to manually set license, set usage location etc anyway. At least this way you will not get O365 complaining that you can not edit them withing the Office 365 portal because they are Synchronized with your AD :-)

SHARE:
+ Post New Thread

Similar Threads

  1. Deny users /admin option in RDP
    By stm-tech in forum Windows Server 2000/2003
    Replies: 2
    Last Post: 5th March 2013, 11:13 AM
  2. It's Learning - User Admin, Lynchpin and other issues
    By cvl4 in forum Virtual Learning Platforms
    Replies: 1
    Last Post: 12th September 2012, 03:15 PM
  3. sims.net users admin
    By itgeek in forum MIS Systems
    Replies: 19
    Last Post: 28th July 2009, 01:35 PM
  4. Deleted Admin User Account
    By timbo343 in forum Windows
    Replies: 8
    Last Post: 18th December 2007, 01:47 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •