Select Top 1000000 tblassets.AssetID, tblassets.AssetName, tblassets.Username, tsysassettypes.AssetTypename, tsysassettypes.AssetTypeIcon10 As icon, tblassets.IPAddress, tblassets.Lastseen, tblassets.Lasttried, Games.softwareName As [software...
According to: https://community.lansweeper.com/t5/managing-assets/create-use-and-change-asset-states/ta-p/64475 you can create custom "Asset States"... and According to: https://community.lansweeper.com/t5/managing-assets/search-through-assets-with-...
Hello, I'm trying to create a new custom Report in Lansweeper Cloud. The goal is to get the list of users who are not members of specific O365 groups. With a SQL request, it's quite simple, but do you know if it's possible to do that with a MongoDB Q...
I've been asked to confirm that my company is patched for CVE-2023-23397 - Microsoft Outlook Elevation of Privilege Vulnerability - Released: Mar 14, 2023 Last updated: Mar 21, 2023So I opened up my handy dandy Lansweeper MS Patch Tuesday – 2023.03.M...
Hello there, We have a lot of VM and a lot of datastores in our VMWare infra, and I'd like to know on which datastore my VMs are. That info is available in VCenter, but I can't find it (or find a query for it) in Lansweeper. Any help ?
Old name: Users: All user pictures (Built-in)The report below lists all AD users with their user picturesThe report will only list users that meet all of the following criteria:The user is an AD user.Select Top 1000000 '<img src="thumbnail.aspx?user=...
Hello I created this simple chart report to count how many computers have with BitLocker. The problem is some of the computers are no possible to activate and I want to exclude from the chart report, I have another report with all computers but in t...
I am searching for a report that shows me which servers and workstations has SMB1Protocol enabled.The SQL report presents me the output but not all the output is the sames as when i go to:a workstation, select software, select features and click on S...
