I have tried to generate the report with the software title and install count of the software. I have used the Product, ProductFile, FileInfo and FileInfoInstance tables. I have received the expected report when I use these tables.
But I have the results are wrong for some software titles. After that I did an analysis on the records which I felt wrong.
I have taken the “Microsoft Office Communicator 2005” and check it in the product table. The product table is having the 3 records for the “Microsoft Office Communicator 2005” with the different Product_Idn.
select p.Product_Idn,p.title ,p.Publisher
from Product p
where title ='Microsoft Office Communicator 2005'
Product_Idn title Publisher
82 Microsoft Office Communicator 2005 Microsoft Corporation
39735 Microsoft Office Communicator 2005 Microsoft Corporation
27545 Microsoft Office Communicator 2005 Microsoft Corporation
I am getting the wrong result because of title duplication in the product table.
- Why is there duplication for the same software?
- Could you explain me “How do the LANDesk populate the product table?”
- Is there any website link to get all the table population logic?