Hello me again 🙂
I can'tt do with Build Report neested SQL query, have you suggentstion?
When I tried this for examplme, system change anc give me error on Inner
Select Top 1000000 tblAssets.AssetUnique,
tblAssets.Domain,
tblADComputers.Description,
tblAssets.AssetID,
tblADComputers.Lastchanged,
tblAssets.Lastseen
From tblAssets
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Where tblAssets.AssetUnique Not Like '%ita-acs%' And
tblAssets.Lastseen Is Not Null
and tblAssets.AssetID not in
(Select tblAssets.AssetID
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where
tblSoftwareUni.softwareName Like '%Microsoft Operations Manager 2005 Agent%')
Stefano
