This board contains archived posts from the retired Lansweeper Forum and Insiders Community.
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...
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...
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...
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...
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...
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...
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...
For example, ive made a report of PCs that need to be replaced. It would be really helpful to be able to 'highlight' them on my location map, like we can do from an individual computer's asset page > location. then be able to print that map so i kn...
