Report for PCs in the Last 24 Hours

[gfunk1]

Hello, there was a similar question posted to the one I have here, it was titled Report for multiple criteria. This is very close to what I am trying to do, however, instead of needing computers to be in a specific AD group I am looking for the following:

PCs created in the last 24 hours
A column showing if a specific software is installed

I don't want the report to eliminate the PCs created in the last 24 hours IF the software is or is not installed. I'd rather it just have that field blank or show FALSE or something while maintaining the list of PCs found in the last 24 hours.

I'm sure this can be accomplished, would anyone have any pointers?

[MikeMc · Accepted solution]

This report will get you started. You'll need to change the software name on line 11.

Select Distinct Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  (Case When T1.AssetID Is Not Null Then 'Found' Else 'Not Found'
  End) As SoftwareCheck,
  tblAssets.Firstseen
From tblAssets
  Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
  Left Join (Select tblSoftware.AssetID
  From tblSoftware
    Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
  Where tblSoftwareUni.softwareName Like '%Adobe%') T1 On T1.AssetID =
    tblAssets.AssetID
Where tblAssets.Firstseen >= DateAdd(hh, -24, GetDate()) And
  tblAssetCustom.State = 1 And tblAssets.Assettype = -1