Category Archives: Software

Exact Location of your SharePoint Online Microsoft Office 365 tenant

Quick answer: spin-up a few VMs in different Azure regions, then ping your SharePoint tenant. The moment you see 1ms ping you know the tenant exact location.

Full story

Microsoft says: “Customers should view tenant specific data location information in your Microsoft 365 Admin Center in Settings | Org settings | Organization Profile | Data location.
And it might look like:

That’s accurate to the geography (e.g. US, UE, AP), but not to the region (for instance – “Central US”, “UK West” or “Australia Southeast”).
In other words, If you know your data are in the US, you do not know where exactly – East/West/Central or South US.
Meantime when you create an Azure resource (e.g. Virtual Machine) – you can select specific region.

How do I know – where is my Microsoft 365 tenant actually located?

Can we just ping the tenant, analyze result and find Office 365 tenant region?
Luckily, SharePoint tenant is pinging with just
PS>ping tenantName.SharePoint.com
I have tested 5 regions and 4 different tenants:

ping from/to (ms)tenant 1 (US)tenant 2 (EU)tenant 3 (US)tenant 4 (US)
North Europe731796101
East US1833931
Central US221142323
West US631463633
South Central US3111211

So I figured it out:
My o365 tenants #3 and #4 regions are South Central US (Texas, San Antonio),
tenant #1 resides in East US.

Why do I need this?

Imagine you are running heavy reports against your tenant.
So probably you want your code running as close as possible to your tenant.
For this, you can spin-up a VM in Azure or use Azure Functions – just select proper region πŸ™‚
(please check also “Long-running PowerShell reports optimization in Office 365“)

References:
Where your Microsoft 365 customer data is stored

SPO: Allow users to create modern pages

Microsoft: “Using modern pages in Microsoft SharePoint is a great way to share ideas using images, Office files, video, and more. Users can Add a page to a site quickly and easily, and modern pages look great on any device.
If you’re a global or SharePoint admin in Microsoft 365, you can allow or prevent users from creating modern pages. You can do this at the organization level by changing settings in the SharePoint admin center. If you allow the creation of site pages as the organization level, site owners can turn it on or off at the site level.

By default both
– Allow users to create new modern pages
– Allow commenting on modern pages
are turned on (enabled)

Tenant or SharePoint admin can find settings under
SharePoint Admin Center -> Settings -> Pages

How it looks like:

Site Pages are created under “Pages” Library.

Let us test it, with:
– (tenant-level) Allow users to create new modern pages: ON
– (tenant-level) Allow commenting on modern pages: ON
– web feature “Site Pages” – “Allows users to add new site pages to a site”: Activated

User
Permissions
can create Pagecan edit pagecan Enable/Disable
page comments
can comment on Page
Full Control (Owner)YesYesYesYes
Edit (Member)YesYesYesYes
Read (Visitor)NoNoNoYes

There is a web feature “Site Pages” – “Allows users to add new site pages to a site”.
The feature is activated by default:

What if we disable this feature?
“New -> Page” has disappeared from “New” menu under “Site Contents” for Owners and Members…
From “Home” and “Pages” you still can see “New -> Page” options.
You can still create a new page from but if you try to create a page from Pages – “Sorry, something went wrong” “Cannot create a Site Page. Please have your administrator enable the required feature on this site.” :

Office 365 behavior, with:
– (tenant-level) Allow users to create new modern pages: ON
– (tenant-level) Allow commenting on modern pages: ON
– web feature “Site Pages” – “Allows users to add new site pages to a site”: Deactivated

User
Permissions
can create Pagecan edit pagecan Enable/Disable
page comments
can comment on Page
Full Control (Owner)Yes,
but only from “Home”
not from “Site Contents” or “Pages”
YesYesYes
Edit (Member)Yes,
but only from “Home”
not from “Site Contents” or “Pages”
YesYesYes
Read (Visitor)NoNoNoYes


If we disable feature “Site Pages” – “Allows users to add new site pages to a site” on the root web – it does not affect subsites (subwebs).

Can we Activate/Deactivate the feature “Site Pages” using PowerShell?

PowerShell

(TBP)

