Share via

Export a weekly report of user sign in as a .csv file to e-mail

Martin Mosgaard Grønne 1 Reputation point
2022-05-25T13:26:34.947+00:00

I found a topic with a similar problem https://learn.microsoft.com/en-us/answers/questions/308776/export-a-report-of-azure-active-directory-sign-ins.html

He used Logic Apps, although I do not want to buy an Azure Subscription.

Is there a way to automate this process?

Microsoft Security | Microsoft Entra | Microsoft Entra ID

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Newbie Jones 1,411 Reputation points
    2022-05-25T13:53:47.863+00:00

    You can use PowerShell if you don't want to use Logic Apps. I'm assuming that you still want to use Log Analytics.

    https://azautomation.dev/powershell/using-powershell-to-send-and-receive-custom-log-data-to-azure-log-analytics/

    You will need to code this yourself though so you'll need PowerShell knowledge. It's doubtful anyone will just write you a script.

    Need to learn PowerShell?

    The following download is free.
    Windows-PowerShell-4

    Start with the first half of the book and do the exercises to cover the basics.
    Then work through the 2nd half of the book which covers common tasks.

    1 person found this answer helpful.
    0 comments
  2. David Broggy 6,801 Reputation points MVP
    2022-05-26T03:47:27.32+00:00

    Can you provide more details on your need?
    If you don’t own a subscription why do you need to monitor Azure logins?
    The logins need to be stored in a Log Analytics Workspace before you can track user logins, that will require a subscription because the workspace takes up storage in Azure.
    Once you’ve enabled Azure diagnostics to log to a log analytics workspace you’ll be able to use powershell or the Azure monitor UI to track your users.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.