→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
breakbeats101
Engaged Sweeper

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

3 REPLIES 3
rom
Champion Sweeper III

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
Champion Sweeper III

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
Lansweeper Employee
Lansweeper Employee

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

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now