10-23-2011 07:27 PM
10-25-2011 05:45 PM
10-25-2011 10:50 AM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, web40allcompstates.Thestate, tblstate.Statename
From tblComputers Left Join
web40allcompstates On web40allcompstates.Computername =
tblComputers.Computername Left Join
tblstate On tblstate.State = web40allcompstates.Thestate
Where tblstate.Statename Not Like 'Non-active'
Order By tblComputers.ComputerUnique
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now