I see now, been awake too long. Other fella sent the solution On Sat, Sep 10, 2016 at 2:01 AM, Todd Hemsell <hems...@gmail.com> wrote:
> that is the query... do not understand your question, apologies. > > On Fri, Sep 9, 2016 at 12:06 PM, Brian McDonald <mcdonald...@hotmail.com> > wrote: > >> 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 <listsad...@lists.myitforum.com> >> on behalf of Todd Hemsell <hems...@gmail.com> >> *Sent:* Friday, September 2, 2016 4:17:47 PM >> *To:* 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> >> 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 <listsad...@lists.myitforum.com> >>> on behalf of Marcum, John <jmar...@bradley.com> >>> *Sent:* Wednesday, August 31, 2016 6:50:46 AM >>> *To:* 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:listsadmin@lists.myitf >>> orum.com] *On Behalf Of *Brian McDonald >>> *Sent:* Tuesday, August 30, 2016 2:33 PM >>> *To:* 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 <listsad...@lists.myitforum.com> >>> on behalf of Marcum, John <jmar...@bradley.com> >>> *Sent:* Tuesday, August 30, 2016 1:07:40 PM >>> *To:* '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' <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-requiremen >>> t-for-microsoft-office-32-or-64-bit/ >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> *From:* listsad...@lists.myitforum.com [mailto:listsadmin@lists.myitf >>> orum.com <listsad...@lists.myitforum.com>] *On Behalf Of *Brian McDonald >>> *Sent:* Tuesday, August 30, 2016 12:45 PM >>> *To:* 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> wrote: >>> >>> What do you want to know? Just the computer names for 1 and 2? >>> >>> >>> >>> *From:* listsad...@lists.myitforum.com [mailto:listsadmin@lists.myitf >>> orum.com <listsad...@lists.myitforum.com>] *On Behalf Of *Brian McDonald >>> *Sent:* Tuesday, August 30, 2016 12:25 PM >>> *To:* 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. >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >> >> >> >