→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
08-17-2022 10:48 PM
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
10-27-2022 10:45 PM
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 🙂
10-27-2022 10:46 PM
but, that does raise the question of - can I inventory the stuff that MS Learn sandboxes before the time expires and its deleted... hmm....
10-27-2022 01:55 PM
Bringing your post back to the top to see if our other Community users could help you out ! 🤗
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now