How to get the useridle session for past 30,45 & 15 days?

Question

How to get the useridle session for past 30,45 & 15 days?

kavya madda 60

Hi I am able to get the list of users who are logged into AVD from past 30 days.

Now in the same logic it should have to give the 45 days & 15 days of data .

The time generated should be same right & the last login date should change right

I have this doubt .

Could anyone please help me on this and the generating output should be in JSon format

Thanks inAdvance

Mounika Reddy Anumandla 7,135 Reputation points Moderator

2024-10-09T15:59:20.6266667+00:00

Hi kavya madda,

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

As you have mentioned, you are able to get the list of users who are logged into AVD from past 30 days. Can you please share the script you are using so that I can help you further.

Thank You!
kavya madda 60 Reputation points

2024-10-09T17:00:42.6533333+00:00
Hi monika reddy anumandla, below is the script which i am getting the 30 days of data.

$subscriptionId = "134" # Replace with your subscription ID

$resourceGroup = "xyz" # Replace with your resource group name

Set-AzContext -SubscriptionId $subscriptionId

$workspace = Get-AzOperationalInsightsWorkspace -ResourceGroupName $resourceGroup

$query = @"

WVDConnections

| where TimeGenerated > ago(30d)

| summarize lastLogin=max(TimeGenerated) by UserName, _ResourceId, SessionHostName

| where lastLogin < ago(20d) # Adjusted to 30 days for user inactivity

| project UserName, lastLogin, _ResourceId, SessionHostName

"@

$results = Invoke-AzOperationalInsightsQuery -WorkspaceId $workspace.CustomerId -Query $query

$IdleUsers = $results.Results | ForEach-Object {

[PSCustomObject]@{ UserPrincipalName = $_.UserName LastLogin = $_.lastLogin HostPoolName = $_._ResourceId.split('/')[8] # Extract host pool name SessionHostName = $_.SessionHostName } ```} $IdleUsers i want to get for 30,45 & 15 days . and also if i pass the hostpool parameter it have to give the values or users assigned to that one from that generated output. Thanks in advance
kavya madda 60 Reputation points

2024-10-10T05:14:44.5766667+00:00

Hi monika i need the AVD details in hostpool which we are not having any user assigned to it for 15 days?

Can you please let me know how can i achieve it .
Prrudram-MSFT 28,506 Reputation points Moderator

2024-10-10T08:04:38.27+00:00

Hello @kavya madda
The ask is not very clear, can you please confirm if the above script you mentioned is in use and ever worked for you? If yes, did you try using time period you want in the where conditions like
| where TimeGenerated > ago(15d)

1 answer

Your answer

Mounika Reddy Anumandla 7,135 Reputation points Moderator

2024-10-09T15:59:20.6266667+00:00

Hi kavya madda,

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

As you have mentioned, you are able to get the list of users who are logged into AVD from past 30 days. Can you please share the script you are using so that I can help you further.

Thank You!
kavya madda 60 Reputation points

2024-10-09T17:00:42.6533333+00:00

Hi monika reddy anumandla, below is the script which i am getting the 30 days of data.

$subscriptionId = "134" # Replace with your subscription ID

$resourceGroup = "xyz" # Replace with your resource group name

Set-AzContext -SubscriptionId $subscriptionId

$workspace = Get-AzOperationalInsightsWorkspace -ResourceGroupName $resourceGroup

$query = @"

WVDConnections

| where TimeGenerated > ago(30d)

| summarize lastLogin=max(TimeGenerated) by UserName, _ResourceId, SessionHostName

| where lastLogin < ago(20d) # Adjusted to 30 days for user inactivity

| project UserName, lastLogin, _ResourceId, SessionHostName

"@

$results = Invoke-AzOperationalInsightsQuery -WorkspaceId $workspace.CustomerId -Query $query

$IdleUsers = $results.Results | ForEach-Object {

[PSCustomObject]@{ UserPrincipalName = $_.UserName LastLogin = $_.lastLogin HostPoolName = $_._ResourceId.split('/')[8] # Extract host pool name SessionHostName = $_.SessionHostName } ```} $IdleUsers i want to get for 30,45 & 15 days . and also if i pass the hostpool parameter it have to give the values or users assigned to that one from that generated output. Thanks in advance
kavya madda 60 Reputation points

2024-10-10T05:14:44.5766667+00:00

Hi monika i need the AVD details in hostpool which we are not having any user assigned to it for 15 days?

Can you please let me know how can i achieve it .
Prrudram-MSFT 28,506 Reputation points Moderator

2024-10-10T08:04:38.27+00:00

Hello @kavya madda
The ask is not very clear, can you please confirm if the above script you mentioned is in use and ever worked for you? If yes, did you try using time period you want in the where conditions like
| where TimeGenerated > ago(15d)

Answer 1

Prrudram-MSFT 28,506 Moderator

Hello @kavya madda

Thank you for reaching out to the Microsoft Q&A platform.

The best way is as long as you retain the data in Log Analytics, you can use AVD insights So, something like below. You will use both Log Analytics and Azure Resource graph to verify that the host is part of a host pool even if it's not been turned on recently and thus not sending heartbeats to Log Analytics. User's image

0 comments

Share via

How to get the useridle session for past 30,45 & 15 days?

1 answer

Your answer