This board contains archived posts from the retired Lansweeper Forum and Insiders Community.
Added in v.6.0.100The report below lists assets and the software that is installed on them. 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 scanned at least o...
Added v.6.0.100The report below replicates the ‘Assets’ page in the Lansweeper webconsole.Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTypename As AssetType, tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.Doma...
Added in v.6.0.100The report below lists all the assets that have not been successfully scanned in the last 7 days.The report will only list assets that meet all of the following criteria:The asset state is set to "active".The asset has been successf...
Added in v.6.0.100The report below lists assets and any location map they are placed on. Both the asset and location map are given back in the report.The report will only list assets that meet all of the following criteria:The asset state is set to "...
Added in v.6.0.100The report below lists assets that have an asset name that is longer than 15 characters.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 scan...
Added in v.6.0.100The report below lists assets and the documents that have been added to the asset. 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 scanned a...
Added in v.6.0.100The report below lists the assets that have a relation with another asset. Both assets are given back in the report as well that the relation type that is used.The report will only list assets that meet all of the following criteria...
I need some help with creating this. My SQL is not that great.I am trying to get a report to see which assets have not been assigned a user yet.I found a report on the site to show which have been, but I need the opposite.Thanks in advance.
