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. >> >> >> >> >> >> >> >> >> >> >> > > >