SQL error when users select Assets Concerning button

[DonMario73]

Greetings, after migration to Lansweeper 12.5.3.0, we noticed that when users selects the Assets Concerning button, the following SQL error message is displayed:

This error doesn't shows to agents when they select the Assets Concerning button. 

We opened a support case and were told that this may be a bug and has be assigned ID LAN-17735.

Wanted to understand if somebody else has experienced this error message.

Regards

[DonMario73]

Hi Obi One, made some tests in my lab and can confirm that this issue happens without having square brackets in any custom fields.

Let me know if you could reproduce this issue at your end.

Thks!

[Obi_1_Cinobi]

Hello there!

We have indeed created a bug for this so that our development team can investigate the root cause. Other customers have not yet reported this behavior. However, I do see a similar error in the assets part of Lansweeper, which seems to be caused by square brackets in custom fields on assets. So, this might be a weird question... do you use square brackets in custom fields on assets?

[DonMario73]

Hi Again, I asked Chatgpt to analyze the query and the error message.  Here goes the results:

❌ Identified Error

The issue is with the column mismatch between the UNION queries:

In your first SELECT inside the subquery, you return:

SELECT tblAssets.AssetID, tblAssets.Domain, tblAssets.Assettype, tblAssets.AssetName, tsysAssetTypes.AssetTypeIcon10 AS icon

But in the second SELECT (below the UNION), you have:

SELECT TOP 1000000 tblAssets_3.AssetID, tblAssets_3.Domain, '' AS IPAddress, 0 AS Assettype, tblAssets_3.AssetName, ...

🛑 The first SELECT has 5 columns, but the second SELECT has 6:

• Second SELECT includes: '' AS IPAddress and 0 AS Assettype (which shifts column positions).

• This results in a UNION column mismatch → SQL Server throws an error like:

All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.

✅ How to Fix It

You need to align the column list in both parts of the UNION. Based on your outer query, you're expecting.

Is it possible to update the query or is it harcoded?

Thks!

[Obi_1_Cinobi]

Hello there!

Thanks for confirming that the issue is not related to square brackets in your scenario. Regarding the SQL statement, it is indeed hardcoded, and as such, a new release will be needed to fix this behavior.

[DonMario73]

Hi again, can you confirm an ETA for this fix? We upgraded to the latest version as Lansweeper support requested to install the latest version in order to analyze another bug but the latest version introduced a bug to a functionality that was working fine.

Thks! 

[Obi_1_Cinobi]

Hello there!

There is currently no ETA on a fix.

[DonMario73]

Hi again, there is a SLA of two weeks mentioned in the following post:

https://community.lansweeper.com/t5/deployment-packages/issue-installing-it-agent-on-first-pc/td-p/8...

Can you clarify what is the expected SLA for this bug? Our customer is concerned about the QA and response time of Lansweeeper.