Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Topics in this forum

Assets: Installed software by computer (Built-in)

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...

Nick_VDB by Champion Sweeper III
  • 1561 Views
  • 0 replies
  • 0 kudos

Assets: All columns from the Assets menu (Built-in)

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...

Nick_VDB by Champion Sweeper III
  • 2653 Views
  • 0 replies
  • 0 kudos

Assets: Scanning errors in last 7 days (Built-in)

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...

Nick_VDB by Champion Sweeper III
  • 1850 Views
  • 0 replies
  • 0 kudos

Assets: Assets and location maps they're on (Built-in)

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 "...

Nick_VDB by Champion Sweeper III
  • 1854 Views
  • 0 replies
  • 0 kudos

Assets: Asset name longer than 15 characters (Built-in)

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...

Nick_VDB by Champion Sweeper III
  • 2042 Views
  • 0 replies
  • 0 kudos

Assets: Documents linked to assets (Built-in)

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...

Nick_VDB by Champion Sweeper III
  • 2546 Views
  • 0 replies
  • 0 kudos

Assets: Asset to asset relations (Built-in)

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...

Nick_VDB by Champion Sweeper III
  • 2473 Views
  • 0 replies
  • 0 kudos

Report for assets not assigned to users

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.

bcaulkins by Engaged Sweeper
  • 1592 Views
  • 0 replies
  • 0 kudos