After updating to V4.0.0.36 the report computers: unauthorized administrators ignores the entry's in tsysadmins.
How can i fix the report ? Did something change in the update to 4.0.0.37 ?
Here is my current query for the report computers:unauthorized administrators from v4.0.0.37
Select Top 1000000 dbo.tblComputers.ComputerUnique, dbo.tblUsersInGroup.Computername, dbo.tblComputers.Domain, dbo.tblOperatingsystem.Description, dbo.tblUsersInGroup.Domainname, dbo.tblUsersInGroup.Username, dbo.tblUsersInGroup.Lastchanged, dbo.Web40OSName.Compimage As icon From dbo.tblUsersInGroup Inner Join dbo.tblComputers On dbo.tblUsersInGroup.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 dbo.Web40OSName On dbo.Web40OSName.Computername = dbo.tblComputers.Computername Left Outer Join (Select Distinct * From (Select dbo.tblComputers.Computer As Domain, dbo.tblUsers.Name As Username From dbo.tblComputers Inner Join dbo.tblUsers On dbo.tblComputers.Computername = dbo.tblUsers.Computername Where dbo.tblUsers.BuildInAdmin = 1 Union Select tsysadmins.Domain, tsysadmins.AdminName As username From tsysadmins) DERIVEDTBL) localadmins On dbo.tblUsersInGroup.Domainname Like localadmins.Domain And dbo.tblUsersInGroup.Username Like localadmins.Username Where localadmins.Domain Is Null And localadmins.Username Is Null And dbo.tblUsersInGroup.Admingroup = 1 Order By dbo.tblComputers.Computer
