Single report for multiple software’s

[SEC_ALERTS]

Hi Team,

We want one report for Adobe and textpad software’s with respect to their publishers.
Adobe software publisher is Adobe and textpad publishers is Helios.
I would have planned to add the more software in the same report.

Thanks in Advance!!!

Regards,
SEC_ALERTS.

[SEC_ALERTS]

Thank You !!!

[Hemoco · Accepted solution]

A sample report that lists Adobe and Helios software can be seen below.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblSoftwareUni.softwareName As software,
tblSoftware.softwareVersion As version,
tblSoftwareUni.SoftwarePublisher As publisher,
tsysOS.Image As icon
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where (tblSoftwareUni.SoftwarePublisher Like '%adobe%' Or
tblSoftwareUni.SoftwarePublisher Like '%helios%') And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
software,
version