
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-13-2011 05:35 PM
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
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
Labels:
- Labels:
-
Archive
10 REPLIES 10

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-14-2011 08:48 PM
Maybe a copy/paste problem?
I can run the code without a problem (PS: you have tbladcomputers double)
I can run the code without a problem (PS: you have tbladcomputers double)
