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
