Category: PowerShell

Cat Links Graph API, Microsoft 365, Office 365, PowerShell, SharePoint Online

Report on externally shared files in Microsoft 365 via the Graph API

Posted on Vasil Michev

An updated version of my “proof of concept” script to report on any and all externally shared files within the organization. This new version covers SharePoint Online sites as well and can also process individual sites via the -Sites parameter. The output has been reworked and now uses the ImportExcel module to generate a “pretty” Excel file with conditional formatting and clickable links. In addition, I’ve toyed with another version of the script that enumerates lists and list items, as opposed to the “classic” one that enumerates drives and processes them much like a traditional folder structure. Both versions should give you the same set of results, but can differ in performance and throttling aspect… …

Continue readingReport on externally shared files in Microsoft 365 via the Graph API

Cat Links Entra ID, Graph API, Microsoft 365, Office 365, PowerShell

How to properly filter for specific enabled services via the Graph API/SDK

Posted on Vasil Michev

The limited (and convoluted) filter capabilities of the Graph API have lead to scenarios where people are using incorrect queries to filter out the set of users enabled for specific Microsoft 365 service(s). In this article, we will go over some of the common mistakes I’ve seen in online examples, and provide you with a “proper” solution, to the best of the current Graph API filtering capabilities. …

Continue readingHow to properly filter for specific enabled services via the Graph API/SDK

Cat Links Graph API, Microsoft 365, Office 365, PowerShell

How to fetch data for reports Microsoft is yet to provide Graph API endpoints for

Posted on Vasil Michev

As Microsoft is yet to provide Graph API endpoints for access to all of the Microsoft 365 reports, in this article we examine a workaround that allows you to fetch the same data by alternative means. As an added bonus, this method allows you to also fetch data for some reports that are not even exposed in the UI yet! …

Continue readingHow to fetch data for reports Microsoft is yet to provide Graph API endpoints for

Cat Links Azure AD, Entra ID, Graph API, Microsoft 365, Office 365, PowerShell

How to add, remove or update Entra ID delegate permissions for specific users

Posted on Vasil Michev

In this article, we will detail how to manage delegate permissions (OAuth2PermissionGrant) for any Entra ID integrated application on a per-user basis via the Graph API or the Graph SDK for PowerShell. With this knowledge at hand, you should never have to add tenant-wide consents again! …

Continue readingHow to add, remove or update Entra ID delegate permissions for specific users