Also if you have any retire systems that could be in the collection you used it will include them. Try using dbo.v_FullCollectionMembership_Valid. At least it will cut down on the possibility.
Rob Carlson | Senior SMS - Patch Management Engineer Vanguard 2.2.1 Contract | SAIC Team | Strategic Business Systems Supporting IRM/OPS/ENM/NED/SLM Desk phone: (703) 372-4832 | Mobile phone: (703) 597-3680 Annex/Location: TOATS 204 | email: carlso...@state.gov<mailto:carlso...@state.gov> Please consider the environment before printing this email. Can't find a patch? Try searching (CTRL-F) ftp://patchopnftp2.appservices.state.sbu/PatchListing.pdf. NEW Known Issues on FAQs Page: http://irm.m.state.sbu/sites/ops/ENM/NED/SLM/EPM/Lists/FAQs/AllItems.aspx?InitialTabId=Ribbon%2EListItem&VisibilityContext=WSSTabPersistence CLASSIFICATION: UNCLASSIFIED This e-mail is unclassified based on the definitions of E.O. 12958 From: listsadmin@lists.myitforum.com [mailto:listsadmin@lists.myitforum.com] On Behalf Of Garth Jones Sent: Wednesday, April 27, 2016 3:33 PM To: ms...@lists.myitforum.com Subject: [mssms] RE: SW query counts too high? 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> [http://redirect.state.sbu/?url=mailto:listsadmin@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Wednesday, April 27, 2016 2:00 PM To: ms...@lists.myitforum.com<mailto: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://redirect.state.sbu/?url=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
