→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
gfunk1
Engaged Sweeper II
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?
1 ACCEPTED SOLUTION
MikeMc
Champion Sweeper II
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

View solution in original post

1 REPLY 1
MikeMc
Champion Sweeper II
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