Hi,
I have a report which shows me all clients where a certain deployment is older than X days. Now I want to add to the same report the clients, where the deployments was never executed.
Is this possible and if not, is it possible to creats this in a seperated report?
Thank you all.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
web50repwindeploymentlogs.Package,
Max(web50repwindeploymentlogs.LogDate) As LastInstall,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join web50repwindeploymentlogs On tblAssets.AssetID =
web50repwindeploymentlogs.AssetID
Where web50repwindeploymentlogs.Package Like 'DriverUpdate - Test' And
tblAssetCustom.Manufacturer Like 'Hewlett-Packard' And tblAssetCustom.State =
1
Group By tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
web50repwindeploymentlogs.Package,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model
Having Max(web50repwindeploymentlogs.LogDate) < GetDate() - 0