
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-23-2015 05:32 PM
Solved! Go to Solution.
- Labels:
-
General Discussion
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-24-2015 04:37 PM
The best way to troubleshoot this issue would be to contact support@lansweeper.com and provide:
- Program Files (x86)\Lansweeper\Service\Errorlog.txt, as present on your Lansweeper server.
- Screenshot of the Config\Display\Monitor section of one problem client machine's Lansweeper webpage.
- Output of this tool for the same problem client machine. Run the tool on the client machine.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-09-2019 06:23 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-09-2019 07:57 AM
We use different Adapter from vga to HDMI and lansweeper use the serial numbers from the adapter and not from the actual Monitor.
Best regards
Michael Fischbach

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-01-2019 02:10 PM
have you found any solution for your problem yet?
we have the same issue (about 1/3 of our monitors are not shown in the assets bc of same serial numbers).
Best regards
Michael

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-01-2015 12:52 PM
There was an error parsing the query. [ Token line number = 1,Token line offset = 1114,Token in error = Left ]
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-03-2015 04:46 PM
laurentiune wrote:
I get this error:
There was an error parsing the query. [ Token line number = 1,Token line offset = 1114,Token in error = Left ]
Your database is likely hosted in SQL Compact, which doesn't support the LEFT function. You'll need to use SUBSTRING instead.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-31-2015 01:00 AM
They do however report correct PNP Device ID's, so what I did was to modify a custom monitor report that was posted on the forums, and them add a column with the PNP Device ID, so I could see all the models on one report.
I grabbed the PNP Device ID's from DriverAgent's Database, here
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tsysOS.OSname,
LTrim(RTrim(tblMonitor.MonitorManufacturer)) + Case
When tblMonitor.MonitorManufacturer = 'ACR' Then ' (Acer)'
When tblMonitor.MonitorManufacturer = 'ACI' Then ' (Asus)'
When tblMonitor.MonitorManufacturer = 'AUO' Then ' (AU Optronics)'
When tblMonitor.MonitorManufacturer = 'BA_' Then ' (Barco)'
When tblMonitor.MonitorManufacturer = 'DEL' Then ' (Dell)'
When tblMonitor.MonitorManufacturer = 'HWP' Then ' (HP)'
When tblMonitor.MonitorManufacturer = 'IFS' Then ' (InFocus)'
When tblMonitor.MonitorManufacturer = 'LEN' Then ' (Lenovo)'
When tblMonitor.MonitorManufacturer = 'LGD' Then ' (LG)'
When tblMonitor.MonitorManufacturer = 'LPL' Then ' (LG)'
When tblMonitor.MonitorManufacturer = 'GSM' Then ' (LG)'
When tblMonitor.MonitorManufacturer = 'PHL' Then ' (Philips)'
When tblMonitor.MonitorManufacturer = 'SAM' Then ' (Samsung)'
When tblMonitor.MonitorManufacturer = 'SEC' Then ' (Samsung)'
When tblMonitor.MonitorManufacturer = 'TQ_' Then ' (Totoku)'
When tblMonitor.MonitorManufacturer = '' And Left(tblMonitor.MonitorModel,
4) = 'IBM ' Then 'IBM' Else '' End As MonitorManufacturer,
Case When tblMonitor.PNPDeviceID Like '%GSM4B7A%' Then 'W1934'
When tblMonitor.PNPDeviceID Like '%GSM443C%' Then 'L1718S'
When tblMonitor.PNPDeviceID Like '%GSM446F%' Then 'L1753S'
When tblMonitor.PNPDeviceID Like '%GSM4B32%' Then 'L192WS'
When tblMonitor.PNPDeviceID Like '%GSM4B6A%' Then 'L194W'
When tblMonitor.PNPDeviceID Like '%GSM4B6F%' Then 'W1942'
When tblMonitor.PNPDeviceID Like '%GSM4E47%' Then 'L204WT'
When tblMonitor.PNPDeviceID Like '%GSM43CC%' Then 'L1750S'
When tblMonitor.PNPDeviceID Like '%SAM02B6%' Then '245B'
When tblMonitor.PNPDeviceID Like '%SAM03D0%' Then '923NW'
When tblMonitor.PNPDeviceID Like '%SAM04D3%' Then '2494H'
Else tblMonitor.PNPDeviceID End Model_PNPDeviceID,
tblMonitor.MonitorModel,
tblMonitor.SerialNumber As MonitorSerial,
Convert(VarChar(10),tblMonitor.ManufacturedDate,120) As ManufacturedDate,
tblAssets.Domain,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Model,
tblBaseBoard.Product,
tblAssetCustom.Serialnumber,
tblAssets.Memory,
tblAssets.Processor,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblSystemEnclosure
On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On tblSystemEnclosure.ChassisTypes =
TsysChassisTypes.Chassistype
Inner Join tsysIPLocations
On tblAssets.IPNumeric Between tsysIPLocations.StartIP And
tsysIPLocations.EndIP
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblMonitor On tblMonitor.AssetID = tblAssets.AssetID
Inner Join tblBaseBoard On tblAssets.AssetID = tblBaseBoard.AssetID
Where tblAssetCustom.State = 1

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-30-2015 09:36 AM
Is it possible for lansweeper to get a list of serial/model numbers from actual monitor manufactures or is lansweeper dependent on users providing the information as specified?
Serial numbers should be unique to each single monitor. But as posted earlier, sometimes data aren't correctly written into the registry by the monitor driver. We recommend that you write a mail to our support in order to have a look at the issue.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-27-2015 07:22 PM
If the EDID information is not being read correctly, there is a way to override it with an INF file to make a custom monitor definition for the computer: https://msdn.microsoft.com/en-us/library/windows/hardware/jj133967%28v=vs.85%29.aspx

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-27-2015 06:18 PM
