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)
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 (Recent Lists)
Another hidden list found, so onward to part 5 of the series... This might be a new-ish container, but it logs recently created [SharePoint Online] lists by a person so it gets audited: Create script variables. [System.String] $endUserAccount = "charles@contoso.com" $endUserAccount = $endUserAccount.Replace("@", "_").Replace(".", "_") [System.String] $tenantName = "contoso" [System.String] $requestAPI = "" [System.String] $siteGuid … Continue reading OneDrive: Hidden List (Recent Lists)
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)
Training Session: Graph API – OneDrive vs SharePoint
Microsoft has invested heavily into their Graph API which connects with the Office 365 services. The approach of old, CSOM, not so much as of late. But that makes sense considering the services are cloud-hosted. CSOM was perfect for solutions running on the application server, but [SharePoint Online] doesn't allow this. Going forward, the Graph … Continue reading Training Session: Graph API – OneDrive vs SharePoint
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
Deleting Private Channels in Microsoft Teams!
Private channels have been available in Teams for several months now. As a result, plenty of people have created plenty of private channels. Some were created accidentally and some were created for testing purposes. Either way, I've been asked to delete several of these channels... Fun fact #1: Creating a private channel in Microsoft Teams … Continue reading Deleting Private Channels in Microsoft Teams!
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'); 