Wrong output for view web40repDuplicatelicenseMS

[wpa1160]

The sub-select of the above view is wrong (aka missing brackets)

   Select Top 1000000 
      tblSerialnumber.Product, 
      tblSerialnumber.ProductKey, 
      Count(tblSerialnumber.SerialID) As Total, 
      TsysSerials.SerialID 
   From 
      dbo.tblComputers 
      Inner Join web40ActiveComputers On web40ActiveComputers.Computername = dbo.tblComputers.Computername 
      Inner Join tblSerialnumber On dbo.tblComputers.Computername = tblSerialnumber.Computername 
      Inner Join TsysSerials On TsysSerials.Product = tblSerialnumber.Product 
   Group By 
      tblSerialnumber.Product, 
      tblSerialnumber.ProductKey, 
      TsysSerials.SerialID 
   Having 
      Count(tblSerialnumber.SerialID) > 1 
      And TsysSerials.SerialID = 1 Or tblSerialnumber.Product Like 'Microsoft%'

should be

   Select Top 1000000 
      tblSerialnumber.Product, 
      tblSerialnumber.ProductKey, 
      Count(tblSerialnumber.SerialID) As Total, 
      TsysSerials.SerialID 
   From 
      dbo.tblComputers 
      Inner Join web40ActiveComputers On web40ActiveComputers.Computername = dbo.tblComputers.Computername 
      Inner Join tblSerialnumber On dbo.tblComputers.Computername = tblSerialnumber.Computername 
      Inner Join TsysSerials On TsysSerials.Product = tblSerialnumber.Product 
   Group By 
      tblSerialnumber.Product, 
      tblSerialnumber.ProductKey, 
      TsysSerials.SerialID 
   Having 
      Count(tblSerialnumber.SerialID) > 1 
      And (TsysSerials.SerialID = 1 Or tblSerialnumber.Product Like 'Microsoft%')

Otherwise the query would return a single license as a duplicate (see attached file).

[Hemoco]

Can you mail the screenshots to support@lansweeper.com please.

[wpa1160]

And I also still cannot uploads attachments to the forum anymore:

"The connection to the server was reset while the page was loading."

[wpa1160]

Sure, see screenshot.

Left side = Current lansweeper release
Right side = Result from query in post #8

[Hemoco]

Can you verify that the report in #8 gives the correct results for you please.

[wpa1160]

No upgrade steps at all - I simply download the EXE and start the upgrade which runs flawlessly.

I only revert my changes to the web40repDuplicatelicenseMS report every time before performing an upgrade hoping that the error is fixed. After the upgrade I run the report and it's - as usual - unchanged so that I have to re-integrate the changes again.

Why hasn't the correct query (which has been verified to work nearly 3 months ago) not yet been integrated?

[wpa1160]

Could someone finally integrate the working query from post #8?!?

The error is still present in 4.1.0.18 and I'm really tired of manually modifying the query after an upgrade...

[Hemoco]

wpa1160 wrote:
The error is still present in 4.1.0.18 and I'm really tired of manually modifying the query after an upgrade...

Can you please explain your upgrade steps.
The last upgrades didn't make any changes to this report, so your changes to this report were not overwritten.

[wpa1160]

cannot upload attachment - server error

[wpa1160]

The current release of Lansweeper 4.1.0.11 still shows a wrong output (see attached file).

BUT: I tested the query posted above on Jan 10 and it shows the correct result (only the first 13 rows of the screenshot).