→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
bgrr
Engaged Sweeper III
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

7 REPLIES 7
bgrr
Engaged Sweeper III
Problem solved.

Thanks.
bgrr
Engaged Sweeper III
mail send
Hemoco
Lansweeper Alumni
Can you contact us by e-mail to take a look at the problem.
bgrr
Engaged Sweeper III
Previous version was 4.0.0.27

A custom build you made due to a previous problem with purging old eventlogs/

http://www.lansweeper.com/forum/yaf_postst3671_eventlog-entries-not-being-purged-after-x-days.aspx

Hemoco
Lansweeper Alumni
From which version did you do the upgrade?
bgrr
Engaged Sweeper III
all entry's in dbo.tsysadmins table are ignored in the report. The just show up as unauthorized administrator.

There are several domain admin accounts and also several local admin accounts in the table tsysadmins.

Hemoco
Lansweeper Alumni
Just tested with your report code.

which admins are ignored?

New to Lansweeper?

Try Lansweeper For Free

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

Try Now