That is because Office can have anywhere from 1 to 4 entries for a given product. For the Office suite, it generally has two listings within ARP data.
From: listsadmin@lists.myitforum.com [mailto:listsadmin@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Wednesday, April 27, 2016 2:00 PM To: ms...@lists.myitforum.com Subject: [mssms] SW query counts too high? Good day, I ran a SQL query against my all desktop collection which contains approximately 700 devices. The query I am using is documented here: http://smsug.ca/blogs/garth_jones/archive/2013/02/07/microsoft-true-up-report.aspx I am confused as to why the counts came back so high. Here are the results: Microsoft Office Professional Plus 2013 - 1400 Microsoft Office Professional Plus 2010 - 20 Microsoft Office 2010 Service Pack 1 (SP1) - 244 2007 Microsoft Office Suite Service Pack 1 (SP1) - 10 I only have 700 devices so why is my count above 1500? Thanks, Brian