Need help building a report - asset name and last user to log on to the asset names - Azure AD

[breakbeats101]

Hello,

New to lansweeper and the forum, so if this is in the wrong spot/has wrong flair/etc. feel free to shoot it down and let me know.

We use Azure AD and I need to build/find a report that lists every asset in our Azure AD and the last user to log in to each asset.  Any help is greatly appreciated.

Thanks

[rom]

Well, I'm taking an educated guess as I don't want to pay to make a VM in my tenant that I use for MS Learn... BUT.. it appears that the information for users is in the table [lansweeperdb].[dbo].[tblAzureAdUser]

my tables are empty, but it appears you can join that on AzureID to [lansweeperdb].[dbo].[tblAzureVirtualMachine]

I hope that helps, I'll try to write a query later but its hard to doublecheck when I have no records 🙂

[rom]

but, that does raise the question of - can I inventory the stuff that MS Learn sandboxes before the time expires and its deleted... hmm....

[beacampos]

Bringing your post back to the top to see if our other Community users could help you out ! 🤗