References
– Microsoft “Allow users to create and comment modern pages

See also:
Allow commenting on modern pages

Office 365 Search scopes

Search is everywhere in Microsoft 365. You can search from SharePoint, Teams, Delve, Yammer etc.

But! You cannot search for anything from everywhere!

  • Search for your Teams chat messages works only in Teams.
  • But from Teams you cannot search for regular (non-group) sites and public teams sites
  • All descriptions are totally out of search (e.g. site description, library/list description – including Yammer groups, Teams and regular sites).
  • Public Team Sites content is not searchable from Teams and Yammer

So, what are the scopes of each search entry point in Office 365 and is there an entry point you can search for everything?

Search scopesSharePoint
Search center
SharePoint home
Office portal
Office desktop app
Delve
TeamsBing
SharePoint contentYesYesYes
Teams contentYesYesYesYes
Teams chats(*1)YesYes
Yammer contentYesYesYes
Yammer chat(*1)Yes
User profilesYesYes
Email
(*1) Microsoft announced they are working on bringing conversations (both Teams chats and Yammer) to SharePoint landing page first, then to Office home page.

Detailed:

ScopeOut of Scope
SharePoint Search Center– all sites content
(Teams, Yammer, regular),
– user profiles
– OneDrive
Teams chat
Yammer chat
SharePoint Landing Pagesame as SharePoint Search center
but Teams chats and Yammer Conversations are coming
same as SharePoint Search Center
Office.comsame as SharePoint
(Teams chats and Yammer Conversations are coming after SharePoint)
same as SharePoint
Delve
TeamsTeams content
Teams chat
OneDrive
Yammer
User Profiles
regular SharePoint sites
BingEverything* * except people profiles content
(e.g. about me)

Seems like the only tool you can search for EVERYTHING with is Microsoft Bing:

Update: there are rumors that Microsoft is decommissioning work search in Bing… Pity… But something tells me that decomm is due to lack of usage/popularity, so Microsoft will introduce something similar…

After Microsoft add Teams chats and Yammer conversations to SharePoint landing page search scope (then to Office home page) – it’ll be the best place to search from for everything.

More on Microsoft Search vs SharePoint Search and Microsoft Search RoadMap

Microsoft Office 365 Search: Find what you need with Microsoft Search in Bing

It is possible customize Modern Microsoft Search pages with PnP Modern Search

Microsoft Volume Licensing Programs

ΠšΠΎΡ€ΠΏΠΎΡ€Π°Ρ‚ΠΈΠ²Π½Ρ‹Π΅ Π»ΠΈΡ†Π΅Π½Π·ΠΈΠΈ – это самый ΡƒΠ΄ΠΎΠ±Π½Ρ‹ΠΉ для ΠΎΡ€Π³Π°Π½ΠΈΠ·Π°Ρ†ΠΈΠΉ способ лицСнзирования ΠΏΡ€ΠΎΠ΄ΡƒΠΊΡ‚ΠΎΠ² Microsoft.

