Below are the fields I wish to report on. I have tried pulling these in from several different reports but my SQL knowledge is non-existent and all my reports have failed so far. Some of it is quite simple - other stuff I'm not sure if it's possible ...
Dear support, Could you please help us with the report bellow? I want to insert the field "chassis" into it: Select Top 1000000 tsysOS.Image As icon, tblAssets.AssetID, tsysOS.OSname, tblAssets.AssetName, tblAssets.Domain, tblAssets.Username, t...
Hello team, Is there any report available to track USB Storage disks activities? I mean when were being connected on assets, as well when they are disconnected? We need a historical report, not only when the USB Storage disks were detected during the...
In the table TblFloppyHist I'm looking for the definitions of the status values. I'm pretty sure 1 = Add and 2 = Removed. I do not know what status 3 means.
I wanted to test the Changes by Type reports in Lansweeper. I choose to test with the Processor report. I initiated a baseline scan of a Dell Optiplex PC. Once it completed, I swapped the processor, powered the PC back on and scanned again.The bas...
LS has one powerful chart. It is line-diagram. It can show more than 2 column data.I have developed SQL-query for BIOS and Monitor Ages. It have to be used with this type chart.You should use report's name with prefix "Chart:".Chart: BIOS and Monitor...
I'm building a report to display Hyper-V Generation, Memory, CPU count and Original Backup Method to recreate a new baseline Hyper-V starting print for restores. However I cannot find any reference to Hyper-V's Generation parameter in the database do...
LS scans some internet protocols: HTTP, HTTPS, FTP, SMTP, SNMP, SSH.I have developed SQL report to show them: Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTypename, tsysAssetTypes.AssetTypeIcon10 As icon, tb...
