Microsoft's Graph API has endpoints for [SharePoint Online] lists and libraries. Worthy of note, document libraries are /drives when using the APIs. And although libraries are technically lists, the two resources will return different properties for the same SharePoint object. Additionally, some actions can only be performed using the /lists resources. An example of this, … Continue reading SharePoint Online: File Metadata w/ Graph API
PowerShell
Azure Runbook: Task Logging
PowerShell is a scripting language great for task automation. The framework has gone through a number of iterations and Microsoft supports it in Azure. These cloud-hosted scripts are created as Azure Runbooks. Contrasted against the PowerShell ISE and Visual Studio Code, there are some logging differences with Runbooks. Locally run scripts typically write their logs … Continue reading Azure Runbook: Task Logging
SharePoint Server: Purge Cached Access
As content is migrated from [SharePoint Server] to [SharePoint Online], the sites are often moved incrementally. But post-migration, not everyone uses their new links day-one. There are enough people still trying to use their old SPS bookmarks, so I needed to purge legacy site access. This includes the site collection user cache and forces everyone … Continue reading SharePoint Server: Purge Cached Access
OneDrive: Hidden List (SharePoint Home Cache List – Part II)
The series has finally reached a conclusion. The final list, SharePointHomeCacheList, had so many items that it was divided into two posts. Part I spotlighted 3 list items and Part II will cover two additional items... E.g., export of list object in PowerShell ISE. Get target items $api = "/sites/$($siteGuid)/lists/$($listGuid)/items" $api += "?expand=fields" $lst1 = … Continue reading OneDrive: Hidden List (SharePoint Home Cache List – Part II)
OneDrive: Hidden List (SharePoint Home Cache List)
Auditing [OneDrive for Business] sites with PowerShell and the Microsoft Graph API uncovered several hidden lists. The SharePointHomeCacheList is one of these lists, but it offers more information than the previously discussed lists. Continuing the trend of examination: Create script variables. [System.String] $endUserAccount = "charles@contoso.com" $endUserAccount = $endUserAccount.Replace("@", "_").Replace(".", "_") [System.String] $tenantName = "contoso" [System.String] … Continue reading OneDrive: Hidden List (SharePoint Home Cache List)
OneDrive: Hidden List (Access Requests)
So yeah, this was an unintentional blog series. Welcome to part 4 out of #shrugs because there were more hidden lists than expected... But this time, there's a "request" to audit access requests of an individual's [OneDrive for Business] account. E.g., a PDF was shared with an external collaborator. Create the script variables. [System.String] $endUserAccount … Continue reading OneDrive: Hidden List (Access Requests)
OneDrive: Hidden List (Notifications)
[OneDrive for Business] sites are [SharePoint Online] site collections. Because of this, the ODfB sites have hidden lists which are discoverable using scripted solutions. Another of these hidden lists track user notifications. The Microsoft Graph API is again capable of querying the list and its items for reporting... E.g., list user notification types. To begin, … Continue reading OneDrive: Hidden List (Notifications)
OneDrive: Hidden List (User Activity)
[OneDrive for Business] sites are [SharePoint Online] site collections. Because of this, ODfB sites have hidden lists which are discoverable using scripted solutions. One of these hidden lists is tasked with tracking user activity. The Microsoft Graph API is again helpful to query these hidden list records for reporting... E.g., instances of user comments. To … Continue reading OneDrive: Hidden List (User Activity)
OneDrive: Hidden List (Sharing Links)
[OneDrive for Business] accounts are essentially [SharePoint Online] site collections. Because of this, ODfB sites also have several hidden lists that are discoverable with scripted solutions. One hidden list is titled Sharing Links and it keeps a record of shared items. Though the Microsoft 365 Admin center has a nice OneDrive activity report, custom solutions … Continue reading OneDrive: Hidden List (Sharing Links)
Graph API: Query Teams Provisioned SPO Sites
Usage of Microsoft Teams boomed under COVID-19 shelter in place orders. For organizations with Office 365 licenses, Teams facilitated remote collaboration, but each newly created team provisions a [SharePoint Online] site collection. Post-quarantine, organizations may want to audit their Teams' provisioned SPO sites. And if end-users aren't restricted from creating teams, then there will be … Continue reading Graph API: Query Teams Provisioned SPO Sites
Batching w/ Microsoft Graph API – Part II
Batching w/ Microsoft Graph API - Part I used the Microsoft batch example as a guide, but their example created a folder in my [OneDrive for Business] account. Instead, I wanted to target a [SharePoint Online] site. And to specify which SPO site, the API requires the site ID... FYI, the Graph API site search … Continue reading Batching w/ Microsoft Graph API – Part II
Microsoft Ignite 2019 – Recap
Microsoft just hosted Ignite 2019 in Orlando, FL. This was my first year attending and there was more than enough content. It's impossible to recap it all because it was impossible for me see everything: 25,000+ attendees 1,000+ sessions 300+ sponsors 200+ hands-on experiences I mean WHOA! Microsoft mission:"Empower every person and every organization on … Continue reading Microsoft Ignite 2019 – Recap
SharePoint Online: External Sharing Audit (Option. II)
I recently wrote about external sharing in SPO. If you externally share content, then you may need to audit external accounts in your tenant. Note: Your tenant must allow external sharing. The Microsoft 365 Admin Center is your first resource to audit and report these external accounts. Secondly, you can use PowerShell to audit specified … Continue reading SharePoint Online: External Sharing Audit (Option. II)
console.log('Charles'); 