How to report Azure Admin Roles granted with PowerShell into CSV

Report of all Azure Admin Roles granted with PowerShell into CSV. Leverages module AzureAD and only requires Azure AD reader.

Cheers

VIDEO

SCREENSHOT

SOURCE CODE

https://github.com/spjeff/office365/tree/master/Azure-Admin-Roles

REFERENCES

Query Azure AD (Connect-AzureAD) unattended with Azure App Registration certificate PFX

Demo showing how to query Azure AD in PowerShell. Walk each step with full PowerShell source code available.

  1. Execute “Connect-AzureAD” with admin user
  2. Create self signed certificate PFX for unattended login
  3. Create new App Registration
  4. Grant permission “User.ReadAll” to MS Graph API
  5. Execute “Connect-AzureAD” with unattended certificate PFX login
  6. Execute query “Get-AzureADUser” to display results

Please leave comment with suggestions and questions. Cheers.

SOURCE CODE

https://github.com/spjeff/spadmin/blob/master/Connect-AzureAD.ps1

VIDEO

REFERENCES

  • https://docs.microsoft.com/en-us/powershell/module/azuread/connect-azuread?view=azureadps-2.0
  • https://docs.microsoft.com/en-us/powershell/module/azuread/new-azureadapplicationkeycredential?view=azureadps-2.0
  • https://erjenrijnders.nl/2018/08/30/azuread-login-without-credentials-unattended/

Global Nav Bar for Classic JS and Modern SPFx (hosted SP2019 and SPO)

Full demo showing the source code and install process for Global Navigation bar across multiple site collections. Provide end users with facility to update central navigation with consistent display across many SharePoint site collections. Screenshots below with demo and full source code. Cheers.

  • Supports both Classic JS and Modern SPFx site templates
  • Supports SharePoint 2019+ with SPFx 1.4.1
  • Supports SharePoint Online (SPO)

GitHub Repo

Video

Screenshot

References

https://github.com/tom-daly/spfx-global-navigation

https://github.com/dcashpeterson/Public-Samples/tree/master/Code/GlobalNavSPFx/SPFx

https://www.youtube.com/watch?v=LlsAz99IViY

What’s in that patch? January 2022

NOTE – PDF format updated to include both SharePoint 2013, 2016, and 2019 notes. Ever wondered what fixes are inside of a given CU?   Please see attached PDF with full detail. I wanted a new format for easy reading.   Show management and make the business case for why downtime should be taken to apply CUs.  Also posted at https://sharepointupdates.com/ If you found this helpful, please leave a comment.    shades_smile_thumb_thumb_thumb_thumb[2]

Download

What’s in that patch – Jan 2022.PDF

What’s in that patch? December 2021

NOTE – PDF format updated to include both SharePoint 2013, 2016, and 2019 notes. Ever wondered what fixes are inside of a given CU?   Please see attached PDF with full detail. I wanted a new format for easy reading.   Show management and make the business case for why downtime should be taken to apply CUs.  Also posted at https://sharepointupdates.com/ If you found this helpful, please leave a comment.    shades_smile_thumb_thumb_thumb_thumb[2]

Download

What’s in that patch – Dec 2021.PDF

Power Platform Center Of Excellence (COE) step by step install

Wanted to record demo video showing step-by-step install and configuration for the Microsoft Center of Excellent (CoE) solution. Components include PowerApps, Flow, PowerBI, and more. Cheers.

Video

Screenshots

References

MS Teams – Clear Cache

Wanted to share automation to clear the Microsoft Teams desktop client folder and restart application. Might help when troubleshooting dropped calls, slow client, and performance issues. Cheers

Source Code

Screenshots

Microsoft Teams

References

VIDEO – Query Dataverse Tables With HTTP POST

Step-by-step live demo of how to create Azure App Registration and query Microsoft Dataverse tables over HTTP POST to the CRM Dynamics 365 endpoints. Key steps include:

  1. Create Azure App Registration with Client Secret
  2. Grant delegated Azure App API permission “Access Common Data Service as organization users”
  3. Grant same Azure App GUID permission in PowerApps Admin Center
  4. Grant “Service Reader” for target PowerApps Environment
  5. Execute login HTTP POST to gain “access_token”
  6. Execute query HTTP POST to gain JSON Dataverse table rows

Cheers

VIDEO

CODE

SCREENSHOTS

REFERENCES

Return to Top ▲Return to Top ▲