All Workstations
SELECT dbo.tblComputers.Computername, dbo.tblComputers.Domain, dbo.tblComputersystem.Domainrole, dbo.tblComputersystem.Lastchanged
FROM dbo.tblComputersystem INNER JOIN
dbo.tblComputers ON dbo.tblComputersystem.Computername = dbo.tblComputers.Computername
WHERE (dbo.tblComputersystem.Domainrole < '2')
Windows 2000 client computers
SELECT TOP 100 PERCENT dbo.tblComputers.Computername AS Computer, dbo.tblOperatingsystem.Description, dbo.tblComputers.Domain,
dbo.tblOperatingsystem.Caption, dbo.tblOperatingsystem.Lastchanged
FROM dbo.tblOperatingsystem INNER JOIN
dbo.tblComputers ON dbo.tblOperatingsystem.Computername = dbo.tblComputers.Computername
WHERE (dbo.tblOperatingsystem.Version = '5.0.2195')
ORDER BY dbo.tblComputers.Domain