Azure AD sign-ins + powershell

Jeremy Stump 1 Reputation point
2021-02-23T15:23:03.947+00:00

We are a p1 shop, I want to Powershell every morning when I get to work for the previous 12 hours for the below information and want it neat in excel like it shows online with a few filters applied where you see =. Date - User - Application - Status=Success - IP address, Location=outside US My PS script is this far and just need some help to get it right please Get-AzureADAuditSignInLogs -Filter "createdDateTime gt 2021-02-22" | select userdisplayname, UserPrincipalName, IpAddress, ClientAppUsed, ResourceDisplayName | export-csv c:\temp\azure-ad-out-of-US-logins-$(get-date -f yyyy-MM-dd).csv -encoding ASCII –append

Microsoft Security | Microsoft Entra | Microsoft Entra ID

1 answer

Sort by: Most helpful
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    2 deleted comments

    Comments have been turned off. Learn more

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.