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