question

AngeloBertolotti-5662 avatar image
0 Votes"
AngeloBertolotti-5662 asked SaurabhSharma-msft commented

Azure Enterprise APP -- Exctract Login

Good morning
Please move under the Azure forum.

I would need to extract the latest accesses for all Enterprise APPs for accuracy: User sign-in (non-interactive), Service Principal sign-in, Managed Identity Sign-in.

What command can I use? I have to extract a CSV.

Can you help me?

azure-ad-enterpriseapps
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

SaurabhSharma-msft avatar image
1 Vote"
SaurabhSharma-msft answered SaurabhSharma-msft commented

Hi @angelobertolotti-5662,

Thanks for using Microsoft Q&A !!
You can get all these logs from Enterprise Application blade on Azure Portal under sign-logs blade and there you have option to download as csv.
128394-image.png

I don't think we have a PowerShell cmdlet available which can provide you all these different level of information, but you can get some sign-in logs by using Get- AzureADAuditSignInLogs under AzureADPreview module. You can redirect output of this cmdlet to a csv by using Export-Csv -
Get-AzureADAuditSignInLogs | Export-Csv -Path .\AzureADSignInLogs.csv

Please refer to the documentation for details.

Thanks
Saurabh



image.png (211.6 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @angelobertolotti-5662,

Please let us know if you find above reply useful. If yes, please accept above as answer. This will help other community members facing similar query to refer to this solution.
In case If you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks
Saurabh

0 Votes 0 ·
SaurabhSharma-msft avatar image SaurabhSharma-msft SaurabhSharma-msft ·

Hi @angelobertolotti-5662,
We haven't heard back from you. Just wanted to check if you are you still facing the issue? In case If you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks
Saurabh

0 Votes 0 ·