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: 

Forum Posts

List of Software Publisher´s

Hello,i need for a better performance into my reports additional entries into configuration.For HardwareAsset Manufacturer support links for HP Notebook, PC and ServerFor Software Version and if there a Lic. Nr. also:Adobe (Reader and pro), TeamViewe...

How to count tickets of a specific type

Howdy, this is a modification of one of the standard reports, but I cannot seem to get the right code so that it only counts tickets of a specific type. for example we only want it to be for 'IT Helpdesk' type tickets.Select Top 1000000 DatePart(yyyy...

AEMIT by Engaged Sweeper II
  • 1645 Views
  • 0 replies
  • 0 kudos

tblCPlogoninfo - None interactive logons?

Does anyone know if the user logon information from tblCPlogoninfo is for interactive logons only.... or does it include none interactive user events?I am trying to write a report that is logging actual interactive logon's to our servers and the tblC...

Maintenance History Tab

Would be nice to have a maintenance history tab similar to comments, where one could log maintenance tasks. e.g replacing a fuser kit, replacing scanner rollers, replacing UPS batteries, installing Ram, or an SSD etc. Fields to include:description, c...

Error: Invalid length parameter passed to the LEFT or SUBSTRING function.

This report worked fine until the last Lansweeper update: 7.2.105.2. Now I get the error message: Error: Invalid length parameter passed to the LEFT or SUBSTRING function.Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, SubString(tblNtlog...

pfenton by Engaged Sweeper III
  • 2401 Views
  • 0 replies
  • 0 kudos

Help With Field And Colour Coded Report

Hi Guy's,Hoping you can help with a report. I have the following report which we are using to manage out upgrades to Windows 10 1903. We are targeting certain sites first and versions etc.The issue I have is some of our early Toshiba Laptops came w...

Computers not pointing to WSUS server

Hello,Occasionally we discover some odd machine not in our WSUS server,its rare but its happening.I'd like to make a report to show me all computers not pointing to the WSUS server.I think a good way to do this is via registry report that shows all c...

parrot by Engaged Sweeper
  • 2082 Views
  • 0 replies
  • 0 kudos

Report for NOT SCANNED OS

Hi,I have the below code and I want to limit the report result of all NOT SCANNED OS ONLYSelect Top 1000000 tblAssets.AssetID, tsysAssetTypes.AssetTypename, tblAssetCustom.Custom6 As 'Environment', tblAssetCustom.Location, tblAssets.AssetName, t...

AlexMG by Engaged Sweeper
  • 1805 Views
  • 0 replies
  • 0 kudos