Change this "arp.ResourceID" to "Distinct arp.ResourceID"
On Wed, Apr 27, 2016 at 2:33 PM, Garth Jones <ga...@enhansoft.com> wrote: > 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 > > > >