ΠšΠžΠ ΠŸΠžΠ ΠΠ’Π˜Π’ΠΠ«Π• Π›Π˜Π¦Π•ΠΠ—Π˜Π˜
Π­Ρ‚ΠΎ ΠΈΠΌΠ΅Π½Π½Ρ‹Π΅, Π½Π΅ΠΏΠ΅Ρ€Π΅Π΄Π°Π²Π°Π΅ΠΌΡ‹Π΅, Π½Π΅ΠΈΡΠΊΠ»ΡŽΡ‡ΠΈΡ‚Π΅Π»ΡŒΠ½Ρ‹Π΅ Π»ΠΈΡ†Π΅Π½Π·ΠΈΠΈ, ΠΊΠΎΡ‚ΠΎΡ€Ρ‹Π΅ Π²Ρ‹ΠΏΡƒΡΠΊΠ°ΡŽΡ‚ΡΡ ΠΊΠΎΠΌΠΏΠ°Π½ΠΈΠ΅ΠΉ Microsoft ΠΈΠ½Π΄ΠΈΠ²ΠΈΠ΄ΡƒΠ°Π»ΡŒΠ½ΠΎ для ΠΊΠ°ΠΆΠ΄ΠΎΠ³ΠΎ ΠΊΠ»ΠΈΠ΅Π½Ρ‚Π°.
ΠŸΠΎΡΡ‚Π°Π²Π»ΡΡŽΡ‚ΡΡ Π² Π²ΠΈΠ΄Π΅ Π·Π°ΠΏΠ΅Ρ‡Π°Ρ‚Π°Π½Π½ΠΎΠ³ΠΎ ΠΊΠΎΠ½Π²Π΅Ρ€Ρ‚Π°, Π² ΠΊΠΎΡ‚ΠΎΡ€ΠΎΠΌ находится Π΄ΠΎΠΊΡƒΠΌΠ΅Π½Ρ‚ с ΡƒΠΊΠ°Π·Π°Π½ΠΈΠ΅ΠΌ наимСнования ΠΊΠΎΠΌΠΏΠ°Π½ΠΈΠΈ-обладатСля Π»ΠΈΡ†Π΅Π½Π·ΠΈΠΈ, списка Π»ΠΈΡ†Π΅Π½Π·ΠΈΡ€ΠΎΠ²Π°Π½Π½Ρ‹Ρ… ΠΏΡ€ΠΎΠ΄ΡƒΠΊΡ‚ΠΎΠ² ΠΈ Π΄Ρ€ΡƒΠ³ΠΈΡ… Ρ€Π΅ΠΊΠ²ΠΈΠ·ΠΈΡ‚ΠΎΠ². Π‘Ρ€ΠΎΠΊ поставки элСктронных ΠΊΠ»ΡŽΡ‡Π΅ΠΉ составляСт 2-5 Π΄Π½Π΅ΠΉ, Π»ΠΈΡ†Π΅Π½Π·ΠΈΠΉ Π² Π±ΡƒΠΌΠ°ΠΆΠ½ΠΎΠΌ Π²ΠΈΠ΄Π΅ – 7-10 Π΄Π½Π΅ΠΉ.

VLSC (VOLUME LICENSING SERVICE CENTER)
Π‘ практичСской Ρ‚ΠΎΡ‡ΠΊΠΈ зрСния Π±ΠΎΠ»ΡŒΡˆΡƒΡŽ Ρ†Π΅Π½Π½ΠΎΡΡ‚ΡŒ прСдставляСт доступ ΠΊ сайту VLSC – Volume Licensing Service Center. ΠŸΡ€ΠΈ ΠΏΠΎΠΊΡƒΠΏΠΊΠ΅ ΠΊΠΎΡ€ΠΏΠΎΡ€Π°Ρ‚ΠΈΠ²Π½Ρ‹Ρ… Π»ΠΈΡ†Π΅Π½Π·ΠΈΠΉ Microsoft ΠΊΠ»ΠΈΠ΅Π½Ρ‚ ΠΏΠΎΠ»ΡƒΡ‡Π°Π΅Ρ‚ доступ Ρ‡Π΅Ρ€Π΅Π· этот сайт ΠΊ дистрибутивам ΠΏΡ€ΠΎΠ΄ΡƒΠΊΡ‚ΠΎΠ² ΠΈ ΠΈΡ… ΠΊΠ»ΡŽΡ‡Π°ΠΌ. Доступ ΠΊ сайту открываСтся ΠΎΠ±Ρ‹Ρ‡Π½ΠΎ Π² Ρ‚Π΅Ρ‡Π΅Π½ΠΈΠ΅ 2-3 Π΄Π½Π΅ΠΉ послС ΠΏΠΎΠΊΡƒΠΏΠΊΠΈ. Доступ ΠΊ сайту VLSC сначала прСдоставляСтся сотруднику, ΠΊΠΎΡ‚ΠΎΡ€Ρ‹ΠΉ ΠΎΡ‚Π²Π΅Ρ‡Π°Π΅Ρ‚ Π·Π° Π»ΠΈΡ†Π΅Π½Π·ΠΈΡ€ΠΎΠ²Π°Π½ΠΈΠ΅ (Π½Π°ΠΏΡ€ΠΈΠΌΠ΅Ρ€, систСмный администратор ΠΈΠ»ΠΈ ΡŽΡ€ΠΈΡΡ‚), ΠΏΠΎΠ·ΠΆΠ΅ ΠΎΠ½ ΠΌΠΎΠΆΠ΅Ρ‚ ΠΏΡ€Π΅Π΄ΠΎΡΡ‚Π°Π²ΠΈΡ‚ΡŒ доступ ΠΈ Π΄Ρ€ΡƒΠ³ΠΈΠΌ сотрудникам ΠΎΡ€Π³Π°Π½ΠΈΠ·Π°Ρ†ΠΈΠΈ.

