→ 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: 
S_B
Engaged Sweeper II
I have 2 Reports with assets.
Some assets are in both assets, but I would like to have only thoese assets who are either missing in the first or the second report.
How can I compare 2 reports with each other ?

Thanks for answers.
BR Sascha
1 REPLY 1
Jelly
Engaged Sweeper
For starters, what do you want to return for this new report? Assets that don't appear in either report OR assets that appear in one report but not the other?

As for referencing a report that already exists, you can do something like this:
SELECT    AssetID    FROM    webfubeyxtyyv6gmy00ssrhm2yjt5n1loyyw0cb7

When you open a report that already exists your URL will contain the report id, should be similar to the web[...] above.
This will run the query fresh from the referenced report and select the assetID of systems that the referenced report returns (Only works here if the referenced report also selects assetID).

Alternatively, you can create subqueries in your new report that contain the same code from your other reports.
Example:

SELECT
tblAssets.AssetID,
tblAssets.AssetName

FROM tblAssets

Where
tblAssets.AssetID in (
SELECT tblAssets.AssetID
FROM tblSoftware
INNER JOIN tblSoftwareUni ON tblSoftware.softID = tblSoftwareUni.SoftID
WHERE tblSoftwareUni.softwareName like 'java%'
)

AND tblAssets.AssetID not in (
SELECT tblAssetCustom.AssetID
FROM tblAssetCustom
WHERE tblAssetCustom.State <> 1
)

Order By tblAssets.AssetName


Or depending on your reports you might be able to combine them. I would need more info to be more specific.