This board contains archived posts from the retired Lansweeper Forum and Insiders Community.
Hi All.Deleting an asset manually like "SQL DELETE FROM tblAssets WHERE AssetID = 1234567890;". Does it delete the whole tree (means all depending tables where AssetID = 1234567890 match) or do I have to delete every single table entry? If I have to ...
Hi, would be great to be able to update information for existing assets with information from a csv file. For example I need to update custom fields in Lansweeper for 200+ items.
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.AssetName, tblAssetCustom.Printerstatus As Status, tblAssetCustom.Printedpages As [Printed Pages], tblAssets.Lastseen, tblAssets.AssetID, tblAssets.IPAddress, tblAssetCustom....
Select Top 1000000 tblADusers.Username, tblADusers.Name, tblADusers.Firstname, tblADusers.Lastname, tblADusers.Userdomain, tblADusers.Displayname, tblADusers.email As [E-mail], 'usersm.png' As icon, tblADusers.LastchangedFrom tblADusersWhere ...
Hello,we are having some outdated information from the lansweeper even after changes done on the systems (servers, desktop and laptops, still it holds the older information,i.e Sql version, number of core, cpu and software which has been uninstalled...
Is there any way to import Exchange User CALs into the Lansweeper license compliance section? We're using it for our Microsoft server licenses, but it'd be great if we could get the Exchange user CALs in there to see at a glance where we're at. Thank...
Is it possible to create a custom widget in VB instead of C#?
select Username, Firstname, Lastname, OU, WhenCreated, WhenChanged, a.lastChangedfrom tblADGroups ainner join tblADMembership b on a.ADObjectID=b.ParentAdObjectIDinner join tblADusers c on C.ADObjectID=b.ChildAdObjectIDwhere a.name='Your group'
