This should work for you. The Netbios name from v_R_System_Valid is joined below to allow you to match the computer names to the architecture version of office you're looking for.
Select v_R_System_Valid.Netbios_Name0, v_GS_INSTALLED_SOFTWARE.ARPDisplayName0, v_GS_INSTALLED_SOFTWARE.InstalledLocation0, CASE When v_GS_INSTALLED_SOFTWARE.InstalledLocation0 Like '%(x86)%' Then 'x86' Else 'x64' End AS [DetectedArchitecture] >From v_GS_INSTALLED_SOFTWARE INNER JOIN v_R_System_Valid ON v_GS_INSTALLED_SOFTWARE.ResourceID = v_R_System_Valid.ResourceID Where ARPDisplayName0 = 'Microsoft Office Professional Plus 2013' From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Friday, September 9, 2016 1:07 PM To: mssms@lists.myitforum.com Subject: Re: [mssms] RE: Help with a few SQL queries Todd - this is great! The one thing I need to know is which workstations have this. How do I add that to the query? Thanks, Brian _____ From: listsad...@lists.myitforum.com <mailto:listsad...@lists.myitforum.com> <listsad...@lists.myitforum.com <mailto:listsad...@lists.myitforum.com> > on behalf of Todd Hemsell <hems...@gmail.com <mailto:hems...@gmail.com> > Sent: Friday, September 2, 2016 4:17:47 PM To: mssms@lists.myitforum.com <mailto:mssms@lists.myitforum.com> Subject: Re: [mssms] RE: Help with a few SQL queries Select ARPDisplayName0, InstalledLocation0, CASE When InstalledLocation0 Like '%(x86)%' Then 'x86' Else 'x64' End AS [DetectedArchitecture] >From v_GS_INSTALLED_SOFTWARE Where ARPDisplayName0 = 'Microsoft Office Professional Plus 2013' On Fri, Sep 2, 2016 at 2:16 PM, Brian McDonald <mcdonald...@hotmail.com <mailto:mcdonald...@hotmail.com> > wrote: Sorry, a bit of a newbie with this. How exactly to I pull the data? Can someone provide a sample query? Thank you, Brian _____ From: listsad...@lists.myitforum.com <mailto:listsad...@lists.myitforum.com> <listsad...@lists.myitforum.com <mailto:listsad...@lists.myitforum.com> > on behalf of Marcum, John <jmar...@bradley.com <mailto:jmar...@bradley.com> > Sent: Wednesday, August 31, 2016 6:50:46 AM To: mssms@lists.myitforum.com <mailto:mssms@lists.myitforum.com> Subject: RE: [mssms] RE: Help with a few SQL queries Once that key is inventoried you will have a custom view with the data you need. From: listsad...@lists.myitforum.com <mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com <mailto:listsad...@lists.myitforum.com> ] On Behalf Of Brian McDonald Sent: Tuesday, August 30, 2016 2:33 PM To: mssms@lists.myitforum.com <mailto:mssms@lists.myitforum.com> Subject: Re: [mssms] RE: Help with a few SQL queries This is great. Thanks John. I'll extend the MOF key. Once I've done that, what is the best way to pull inventory on those clients with that particular REG key? Thank you! Brian _____ From: listsad...@lists.myitforum.com <mailto:listsad...@lists.myitforum.com> <listsad...@lists.myitforum.com <mailto:listsad...@lists.myitforum.com> > on behalf of Marcum, John <jmar...@bradley.com <mailto:jmar...@bradley.com> > Sent: Tuesday, August 30, 2016 1:07:40 PM To: 'mssms@lists.myitforum.com <mailto:mssms@lists.myitforum.com> ' Subject: RE: [mssms] RE: Help with a few SQL queries Guess I could have been more specific on my reply here.. I don't know of a way to get the Office bitness out of the box so if I wanted to know that and I wasn't using something like BDNA I'd use regkeytomof to inventory the key Ronni mentions in his blog. Then I'd use that in my report. From: Marcum, John Sent: Tuesday, August 30, 2016 1:01 PM To: 'mssms@lists.myitforum.com <mailto:mssms@lists.myitforum.com> ' <mssms@lists.myitforum.com <mailto:mssms@lists.myitforum.com> > Subject: RE: [mssms] RE: Help with a few SQL queries May need to do something like this to find the Office architecture. https://www.ronnipedersen.com/2012/11/application-requirement-for-microsoft- office-32-or-64-bit/ From: listsad...@lists.myitforum.com <mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Tuesday, August 30, 2016 12:45 PM To: mssms@lists.myitforum.com <mailto:mssms@lists.myitforum.com> Subject: Re: [mssms] RE: Help with a few SQL queries Server names for 1 and Computer names for 2. Thank you! Brian On Aug 30, 2016, at 12:37 PM, Marcum, John <jmar...@bradley.com <mailto:jmar...@bradley.com> > wrote: What do you want to know? Just the computer names for 1 and 2? From: listsad...@lists.myitforum.com <mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Tuesday, August 30, 2016 12:25 PM To: mssms@lists.myitforum.com <mailto:mssms@lists.myitforum.com> Subject: [mssms] Help with a few SQL queries Hello, I need to compile a few reports. 1) List of all servers by domain 2) All Office 2013 with x86 Architecture Does anyone have any samples they can share for each of these? Thanks, Brian _____ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer.