
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-26-2013 12:22 PM
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.
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.
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-26-2013 01:57 PM
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
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-26-2013 02:48 PM
Thank You !!!

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-26-2013 01:57 PM
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
