Unauthorized administrators report

[gregslansweeper]

I know that the stock reports can be modified using the report builder, but I am wondering if anyone has an easy way of excluding the local administrator account from the unauthorized administrators report.

[wgknowles]

Don't tinker with built in reports, make a copy of it first and modify the copy!

SELECT TOP 100 PERCENT dbo.tblUsersInGroup.Computername AS Computer, dbo.tblOperatingsystem.Description, dbo.tblUsersInGroup.Domainname,
dbo.tblUsersInGroup.Groupname, dbo.tblUsersInGroup.Username, dbo.tblUsersInGroup.Lastchanged
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
WHERE (dbo.tblUsersInGroup.Groupname LIKE 'adm%') AND (NOT (dbo.tblUsersInGroup.Username IN
(SELECT AdminName
FROM tsysadmins)))
ORDER BY dbo.tblUsersInGroup.Computername

[gregslansweeper]

wgknowles wrote:
Don't tinker with built in reports, make a copy of it first and modify the copy!

SELECT TOP 100 PERCENT dbo.tblUsersInGroup.Computername AS Computer, dbo.tblOperatingsystem.Description, dbo.tblUsersInGroup.Domainname,
dbo.tblUsersInGroup.Groupname, dbo.tblUsersInGroup.Username, dbo.tblUsersInGroup.Lastchanged
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
WHERE (dbo.tblUsersInGroup.Groupname LIKE 'adm%') AND (NOT (dbo.tblUsersInGroup.Username IN
(SELECT AdminName
FROM tsysadmins)))
ORDER BY dbo.tblUsersInGroup.Computername

Thanks. Works great.

[gregslansweeper]

Yea, I guess I should have tried the obvious first.

On another note, Where is the actual SQL query code for a report stored? I managed to break the Unauthorized Administrators report, and the report builder application crashes when I try to edit this particular report. Is there a document that contains the SQL code for the stock reports that ship with the application?

[Hemoco]

gregslansweeper wrote:
Yea, I guess I should have tried the obvious first.

On another note, Where is the actual SQL query code for a report stored? I managed to break the Unauthorized Administrators report, and the report builder application crashes when I try to edit this particular report. Is there a document that contains the SQL code for the stock reports that ship with the application?

I would recommend downloading the 3.5.2 beta report builder (this one shouldn't crash)

[gregslansweeper]

Lansweeper wrote:

gregslansweeper wrote:
Yea, I guess I should have tried the obvious first.

On another note, Where is the actual SQL query code for a report stored? I managed to break the Unauthorized Administrators report, and the report builder application crashes when I try to edit this particular report. Is there a document that contains the SQL code for the stock reports that ship with the application?

I would recommend downloading the 3.5.2 beta report builder (this one shouldn't crash)

I do have the 3.5.2 beta, and it doesn't really crash.. I just get an error:

"the object 'web30replocaladmin' does not exist in database 'lansweeperdb' or is invalid for this operation"

So short of installing another instance of lansweeper and copying the report sql and possibly the view sql, I'm not sure what else to try.

[wgknowles]

Include an entry with {computer} in the domain and Administrator for the Account