По ΠšΠΎΡ€ΠΏΠΎΡ€Π°Ρ‚ΠΈΠ²Π½Ρ‹ΠΌ лицСнзиям ΠΌΠΎΠΆΠ½ΠΎ ΠΊΡƒΠΏΠΈΡ‚ΡŒ Ρ‚ΠΎΠ»ΡŒΠΊΠΎ Π°ΠΊΡ‚ΡƒΠ°Π»ΡŒΠ½ΡƒΡŽ Π½Π° Ρ‚Π΅ΠΊΡƒΡ‰ΠΈΠΉ ΠΌΠΎΠΌΠ΅Π½Ρ‚ Π²Π΅Ρ€ΡΠΈΡŽ ΠΏΡ€ΠΎΠ΄ΡƒΠΊΡ‚Π° (Π½Π°ΠΏΡ€ΠΈΠΌΠ΅Ρ€, Windows 10, Windows Server 2019, SharePoint 2019), Π½ΠΎ корпоративная лицСнзия ΠΎΠ±Ρ‹Ρ‡Π½ΠΎ Π²ΠΊΠ»ΡŽΡ‡Π°Π΅Ρ‚ ΠΏΡ€Π°Π²ΠΎ Downgrade, Ρ‚.Π΅. Π²ΠΎΠ·ΠΌΠΎΠΆΠ½ΠΎΡΡ‚ΡŒ ΠΏΠΎΠ»ΡŒΠ·ΠΎΠ²Π°Ρ‚ΡŒΡΡ ΠΏΡ€Π΅Π΄Ρ‹Π΄ΡƒΡ‰ΠΈΠΌΠΈ вСрсиями ΠΏΡ€ΠΎΠ΄ΡƒΠΊΡ‚Π°.
Дистрибутивы ΠΈ ΠΊΠ»ΡŽΡ‡ΠΈ ΠΊ ΠΏΡ€Π΅Π΄Ρ‹Π΄ΡƒΡ‰ΠΈΠΌ вСрсиям Ρ‚Π°ΠΊΠΆΠ΅ доступны Π½Π° VLSC.

Π’ΠΈΠ΄Ρ‹ ΠΊΠΎΡ€ΠΏΠΎΡ€Π°Ρ‚ΠΈΠ²Π½ΠΎΠ³ΠΎ лицСнзирования
Open License (OLP) – простой Π²Ρ‹ΠΊΡƒΠΏ Π»ΠΈΡ†Π΅Π½Π·ΠΈΠΉ Π½Π° ΠΊΠΎΠ½ΠΊΡ€Π΅Ρ‚Π½Ρ‹Π΅ ΠΏΡ€ΠΎΠ΄ΡƒΠΊΡ‚Ρ‹ Π² ΡΠΎΠ±ΡΡ‚Π²Π΅Π½Π½ΠΎΡΡ‚ΡŒ:
– МоТно ΠΊΡƒΠΏΠΈΡ‚ΡŒ ΡΡ‚ΠΎΠ»ΡŒΠΊΠΎ Π»ΠΈΡ†Π΅Π½Π·ΠΈΠΉ, сколько Π½Π°Π΄ΠΎ, Π½ΠΎ ΠΎΠ±Ρ‹Ρ‡Π½ΠΎ Π½Π΅ ΠΌΠ΅Π½Π΅Π΅ 5 ΡˆΡ‚. Π² ΠΏΠ΅Ρ€Π²ΠΎΠΌ Π·Π°ΠΊΡƒΠΏΠ΅ (Π² дальнСйшСм ΠΎΡ‚ 1 ΡˆΡ‚.)

