sharepoint online – Is it possible to extract and/or set users’ birthday with a powershell script?

I’ve been doing some investigating and apparently a user’s birthday date (the one that shows up on Delve) is not stored in a property inside the user’s own office365 account object.

I’m trying to create a powershell script in Azure where I can update a user’s birthday with a value that is currently in a sharepoint list. As of right now if I could find out how to even set the birthday property hard-coded, that would be some progress.

Get-MsolUser and Set-Msoluser don’t work because as I stated previously the birthday date isn’t there for some reason, but I can retrieve a user’s birthday utilizing Microsoft Graph and sending a GET request to this uri of the API{user_id}/birthday
The response of that request is what I would like to be able to automatically set, but I can’t seem to find a way to do so.

database design – Providing guest users with full accounts vs only sessions (a.k.a. guest checkout)

I’m working on a web application with JWT authentication (with token stored in cookie) and an SQL database. Upon loading, the frontend makes a request to the backend to determine whether the user is authenticated and who he is.

In order to make the app more convenient to use, I want to allow users to use most of the features without signing up (i.e. submitting email + password).

  1. My currently preferred approach is to automatically create a proper account whenever the frontend makes that initial request without a valid authentication token and the user is immediately signed in, though the frontend pretends otherwise. When the user performs a sign in, the created account would be deleted and user would be signed in to their own account. Upon sign up, the user would become the owner of the guest account by setting an email and a password. The big advantage of this approach is, that, since the user always has a proper account with user id, all the APIs can keep the same logic for both guests and signed up users. The only downside I see, is that the email field in the users table would have to contain a random UUID to satisfy the unique constraint on the email field while the user is a guest.
  2. The other approach would be to create a separate table “sessions” and return a session id stored in a cookie to guest users. Upon sign up, the entry in the users table would be created and all the information attached to the session copied into tables attached to the users table. This would require creating a separate logic for guests and signed up users for each API.

Neither approach is completely clean, the first one essentially creates fake user accounts for guest users while the second one complicates the logic in every API function, having to decide where to store information depending on whether the user is authenticated.

Is there an alternative approach that’s better?
What are the issues that could arise if I go with the first approach?

7 – Batch delete users

When I received this Drupal 7 site to manage, it has had years of being open for people to make accounts and now I have ~ 300 PAGES of users with names like ismehacker1234568 and such, with under a dozen legitimate accounts I need to keep.

Once, on another site long ago I tried removing the users from the database table using a SQL query. That was a disaster and broke the entire site. I want to avoid that this time around.

I also need to delete any content they made, but not anything the legitimate users made.

Synced files on OneDrive if a user’s permission got removed from SharePoint

What will happen inside the synced OneDrive files if the user’s permission got removed from SharePoint.

  1. let say user A have contribute permission on siteA, and he synced files from the SharePoint site into his overdrive desktop app.

  2. and he chose to always show the files on his desktop.

  3. then UserA’s permission got removed from the SharePoint site >> so what will happen to the files inside the OneDrive app? will the user be able to view those files? or those files will also get removed from his OneDrive app, since he no longer can view them inside SharePoint?

powershell – Push a large file to 5k users via one drive

I have a scenario where I want to copy a large file( say 5 GB )to around 5k users one drive.

The users have synced their ODB to their desktop.

Expectation is to place the file in ODB in such a way that it gets synced locally to these users system.

I know that using nGSC sync client we can sync the shared with me folder to desktop but for that to happen, end user would have to go to browser to start the sync by pressing the button on the ribbon.