This board contains archived posts from the retired Lansweeper Forum and Insiders Community.
Hi all,I'm fairly adept a report writing, but this is puzzling me , an 'exception' report to to identify only the Macs in our environment that are missing the Casper Management agent. .. tblSoftwareUni.softwareName <> 'jamfHelper' ?Anyone do t...
I have made a report as follows to try and get all systems in an AD groupSelect Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTypename, tsysAssetTypes.AssetTypeIcon10 As icon, tblADComputers.AdcomputerID, tblADComputers...
Added in v.6.0.100The report below will give back Windows computers the last users that logged on to the computer.The report will only list assets that meet all of the following criteria:The asset state is set to "active".The asset has been successfu...
Added in v.6.0.100The report below will give back Windows computers and the users that have logged on to the machine.The report will only list assets that meet all of the following criteria:The asset state is set to "active".The asset has been succes...
Added in v.6.0.100The report below will give back Windows computers with their shares and share permissions.The report will only list assets that meet all of the following criteria:The asset state is set to "active".The asset has been successfully sc...
Added in v.6.0.100The report below gives back the information that is found in the Users section under Configuration\User Access & Roles but do not give back the teams so that each user has a single row.Select Top 1000000 htblusers.name As [User], h...
Added in v.6.0.100The report below gives back the information that is found in the Users section under Configuration\User Access & Roles. Multiple rows are given back for a single user if they are part of more than one team.Select Top 1000000 htbluse...
Added in v.6.0.100The report below gives back the time worked that has been inputted by agents for each ticket. The report will only take into account tickets that meet all of the following criteria:The time worked is not added to notes in a ticket t...