Open Value (OV) – Π²Ρ‹ΠΊΡƒΠΏ Π»ΠΈΡ†Π΅Π½Π·ΠΈΠΉ Π² ΡΠΎΠ±ΡΡ‚Π²Π΅Π½Π½ΠΎΡΡ‚ΡŒ с ΠΎΠΏΠ»Π°Ρ‚ΠΎΠΉ Π² рассрочку Π½Π° 3 Π³ΠΎΠ΄Π°, Ρ€Π°Π²Π½ΠΎΠΌΠ΅Ρ€Π½Ρ‹ΠΌΠΈ ΠΏΠ»Π°Ρ‚Π΅ΠΆΠ°ΠΌΠΈ:
– Π¦Π΅Π½Π° Π²ΠΊΠ»ΡŽΡ‡Π°Π΅Ρ‚ SA, Π½ΠΎ Π² дальнСйшСм SA ΠΏΠΎΠΊΡƒΠΏΠ°Ρ‚ΡŒ Π½Π΅ ΠΎΠ±ΡΠ·Π°Ρ‚Π΅Π»ΡŒΠ½ΠΎ ( Ρ‚.Π΅. Π² ΠΏΠ΅Ρ€Π²Ρ‹Π΅ 3 Π³ΠΎΠ΄Π° SA ΠΎΠΏΠ»Π°Ρ‡Π΅Π½ΠΎ, Π΄Π°Π»Π΅Π΅ – опция )
– ΠΠ°Ρ‡Π°Π»ΡŒΠ½Ρ‹Π΅ Π·Π°Ρ‚Ρ€Π°Ρ‚Ρ‹ Π½ΠΈΠΆΠ΅, Ρ‡Π΅ΠΌ Ρƒ OLP
– Π•ΡΡ‚ΡŒ скидки Β«Π·Π° ΡΡ‚Π°Π½Π΄Π°Ρ€Ρ‚ΠΈΠ·Π°Ρ†ΠΈΡŽΒ», Ρ‚.Π΅. ΠΏΡ€ΠΈ ΠΏΠΎΠΊΡƒΠΏΠΊΠ΅ Π»ΠΈΡ†Π΅Π½Π·ΠΈΠΉ Π½Π° вСсь ΠΏΠ°Ρ€ΠΊ ПК – Ρ†Π΅Π½Ρ‹ Π½ΠΈΠΆΠ΅

