07-19-2010 05:28 PM
07-20-2010 10:10 PM
Select Top 1000000 dbo.tblComputers.ComputerUnique,
dbo.tblComputers.Computername, dbo.tblComputers.Username,
tblADusers.Displayname, tblADusers.Department, tblDiskdrives.Caption,
tblDiskdrives.Description
From dbo.tblComputers Inner Join
tblDiskdrives On dbo.tblComputers.Computername = tblDiskdrives.Computername
Inner Join
tblADusers On tblADusers.Username = dbo.tblComputers.Username And
tblADusers.Userdomain = dbo.tblComputers.Userdomain
Where tblDiskdrives.Description Like '%Removable%'
07-20-2010 12:32 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now