→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎10-05-2011 03:36 PM
Solved! Go to Solution.
‎10-06-2011 01:44 PM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblFileVersions.Found
From tblComputers Inner Join
tblFileVersions On tblComputers.Computername = tblFileVersions.Computername
Inner Join
tblSystemEnclosure On tblComputers.Computername =
tblSystemEnclosure.Computername Inner Join
TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes
Where tblFileVersions.Found = '0' And tblFileVersions.FilePathfull Like
'%YourFile%' And TsysChassisTypes.ChassisName = 'laptop'
‎10-06-2011 03:15 PM
‎10-06-2011 01:44 PM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblFileVersions.Found
From tblComputers Inner Join
tblFileVersions On tblComputers.Computername = tblFileVersions.Computername
Inner Join
tblSystemEnclosure On tblComputers.Computername =
tblSystemEnclosure.Computername Inner Join
TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes
Where tblFileVersions.Found = '0' And tblFileVersions.FilePathfull Like
'%YourFile%' And TsysChassisTypes.ChassisName = 'laptop'
‎10-06-2011 11:56 AM
‎10-05-2011 06:27 PM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblFileVersions.Found
From tblComputers Inner Join
tblFileVersions On tblComputers.Computername = tblFileVersions.Computername
Where tblFileVersions.Found = '0' And tblFileVersions.FilePathfull Like
'%YourFile%'
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now