Power shell script needed for azure ad guest accounts

jaikum2 · 2021-03-12T22:56:26.000Z

Hi
I’m looking for some power shell script to export all azure ad guest accounts that have not logged in from 60 days …

Neally · 2021-03-12T23:05:24.000Z

jaikum2:

Hi
I’m looking for some power shell script to export all azure ad guest accounts that have not logged in from 60 days …

We’re happy to help, but not a script writing service.

What have you tried? where are you stuck?

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don't say "Need help" or "PowerShell Help", actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy, past…

jaikum2 · 2021-03-12T23:21:52.000Z

$Guest = Read-Host “Enter name of guest account”
$Guests = Get-AzureADUser -SearchString $Guest
ForEach ($G in $Guests) {
If ($G.UserType -eq “Guest”) {
$UserLastLogonDate = $Null
Try {
$UserObjectId = $G.ObjectId
$UserLastLogonDate = (Get-AzureADAuditSignInLogs -Top 1 -Filter “userid eq ‘$UserObjectId’ and status/errorCode eq 0”).CreatedDateTime }
Catch {
Write-Host “Can’t read Azure Active Directory Sign in Logs” }
If ($UserLastLogonDate -ne $Null) {
$LastSignInDate = Get-Date($UserLastLogonDate); $Days = New-TimeSpan($LastSignInDate)
Write-Host “Guest” $G.DisplayName “last signed in on” $LastSignInDate “or” $Days.Days “days ago” }
Else { Write-Host “No Azure Active Directory sign-in data available for” $G.DisplayName “(” $G.Mail “)” }
}}

The above one works, but I need someone who can help modify the script
I have a dump file of guest users that I need to import in the above script .

Not as read host. Import csv file

jitensh · 2021-03-13T02:54:47.000Z

you need

Get-AzureADUser -Filter "UserType eq 'Guest'"

jaikum2 · 2021-03-13T02:57:10.000Z

I’m looking for guest account in azure inactive for 60 days

jitensh · 2021-03-13T14:04:59.000Z

jaikum2:

I’m looking for guest account in azure inactive for 60 days

I looked at your script and provided you information on how to filter guest user your script is already filtering users who didn’t log X number of days