The story in short: one of my customers asked me if it is possible to generate a report on all content in Office365 shared externally. Doing some searches I found the following solutions:– Run the sharing reports on each site and each OneDrive (link, link)– Run reports based on audit logs (link) While these reports […]
All posts in category PowerShell
SharePoint Online external file sharing report using Graph API and PowerShell
Posted by Daniel Kovacs on March 13, 2023
https://f12.hu/2023/03/13/sharepoint-online-file-sharing-report-using-graph-api-and-powershell/
Conditional Access policies – do you backup them ALL?
This will be a short post about a recent finding: AzureAD Conditional Access policies created from template may miss from your backups if not using Graph API beta endpoint. TL;DR– When you create a Conditional Access policy using the “New policy from template (Preview)” button, the policy will not show when querying policies using the […]
Posted by Daniel Kovacs on February 28, 2023
https://f12.hu/2023/02/28/conditional-access-policies-do-you-backup-them-all/
Monitor AzureAD App registration expiration with PowerShell (GraphAPI)
There are several methods for monitoring Azure AD App registration expiration (like PowerAutomate or Azure Logic Apps) but these methods require extra licences or an Azure subscription. The PowerShell way is free and it only requires a new registration in AzureAD. TL;DR The script:
Posted by Daniel Kovacs on January 29, 2023
https://f12.hu/2023/01/29/monitor-azuread-app-registration-expiration-with-powershell-graphapi/
Backup AzureAD Conditional Access Policies v2 – Graph API
AzureAD Powershell is planned for deprecation (link) so I redesigned my Conditional Access Policy Backup solution originally posted here. This v2 edition uses an AzureAD app registration for unattended access (eg. scheduled script) and the Microsoft Graph API (but not the Microsoft Graph PowerShell module). The idea and the logic is the same as in […]
Posted by Daniel Kovacs on January 13, 2023
https://f12.hu/2023/01/13/backup-azuread-conditional-access-policies-v2-graph-api/
Monitor AzureAD Conditional Access Policy changes with PowerShell (Scheduled Script)
When there are multiple administrators in an AzureAD tenant, it is inevitable that one may change settings in Conditional Access policies – without notifying everyone involved. To keep track of changes you could regualarly check the AzureAD audit logs, or have an automation for it. I may be a bit old-fashioned, but I prefer to […]
Posted by Daniel Kovacs on May 31, 2022
https://f12.hu/2022/05/31/monitor-azuread-conditional-access-policy-changes-with-powershell-scheduled-script/
Check if IP address is already an AzureAD Named Location using PowerShell
In a large corporate environment, it’s not unusual to have several Azure AD Named Locations (should it be trusted or not). It is even more challenging to keep track of these locations when there are several admins managing the environment. I thought it would be useful to have a script to determine if an IP […]
Posted by Daniel Kovacs on March 1, 2022
https://f12.hu/2022/03/01/check-if-ip-address-is-already-an-azuread-named-location-using-powershell/
Backup AzureAD Conditional Access Policies – a different approach
Update: as the AzureAD PowerShell is being deprecated, I made an updated version which can be found here Backing up AAD Conditional Access policies is relatively straightforward with Get-AzureADMSConditionalAccessPolicy cmdlet (don’t forget to update your AzureAD module if the cmdlet is not recognized). In this post, I want to share my own backup “solution” which […]
Posted by Daniel Kovacs on January 27, 2021
https://f12.hu/2021/01/27/backup-azuread-conditional-access-policies-a-different-approach/
Querying AzureAD App registration credential expiration
Recently, I came across an interesting post on monitoring Azure AD App registration expiration – link here. I made a simplified version which only generates a report on the expiration date of each credential. TL;DRRunning the script below will list each credential for AzureAD app registrations sorted by expiration date. To run the script, ensure […]
Posted by Daniel Kovacs on December 14, 2020
https://f12.hu/2020/12/14/querying-azuread-app-registration-credential-expiration/
Bug in Get-AzureMSConditionalAccessPolicy cmdlet?
Recently, I found an excellent blogpost on how to back up AzureAD Conditional Access policies (link) using the new AzureAD PowerShell module and decided to create my own when I encountered a little bug… TL;DRInstead of using ToJson() method use ConvertTo-Json cmdlet on the objects returned by Get-AzureMSConditionalAccessPolicy. ExplainedI was trying to create my own […]
Posted by Daniel Kovacs on November 23, 2020
https://f12.hu/2020/11/23/bug-in-get-azuremsconditionalaccesspolicy-cmdlet/