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,
  tsysAssetTypes.AssetTypeIcon10 As icon,
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 =

No comments:

Post a Comment