→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
SEC_ALERTS
Engaged Sweeper
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.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

2 REPLIES 2
SEC_ALERTS
Engaged Sweeper
Thank You !!!
Hemoco
Lansweeper Alumni
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

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now