→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
01-26-2011 08:28 PM
Solved! Go to Solution.
01-27-2011 09:40 AM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, TsysChassisTypes.ChassisName, tblNetwork.Description
From tblComputers Inner Join
tblSystemEnclosure On tblComputers.Computername =
tblSystemEnclosure.Computername Inner Join
TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes Inner Join
tblNetwork On tblComputers.Computername = tblNetwork.Computername
Where (tblSystemEnclosure.ChassisTypes = 8 Or tblSystemEnclosure.ChassisTypes =
9 Or tblSystemEnclosure.ChassisTypes = 10)
Order By tblComputers.ComputerUnique
By the way, How can i create a table like tblNetworkController?
01-31-2011 10:04 PM
01-27-2011 09:40 AM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, TsysChassisTypes.ChassisName, tblNetwork.Description
From tblComputers Inner Join
tblSystemEnclosure On tblComputers.Computername =
tblSystemEnclosure.Computername Inner Join
TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes Inner Join
tblNetwork On tblComputers.Computername = tblNetwork.Computername
Where (tblSystemEnclosure.ChassisTypes = 8 Or tblSystemEnclosure.ChassisTypes =
9 Or tblSystemEnclosure.ChassisTypes = 10)
Order By tblComputers.ComputerUnique
By the way, How can i create a table like tblNetworkController?
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now