Open Value Subscription (OVS) – Π°Ρ€Π΅Π½Π΄Π° Π»ΠΈΡ†Π΅Π½Π·ΠΈΠΉ с Π΅ΠΆΠ΅Π³ΠΎΠ΄Π½ΠΎΠΉ ΠΎΠΏΠ»Π°Ρ‚ΠΎΠΉ (подписка Π½Π° Π»ΠΈΡ†Π΅Π½Π·ΠΈΠΈ):
– ΠœΠΈΠ½ΠΈΠΌΠ°Π»ΡŒΠ½Ρ‹Π΅ Π½Π°Ρ‡Π°Π»ΡŒΠ½Ρ‹Π΅ Π·Π°Ρ‚Ρ€Π°Ρ‚Ρ‹
– ΠŸΡ€Π°Π²ΠΎ ΠΏΠΎΠ»ΡŒΠ·ΠΎΠ²Π°Ρ‚ΡŒΡΡ всСгда самыми послСдними вСрсиями ПО ( Ρ‚.Π΅. SA всСгда Π²Ρ…ΠΎΠ΄ΠΈΡ‚ Π² Ρ†Π΅Π½Ρƒ )
– МоТно ΡƒΠ²Π΅Π»ΠΈΡ‡ΠΈΠ²Π°Ρ‚ΡŒ количСство Π»ΠΈΡ†Π΅Π½Π·ΠΈΠΉ, ΡƒΠΌΠ΅Π½ΡŒΡˆΠ°Ρ‚ΡŒ ΠΈΠ»ΠΈ ΠΎΡ‚ΠΊΠ°Π·Ρ‹Π²Π°Ρ‚ΡŒΡΡ ΠΎΡ‚ Π»ΠΈΡ†Π΅Π½Π·ΠΈΠΉ Π² зависимости ΠΎΡ‚ потрСбностСй
– ΠžΠΏΠ»Π°Ρ‚Π° происходит Ρ€Π°Π· Π² Π³ΠΎΠ΄ – Π½Π°Π΄ΠΎ просто ΠΏΠΎΡΡ‡ΠΈΡ‚Π°Ρ‚ΡŒ количСство ΠΈΡΠΏΠΎΠ»ΡŒΠ·ΡƒΠ΅ΠΌΡ‹Ρ… Π»ΠΈΡ†Π΅Π½Π·ΠΈΠΉ ΠΈ ΠΎΠΏΠ»Π°Ρ‚ΠΈΡ‚ΡŒ ΠΈΡ…. ΠŸΡ€ΠΈ этом, Π½Π°ΠΏΡ€ΠΈΠΌΠ΅Ρ€, вновь ΠΊΡƒΠΏΠ»Π΅Π½Π½Ρ‹Π΅ Π² Ρ‚Π΅Ρ‡Π΅Π½ΠΈΠ΅ Π³ΠΎΠ΄Π° ΠΊΠΎΠΌΠΏΡŒΡŽΡ‚Π΅Ρ€Ρ‹ Ρ‚ΠΎΠΆΠ΅ Π±ΡƒΠ΄ΡƒΡ‚ ΡΡ‡ΠΈΡ‚Π°Ρ‚ΡŒΡΡ Π»ΠΈΡ†Π΅Π½Π·ΠΈΡ€ΠΎΠ²Π°Π½Π½Ρ‹ΠΌΠΈ. Π•ΡΡ‚ΡŒ ΠΏΡ€ΠΎΠ΄ΡƒΠΊΡ‚Ρ‹ ΠΏΠΎ ΠΊΠΎΡ‚ΠΎΡ€Ρ‹ΠΌ
– Π’ΠΎΠ·ΠΌΠΎΠΆΠ΅Π½ Π²Ρ‹ΠΊΡƒΠΏ Π»ΠΈΡ†Π΅Π½Π·ΠΈΠΉ Π² постоянноС пользованиС ΠΏΠΎ истСчСнии 3-Ρ… Π»Π΅Ρ‚ Π°Ρ€Π΅Π½Π΄Ρ‹
– ВрСбуСтся β€œΡΡ‚Π°Π½Π΄Π°Ρ€Ρ‚ΠΈΠ·Π°Ρ†ΠΈΡβ€, Ρ‚.Π΅. Π»ΠΈΡ†Π΅Π½Π·ΠΈΡ€ΠΎΠ²Π°Π½ΠΈΠ΅ всСх ПК ( Windows ΠΈΠ»ΠΈ CAL ΠΈΠ»ΠΈ Office )

