→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
harringg
Champion Sweeper
I have the following code that will report on installed copies of Outlook 2003. I've modified it to search for 2007 as well changing to: Like '%2007%'

When I modify to: Like '%2010%' I don't get any results.

Is Outlook 2010 called something else when scanned? I know it's installed on machines that have been scanned.

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, tblSoftware.softwareName,
tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher, tblSoftware.Installdate,
tblSoftware.Lastchanged From tblComputers Inner Join tblSoftware On tblComputers.Computername =
tblSoftware.ComputerName Where tblSoftware.softwareName Like '%Outlook%' And tblSoftware.softwareName Like
'%2003%' Order By tblComputers.ComputerUnique
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Outlook may not always be listed as a separate software entry. It may be part of a Microsoft Office package for instance.

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
Outlook may not always be listed as a separate software entry. It may be part of a Microsoft Office package for instance.