→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
poweld1
Champion Sweeper
Can I get help for a report for laptops that are missing a certain file. I am scanning for the file in question.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Please try the following query:

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'

View solution in original post

4 REPLIES 4
poweld1
Champion Sweeper
Thanks that works fine.
Hemoco
Lansweeper Alumni
Please try the following query:

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'
poweld1
Champion Sweeper
Thanks but it needs to return laptops only, how can I do this? Thanks
Hemoco
Lansweeper Alumni
Please use the report below. Replace "YourFile".

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%'

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now