ЧВО Π’ΠΠšΠžΠ• SA
SA – Software Assurance. ΠšΡƒΠΏΠΈΠ² ΠΊ ΠΏΡ€ΠΎΠ΄ΡƒΠΊΡ‚Ρƒ SA, ΠΊΠ»ΠΈΠ΅Π½Ρ‚ ΠΏΠΎΠ»ΡƒΡ‡Π°Π΅Ρ‚ Π²ΠΎΠ·ΠΌΠΎΠΆΠ½ΠΎΡΡ‚ΡŒ ΠΈΡΠΏΠΎΠ»ΡŒΠ·ΠΎΠ²Π°Ρ‚ΡŒ всС Π½ΠΎΠ²Ρ‹Π΅ вСрсии ΠΏΡ€ΠΎΠ΄ΡƒΠΊΡ‚Π°, выпускаСмыС Π² Ρ‚Π΅Ρ‡Π΅Π½ΠΈΠ΅ дСйствия подписки. А Ρ‚Π°ΠΊΠΆΠ΅ для Π½Π΅ΠΊΠΎΡ‚ΠΎΡ€Ρ‹ΠΉ ΠΏΡ€ΠΎΠ΄ΡƒΠΊΡ‚ΠΎΠ² ряд Π΄ΠΎΠΏΠΎΠ»Π½ΠΈΡ‚Π΅Π»ΡŒΠ½Ρ‹Ρ… прСимущСств, Ρ‚Π°ΠΊΠΈΡ… ΠΊΠ°ΠΊ ΠΏΡ€Π°Π²ΠΎ Π½Π° использованиС Π²Ρ‚ΠΎΡ€ΠΎΠΉ ΠΊΠΎΠΏΠΈΠΈ Π½Π° Π»ΠΈΡ‡Π½ΠΎΠΌ домашнСм ΠΊΠΎΠΌΠΏΡŒΡŽΡ‚Π΅Ρ€Π΅, ΠΏΡ€Π°Π²ΠΎ использования ПО Π² Π²ΠΈΡ€Ρ‚ΡƒΠ°Π»ΡŒΠ½ΠΎΠΉ срСдС, ΠΏΡ€Π°Π²ΠΎ пСрСноса Π»ΠΈΡ†Π΅Π½Π·ΠΈΠΉ Π² частноС ΠΈΠ»ΠΈ ΠΏΡƒΠ±Π»ΠΈΡ‡Π½ΠΎΠ΅ ΠΎΠ±Π»Π°ΠΊΠΎ ΠΈ Ρ‚.ΠΏ.
SA продаётся ΠΊΠ°ΠΊ подписка, Ρ‚.Π΅. Π½Π° ΠΎΠ³Ρ€Π°Π½ΠΈΡ‡Π΅Π½Π½Ρ‹ΠΉ срок (2-3Π³ΠΎΠ΄Π°), ΠΊΠΎΡ‚ΠΎΡ€Ρ‹ΠΉ ΠΌΠΎΠΆΠ½ΠΎ постоянно ΠΏΡ€ΠΎΠ΄Π»Π΅Π²Π°Ρ‚ΡŒ.

Open Licensing programs Ρ…ΠΎΡ€ΠΎΡˆΠΎ подходят организациям ΠΎΡ‚ 5 Π΄ΠΎ 250 сотрудников.
МСнСС 5 сотрудников – ΠΏΡ€ΠΎΡ‰Π΅ ΠΊΡƒΠΏΠΈΡ‚ΡŒ “ΠΊΠΎΡ€ΠΎΠ±ΠΊΠΈ” – box/retail вСрсии ΠΏΡ€ΠΎΠ΄ΡƒΠΊΡ‚ΠΎΠ².
Π‘ΠΎΠ»Π΅Π΅ 250 сотрудников – организация ΠΈΠΌΠ΅Π΅Ρ‚ ΠΏΡ€Π°Π²ΠΎ Π½Π° EA – Enterprise Agreement.

ΠŸΠΎΠ΄Ρ€ΠΎΠ±Π½Π΅Π΅ ΠΎΠ± Open Programs Π½Π° сайтС Microsoft:
What are the Microsoft Open Programs?

ΠšΠ°ΠΊΡƒΡŽ ΠΏΠΎΠΌΠΎΡ‰ΡŒ ΠΎΠΊΠ°Π·Ρ‹Π²Π°ΡŽΡ‚ ΠΏΠ°Ρ€Ρ‚Π½Ρ‘Ρ€Ρ‹ Microsoft ΠΏΠΎ Π»ΠΈΡ†Π΅Π½Π·ΠΈΡ€ΠΎΠ²Π°Π½ΠΈΡŽ:
Support Provided by Licensing Solution Partners

Microsoft Licensing

Как ΠΊΡƒΠΏΠΈΡ‚ΡŒ Microsoft

  • Office Suite (Word, Excel, PowerPoint)
  • Office 365 (SharePoint, Teams, Exchange etc.)
  • Azure cloud subscription

Option 1: прямо Π½Π° сайтС Microsoft :
Office 365 for Home
Office 365 for Business
Azure subscription (Π½Π°Ρ‡Π°Ρ‚ΡŒ бСсплатно)

Option 2: Ρ‡Π΅Ρ€Π΅Π· ΠΏΠ°Ρ€Ρ‚Π½Ρ‘Ρ€ΠΎΠ² Microsoft :
Find a Microsoft Solution provider
Top 200 Partners

