Community FAQ
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.

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

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

Try Now