ā05-08-2012 06:15 PM
Solved! Go to Solution.
ā06-13-2012 01:43 PM
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Firstseen, tblComputers.Lastseen, tblComputers.LastknownIP,
tblRegistry.Regkey, tblRegistry.Valuename, tblRegistry.Value
From tblComputers Inner Join
tblRegistry On tblComputers.Computername = tblRegistry.Computername
Where (tblRegistry.Valuename = 'YourValue1') Or
(tblRegistry.Valuename = 'YourValue2')
Order By tblComputers.ComputerUnique, tblRegistry.Regkey
ā06-13-2012 01:43 PM
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Firstseen, tblComputers.Lastseen, tblComputers.LastknownIP,
tblRegistry.Regkey, tblRegistry.Valuename, tblRegistry.Value
From tblComputers Inner Join
tblRegistry On tblComputers.Computername = tblRegistry.Computername
Where (tblRegistry.Valuename = 'YourValue1') Or
(tblRegistry.Valuename = 'YourValue2')
Order By tblComputers.ComputerUnique, tblRegistry.Regkey
ā06-12-2012 09:21 PM
ā05-08-2012 09:03 PM
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblADusers.Displayname, tblRegistry.Valuename, tblRegistry.Value
From tblComputers Inner Join
tblADusers On tblComputers.Username = tblADusers.Username Inner Join
tblCompCustom On tblComputers.Computername = tblCompCustom.Computername
Inner Join
tblRegistry On tblComputers.Computername = tblRegistry.Computername
Order By tblComputers.ComputerUnique
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now