SharePoint PnP roadmap

Good news!
On Sep, 18 during the SIG community call, PnP Team shared their plans on PnP Sites Core library and PnP Core SDK.
“PnP Sites Core v4” library and “PnP Core SDK v1” with .net core support (.net Standard 2.0) – expected in December 2020!

PnP PowerShell v4 for SPO library built for .Net Standard 2.0 / PowerShell 7 will be released in Dec 2020 as well.

How to delete a large SPO list or all/some items in a large SPO list

Scenario: You have a large (>5k items) list in SharePoint Online you need to clean-up, for instance:

  • You need to delete the entire list
  • You need to delete all the list items, but keep the list
  • You need to delete some of list items, but keep the others

Deleting a large SharePoint Online list

There was a problem in SharePoint Online – you could not delete a large list – you had to remove all items first, but removing all items was also a challenge. Microsoft improved SharePoint Online, so now it takes ~1 second to delete any SharePoint list, including 5000+ items list via GUI or PowerShell:

Remove-PnPList -Identity $list

command works very fast – ~1 second to delete entire list with >5000 items.

Delete all items in a large SharePoint Online list

In this scenario we need to keep the list, but make it empty (clean it up).

GUI: You can change the list view settings “Item Limit” to <5000 and try to delete items in chunks, but (at least in my experience) when you try to select, let say, 1000 items and delete them via GUI – it says “775 items were not deleted from large list”:

so this option seems like not a good one.

ShareGate: 3-rd party tools like Sharegate, SysKit give a good results too.

PowerShell

Try this PowerShell command with ScriptBlock:

Get-PnPListItem -List $list -Fields "ID" -PageSize 100 -ScriptBlock { Param($items) $items | Sort-Object -Property Id -Descending | ForEach-Object{ $_.DeleteObject() } } 

or this PowerShell with batches:

$batch = New-PnPBatch
1..12000 | Foreach-Object { Remove-PnPListItem -List $list -Identity $_ -Batch $batch }
Invoke-PnPBatch -Batch $batch

for me both methods gave same good result: ~17 items per second ( ~7 times faster than regular).

Deleting some items from a large SPO list

Consider the following scenario: in a large SharePoint list there are items you need to delete and the rest items must stay (typical case might be to purge old items – e.g. items created last year).

In this case you’d

  • get all list items (or use query to get some list items)
  • select items that need to be deleted based on your criteria, e.g. created date or last modified date etc.
  • use PnP.PowerShell batches to delete only what you need
# to get all list items
$listItems = Get-PnPListItem -List Tasks -PageSize 1000
# or to get some list items 
$listItems = Get-PnPListItem -List Tasks -Query <query>
# select items to delete
$itemsToDelete = $listItems | ?{$_.Modified -lt $threshold}
# delete some list items
$batch = New-PnPBatch 
$itemsToDelete | Foreach-Object { Remove-PnPListItem -List $list -Identity $_ -Batch $batch } 
Invoke-PnPBatch -Batch $batch

PnP.PowerShell batch vs ScriptBlock

How fast are PnP batches? What is better in terms of performance – ScriptBlock or Batching? Here are my measurements:

Time elapsed, secondswith batcheswith scriptBlockwithout batches
Add-PnPListItem (100 items)6-10 seconds60-120 seconds
Add-PnPListItem (500 items)20-40 seconds230-600 seconds
Add-PnPListItem (7000 items)314-600 seconds
Add-PnPListItem (37000 items)3200 seconds
Remove-PnPListItem (1000 items)58-103 seconds58 seconds430-1060 seconds
Remove-PnPListItem (7000 items)395-990 seconds
3000 seconds
397-980 seconds
Remove-PnPListItem (30000 items)one big batch : 13600 seconds
30 batches 1000 items each: 3500 seconds

both – PnP PowerShell batches and ScriptBlocks are 7-10 times faster than plain PnP PowerShell!

Can we use Microsoft Graph API to complete the same task? TBC…

Note… For the sake of history: It used to be like that for 5k+ lists:
“Remove-PnPList” fails with a message “The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator”. Deleting with GUI failed too.

References: