How to get the list of users who are not logged into the azure virtual desktop under a hostpool for 20 or more than 20 days ?

Hi @Sai Krishna Katakam ,

It really helped me alot .

Through PowerShell can we achieve this , if yes means how can we able to do & any prerequisites do we have for that .

In automation perspective i am asking .

Thanks in Advance.

Hi kavya madda,

Glad to hear it helped! Yes, you can achieve this through PowerShell and automate the process.
Prerequisites:

• Install the Az.DesktopVirtualization PowerShell module.
• You’ll need Contributor or Reader access to the AVD resources.
• Make sure the Azure account is connected using Connect-AzAccount.

# Install AVD module if not already installed
Install-Module -Name Az.DesktopVirtualization -AllowClobber
# Connect to your Azure account
Connect-AzAccount
# Get all the user sessions from the host pool
$sessions = Get-AzWvdUserSession -ResourceGroupName "<ResourceGroupName>" -HostPoolName "<HostPoolName>"
# Filter the sessions for users who haven't logged in for the last 45 days
$inactiveUsers = $sessions | Where-Object { $_.LastLoginTime -lt (Get-Date).AddDays(-45) }
# Output the results
$inactiveUsers | Select-Object UserPrincipalName, LastLoginTime

Automation:

You can automate this by setting up an Azure Automation Runbook or using Task Scheduler to run it at regular intervals. For more details, check out Azure Automation Overview.

If the answer is helpful, please click "Accept Answer" and "Upvote it."

Hi @Sai Krishna Katakam ,

It means a lot to me and your help worked me but i am getting the login time and AVD name.

other help which I needed is

1. How can I include the AVD details (AVD Name) under the resource group level name for all Host pools which they are using. 2.How to send the mail as you're not using the AVD from past 45 days. If not using further going to decommission it like this mail need to send automatically for that particular person who is not using AVD from past 45 days.

Hi kavya madda,

Glad to hear it helped! Here’s how you can address the additional requirement.

Include AVD Details:

You can update the script to include the Host Pool Name along with the login time. Modify the script like this.

# Get all user sessions for all host pools in a resource group
$hostpools = Get-AzWvdHostPool -ResourceGroupName "<ResourceGroupName>"
foreach ($pool in $hostpools) {
    $sessions = Get-AzWvdUserSession -ResourceGroupName "<ResourceGroupName>" -HostPoolName $pool.Name
    
    $inactiveUsers = $sessions | Where-Object { $_.LastLoginTime -lt (Get-Date).AddDays(-45) }
    # Output user details along with host pool name
    $inactiveUsers | Select-Object UserPrincipalName, LastLoginTime, @{Name="HostPoolName";Expression={$pool.Name}}
}

Send Automated Email to Inactive Users:

You can automate sending an email to users who haven’t logged in for the past 45 days. Here’s an example using Send-MailMessage in PowerShell.

foreach ($user in $inactiveUsers) {
    $body = "Dear $($user.UserPrincipalName),\n\nYou have not used AVD for over 45 days. If this continues, it may be decommissioned."
    Send-MailMessage -To $user.UserPrincipalName -From "admin@example.com" -Subject "AVD Decommission Warning" -Body $body -SmtpServer "smtp.example.com"
}

For more info on setting up email notifications with PowerShell, refer to: Send Email with PowerShell.

If the answer is helpful, please click "Accept Answer" and "Upvote".

Hi @Sai Krishna Katakam , I am not getting the last login time which u had given and i want the AVD name which is assigned to the user.

like with the Host pool name i am not getting the AVD name which is assigned to the particular user .

Can you please give me in the PowerShell wise & KQL query way also

please let me know how can i incorporate the KQL query in Powershell script which you had given .

Hi kavya madda,

Thank you for the clarification! Here's how you can retrieve the AVD (Session Host) Name assigned to a user, along with the Last Login Time and Host Pool Name.

To retrieve the AVD name (session host) along with user details, you can use the following updated script:

# Get all user sessions for all host pools in a resource group
$hostpools = Get-AzWvdHostPool -ResourceGroupName "<ResourceGroupName>"
foreach ($pool in $hostpools) {
    $sessions = Get-AzWvdUserSession -ResourceGroupName "<ResourceGroupName>" -HostPoolName $pool.Name
    
    # Filter users who haven’t logged in for 45 days
    $inactiveUsers = $sessions | Where-Object { $_.LastLoginTime -lt (Get-Date).AddDays(-45) }
    # Output user details along with Host Pool and Session Host Name (AVD Name)
    $inactiveUsers | Select-Object UserPrincipalName, LastLoginTime, @{Name="HostPoolName";Expression={$pool.Name}}, SessionHostName
}

To get the same data via KQL, you can use the following query in the Log Analytics workspace:

WVDConnections
| where TimeGenerated > ago(45d)
| summarize lastLogin=max(TimeGenerated) by UserName, HostPoolName, SessionHostName
| where lastLogin < ago(45d)
| project UserName, lastLogin, HostPoolName, SessionHostName

To incorporate a KQL query into a PowerShell script, use the Invoke-AzOperationalInsightsQuery cmdlet. Here's how you can run the KQL query from within PowerShell:

# Define your KQL query
$kqlQuery = @"
WVDConnections
| where TimeGenerated > ago(45d)
| summarize lastLogin=max(TimeGenerated) by UserName, HostPoolName, SessionHostName
| where lastLogin < ago(45d)
| project UserName, lastLogin, HostPoolName, SessionHostName
"@
# Run the KQL query in Log Analytics
$logAnalyticsWorkspaceId = "<YourLogAnalyticsWorkspaceId>"
$queryResults = Invoke-AzOperationalInsightsQuery -WorkspaceId $logAnalyticsWorkspaceId -Query $kqlQuery
# Output the results
$queryResults.Tables.Rows | ForEach-Object {
    [PSCustomObject]@{
        UserName = $_[0]
        LastLogin = $_[1]
        HostPoolName = $_[2]
        SessionHostName = $_[3]
    }
}

If the answer is helpful, please click "Accept Answer" and "Upvote".

HI Sai Krishna Katakam,

Sorry for the late reply, It helped me a lot & thanks for your help.

Should i ask you another help like the users list which i am getting with the details how can i send back these details through API call of pipeline.

Hi kavya madda,

I would recommend creating a new thread on the same forum with as much details about your issue as possible.

That would make sure that your issue has better visibility in the community.

Thank you.