AzureAD
4 TopicsFind all the AzureADUsers created after a certain date via PowerShell Graph
Hello everyone, As Microsoft will eventually retire the AzureAD and MSOL PowerShell modules (March 2023?), I am trying to update all the PowerShell scripts based on those modules with new ones based on Microsoft Graph API calls and PowerShell Graph SDK. I am struggling with a script which should find all the AzureAD members created after 1 July 2022 inside a specific Security Group. The script should generate a list of these "new starters" and retrieve the following information: DisplayName, UPN, ID, Email, JobTitle. This is what I got so far: [datetime]$Date = (Get-Date).adddays(-60) $Users = Get-MgGroupMember -GroupId xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx -All $Users.Count $UsersCreatedDate = $Users.ForEach{ Get-MgUser -UserId $_.Id | Select-Object -Property Id, UserPrincipalName, JobTitle, CreatedDateTime } Getting all the users takes some time (we have around 400 members in that Security group), I am not sure if there is a quicker way to get those information. Then I tried to filter that list using the "where-object" $UsersCreatedDate | Where-Object {($_.CreatedDateTime -gt '$Date')} but to no avail. I am always getting the error Could not compare "06/20/2017 09:00:00" to "$DateTime". Error: "Cannot convert value "$DateTime" to type "System.DateTime". Error: "String was not recognized as a valid DateTime."" What am I doing wrong? Any help would be much appreciated! Many thanks in advance FrancescoSolved15KViews1like7CommentsLast Login dates for all Guests using PowerShell
So I need to be able to report on all guest accounts on my companies tenant, to see the last time they logged on. AzureADSignin Logs are no good as they only cover last 30 days, I know somewhere within Azure, I have found one guest account where the last login was during 2021, but I need to capture this for all guest accounts? Is this even possible? Thanks in advance for any help.Solved14KViews0likes3CommentsGet-AzureADUser using filter with -notlike
Hey, I am trying filter out Azure guest accounts which doesn't include public domain using following command but its not showing proper output. Its showing all guest accounts. Can someone please help here. Get-AzureADUser -Filter "UserType eq 'Guest' and AccountEnabled eq true" | Where-Object {$_.mail -notlike '*@hotmail.com' -or $_.mail -notlike '*@gmail.com' -or $_.mail -notlike '*@yahoo.com'}3.7KViews0likes1CommentReplacement cmdlets for Msol cmdlets for Mailbox Validation
Due to the looming deprecation of AzureAD and Msol cmdlets, I am trying to search for replacement Graph SDK cmdlets for the following cmdlets which is about showing the validation error of O365 mailbox. Get-MsolUser -UserPrincipalName $wsUserPrincipalName | Select-Object ValidationStatus (Get-MsolUser -UserPrincipalName $wsUserPrincipalName).errors[0].ErrorDetail.objecterrors.errorrecord.ErrorDescription Above please find an image showing the output of the 2 cmdlets. Thanks.Solved1.1KViews0likes2Comments