→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
wpa1160
Engaged Sweeper
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).
16 REPLIES 16
Hemoco
Lansweeper Alumni
Can you mail the screenshots to support@lansweeper.com please.
wpa1160
Engaged Sweeper
And I also still cannot uploads attachments to the forum anymore:

"The connection to the server was reset while the page was loading."
wpa1160
Engaged Sweeper
Sure, see screenshot.

Left side = Current lansweeper release
Right side = Result from query in post #8
Hemoco
Lansweeper Alumni
Can you verify that the report in #8 gives the correct results for you please.
wpa1160
Engaged Sweeper
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
Engaged Sweeper
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
Lansweeper Alumni
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
Engaged Sweeper
cannot upload attachment - server error
wpa1160
Engaged Sweeper
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).

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now