→ 🚀Are you a Lansweeper Champion?! Join our Contributor Program Sign up here!

Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
EAF
Engaged Sweeper
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
10 REPLIES 10
Hemoco
Lansweeper Alumni
Maybe a copy/paste problem?
I can run the code without a problem (PS: you have tbladcomputers double)

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

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

Try Now