Wednesday, February 11, 2015

Lansweeper Report to list most Paidware Adobe software

Find attached a query to list most Adobe Paidware software.

Attributes will be listed in the following order:
AsstName | AssetTypename | IPAdress | Lastseen | SoftwareName | Username

Copy and paste the following query to your ReportBuilder in Lansweeper.


Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblSoftwareUni.softwareName,
  tblAssets.Username
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
  Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where (tblSoftwareUni.softwareName Like 'adobe acrobat%') Or
  (tblSoftwareUni.softwareName Like 'Adobe Photoshop%') Or
  (tblSoftwareUni.softwareName Like 'Adobe Creative Cloud%') Or
  (tblSoftwareUni.softwareName Like 'Adobe Illustrator%') Or
  (tblSoftwareUni.softwareName Like 'Adobe InDesign%') Or
  (tblSoftwareUni.softwareName Like 'Adobe Premiere%') Or
  (tblSoftwareUni.softwareName Like 'Adobe After Effects%') Or
  (tblSoftwareUni.softwareName Like 'Adobe Audition%') Or
  (tblSoftwareUni.softwareName Like 'Adobe Connect%') Or
  (tblSoftwareUni.softwareName Like 'Adobe Audition%') Or
  (tblSoftwareUni.softwareName Like 'Adobe Creative Suite%') Or
  (tblSoftwareUni.softwareName Like 'Adobe Dreamweaver%') Or
  (tblSoftwareUni.softwareName Like 'Adobe Edge%') Or
  (tblSoftwareUni.softwareName Like 'Adobe eLearning Suite%') Or
  (tblSoftwareUni.softwareName Like 'Adobe ExtendScript Toolkit%') Or
  (tblSoftwareUni.softwareName Like 'Adobe Extension Manager%') Or
  (tblSoftwareUni.softwareName Like 'Adobe Fireworks%') Or
  (tblSoftwareUni.softwareName Like 'Adobe Flash Builder%') Or
  (tblSoftwareUni.softwareName Like 'Adobe Flash Professional%') Or
  (tblSoftwareUni.softwareName Like 'Adobe Illustrator%') Or
  (tblSoftwareUni.softwareName Like 'Adobe InCopy%') Or
  (tblSoftwareUni.softwareName Like 'Adobe InDesign%') Or
  (tblSoftwareUni.softwareName Like 'Adobe Media Encoder%') Or
  (tblSoftwareUni.softwareName Like 'Adobe Muse%') Or
  (tblSoftwareUni.softwareName Like 'Adobe Photoshop%') Or
  (tblSoftwareUni.softwareName Like 'Adobe Prelude%') Or
  (tblSoftwareUni.softwareName Like 'Adobe Scout%') Or
  (tblSoftwareUni.softwareName Like 'Adobe SpeedGrade') Or
  (tblSoftwareUni.softwareName Like 'Lightroom%') Or
  (tblSoftwareUni.softwareName Like 'Adobe Bridge%' And tblAssetCustom.State =
  1)

No comments:

Post a Comment