How to set up automatic login reports for Azure Virtual Desktop after a specific time?

Devin Martin 0 Reputation points
2023-01-17T03:01:51.94+00:00

We are wanting to set up a weekly report that is automatically generated and emailed to an admin every Friday.

This needs to be based off of the Azure Active Directory Sign-In Logs, and be filtered to only show Application "Azure Virtual Desktop" Sign-Ins over the past 7 days.

It is a bonus if the report can have all columns removed with the exception of the "Date", "User", and "Application" columns.

Any ideas how to complete this? We are stumped.

Azure Virtual Desktop
Azure Virtual Desktop
A Microsoft desktop and app virtualization service that runs on Azure. Previously known as Windows Virtual Desktop.
1,362 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,445 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Prrudram-MSFT 21,886 Reputation points
    2023-01-19T17:24:17.39+00:00

    Hi @Devin Martin ,

    Thank you for reaching out to the Microsoft Q&A platform. Happy to answer your question.

    For that, I recommend using the API to download the logs regularly, and then use e.g. PowerBI to build a report.

    How to download logs in Azure Active Directory - Microsoft Entra | Microsoft Learn

    Hope this helps!

    Please "Accept as Answer" and Upvote if the answer provided is useful, so that you can help others in the community looking for remediation for similar issues.

    0 comments