

I am still getting duplicate Product Keys for the same product. I cleaned up the code and got better results. Microsoft Office Small Business Edition 2003 Microsoft Office Project Professional 2007 Microsoft Office Access Runtime (English) 2007 Microsoft Office 97, Professional Edition Microsoft Office Project Professional 2003 Microsoft Office Professional Edition 2003 Microsoft Office XP Professional with FrontPage

I put %Microsoft office% since there are too many variants of MS office installed on our network. I'm trying to find out who has MS Office installed and alongside with that I am trying to find out the product key and the product ID of every MS office version installed on every workstation on the network.
#Microsoft frontpage 2003 key software#
My question is, how come I am getting 2 product ID's and 2 product Keys for the same computer and the same software ? SoftwareĜomputerName Installdate Lastchanged LastknownIP ProductKey ProductID The report for some reason gives me duplicate product ID and product Key. INNER JOIN tblSerialnumber ON ( = tblSerialnumber.Computername)ĭbo.tblSoftware.softwareName LIKE '%Microsoft Office%' INNER JOIN tblComputers ON ( = tblComputers.Computername)
