Report Builder corrupt SQL query

[EAF]

Hello

i've copy the "Software: Unauthorized software" report and modify it to list only computers in a specific Active Directory OU

Select Top 1000000 dbo.tblComputers.Computername,
dbo.tblComputers.ComputerUnique, dbo.tblOperatingsystem.Description,
dbo.tblSoftware.softwareName As Software, dbo.tblSoftware.softwareVersion As
Version, dbo.tblSoftware.Lastchanged, Web40OSName.Compimage As icon,
tblADComputers1.OU
From dbo.tblSoftware Inner Join
dbo.tblComputers On dbo.tblSoftware.ComputerName =
dbo.tblComputers.Computername Inner Join
dbo.tblOperatingsystem On dbo.tblComputers.Computername =
dbo.tblOperatingsystem.Computername Inner Join
dbo.web40ActiveComputers On dbo.tblComputers.Computername =
dbo.web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = dbo.tblComputers.Computername And
Not (dbo.tblSoftware.softwareName In (Select tblapprovedsoftware.Software
From tblapprovedsoftware)) Inner Join
tblADComputers On dbo.tblComputers.Computername = tblADComputers.Computername
Inner Join
tblADComputers tblADComputers1 On dbo.tblComputers.Computername =
tblADComputers1.Computername
Where
tblADComputers1.OU Like
'%,OU=Computers,OU=DIR_FIN,OU=Organisation,DC=xxxx,DC=xx'
Order By dbo.tblComputers.Computer, dbo.tblSoftware.softwareName


This query working well if i launch it through MS SQL Management Studio but if i copy it into the report bulider, i've No data to display in the result tab ....

Thanks for your Help

[EAF]

Just receive the answer :

Hi,

We had a similar problem last week, the report builder wraps the long OU text line.
As a workaround you can save the report, then edit the saved view in the sql server management tools.
We will fix this in the next update, most likely somewhere in August.

Regards
The Lansweeper team

[EAF]

OK thansk, i've just send you an e-mail

[Hemoco]

can you please e-mail us about this problem. (support@lansweeper.com)

[EAF]

Hi

Did you reproduce this problem in your environnement ?

Thanks

[EAF]

Hi

Same result "No datas", if i modified the tblADComputers.OU criteria in the grid field then "SAVE" the report (still OK if i did not save it).
it seems that Lansweeper re-format the query but corrupt it at the same time ....

Can you reproduce this bug in your environment (See report in attachement)?

[Hemoco]

Can you save the report before clicking on results first?

[EAF]

Hi,

I changed the OU parameters under criteria.
Typically, i've copied the line from the SQL Query "%,OU=Ordinateurs,OU=DIR_FIN,OU=Organisation,DC=xxxx,DC=xxxx" directly in the grid. If i directly go to the "Result" tab, i can see all the datas but if i saved the report, then go back to the "result" tab : "No data to display".

I have to filter by OU to list unwanted softwares on certain computers and i don't know how to do it other than this request ...if you have any others ideas, i'm interested 😉

Thx

[Hemoco]

Most likely it's a problem with "wordwrap" in the lower sql pane.
try changing the ou parameter inside the grid "under criteria"

[EAF]

Hi

To precise :
if i copy/paste the SQL Query from Management Studio to LanSweeper Report Builder it didn't work (No Data to display)

If i didn't specify any criteria for tblADComputers.OU, it works (i can see all computers with Unauthorized software and the linked OU)

If i just modify, in Report Builder, the criteria Like '%,OU=Computers,OU=DIR_FIN,OU=Organisation,DC=xxxx,DC=xx' for tblADComputers.OU directly in the field, it works. But if i just "Save" the report, i didn't works anymore ....