Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
thoromega
Engaged Sweeper
I was trying to modify the "Role Master Browser" report and it didn't like that at all.
So deleted and tried again with editing the "Role Backup Browser" report

How can I get these 2 reports back (Are they in the install files)??
Any help would be great.
Thanks
Mj
1 REPLY 1
Hemoco
Lansweeper Alumni
Master browser:

SELECT     TOP 100 PERCENT dbo.tblComputers.Computername, dbo.tblOperatingsystem.Description, dbo.tblComputers.Domain, dbo.tblComputersystem.Roles, 
dbo.tblComputersystem.Lastchanged
FROM dbo.tblComputersystem INNER JOIN
dbo.tblComputers ON dbo.tblComputersystem.Computername = dbo.tblComputers.Computername INNER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername
WHERE (dbo.tblComputersystem.Roles LIKE '%Master_Browser%')
ORDER BY dbo.tblComputers.Computername


Backup browser:

SELECT     TOP 100 PERCENT dbo.tblComputers.Computername, dbo.tblOperatingsystem.Description, dbo.tblComputers.Domain, dbo.tblComputersystem.Roles, 
dbo.tblComputersystem.Lastchanged
FROM dbo.tblComputersystem INNER JOIN
dbo.tblComputers ON dbo.tblComputersystem.Computername = dbo.tblComputers.Computername INNER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername
WHERE (dbo.tblComputersystem.Roles LIKE '%Backup_Browser%')
ORDER BY dbo.tblComputers.Computername