Report for laptops without a certain file

[poweld1]

Can I get help for a report for laptops that are missing a certain file. I am scanning for the file in question.

[poweld1]

Thanks that works fine.

[Hemoco · Accepted solution]

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]

Thanks but it needs to return laptops only, how can I do this? Thanks

[Hemoco]

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