Neested query on Build Report

[s_basso]

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

[Hemoco]

Please contact support@lansweeper.com and provide us with:
- A link to this forum thread.
- Screenshot of the error message you are seeing when you try to run this report.