lagl.blogg.se

TblSoftware.softwareName Like 'Adobe Extension Manager CS4.exe' Or tblSoftware.softwareName Like 'Adobe Extension Manager CS5.exe' Or tblSoftware.softwareName Like 'Adobe Flash Catalyst.exe' Or tblSoftware.softwareName Like 'Adobe Media Encoder.exe' Or tblSoftware.softwareName Like 'Adobe OnLocation.exe' Or tblSoftware.softwareName Like 'Adobe Premiere Elements 7.0.exe' Or tblSoftware.softwareName Like 'Adobe Premiere Elements 8.0.exe' Or tblSoftware.softwareName Like 'Adobe Premiere Elements 9.exe' Or tblSoftware.softwareName Like 'Adobe Premiere Elements.exe' Or tblSoftware.softwareName Like 'Adobe Premiere Pro.exe' Or tblSoftware.softwareName Like 'Adobe Soundbooth CS3.exe' Or tblSoftware.softwareName Like 'Adobe Soundbooth CS4.exe' Or tblSoftware.softwareName Like 'Adobe Soundbooth CS5.exe' Or tblSoftware.softwareName Like 'Adobe Stock Photos CS3.exe' Or tblSoftware.softwareName Like 'Adobe Ultra.exe' Or TblSoftware.softwareName Like 'Adobe Encore.exe' Or

TblSoftware.softwareName Like 'Adobe Encore DVD.exe' Or TblSoftware.softwareName Like 'Adobe Drive.exe' Or TblSoftware.softwareName Like 'AcroRd32.exe' Or

TblSoftware.softwareName Like 'Acroex32.exe' Or TblSoftware.softwareName Like 'acrodist.exe' Or

TblSoftware.softwareName Like 'AcrobatElementsServer.exe' Or TblSoftware.softwareName Like 'Acrobat.exe' Or TblSoftware.softwareName Like 'Acrobat Elements.exe' Or TblSoftware.softwareName Like 'acroaum.exe' Or TblSoftware.softwareName Like 'Accelio Integrate Suite.msc' Or TblSoftware.softwareName Like 'A3DReviewer.exe' Or

Select Distinct Top 1000000 As Software, As Version, Count() As Total From dbo.tblSoftware Inner Join dbo.tblComputers On = Inner Join dbo.web40ActiveComputers On = Where (tblSoftware.softwareName Like '3D Toolkit.exe' Or So my question is, How do I build a report with all of these things: I found a way to get it but now they are wanting more information. exe files that they are wanting installed numbers for. I have recently been tasked with doing an audit of all Adobe software installed on our machines (500+).