yes. nice edit. On Fri, Sep 9, 2016 at 4:02 PM, Hatem Mohamed <[email protected]> wrote:
> 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:* [email protected] [mailto:listsadmin@lists. > myitforum.com] *On Behalf Of *Brian McDonald > *Sent:* Friday, September 9, 2016 1:07 PM > *To:* [email protected] > *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:* [email protected] <[email protected]> > on behalf of Todd Hemsell <[email protected]> > *Sent:* Friday, September 2, 2016 4:17:47 PM > *To:* [email protected] > *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 <[email protected]> > 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:* [email protected] <[email protected]> > on behalf of Marcum, John <[email protected]> > *Sent:* Wednesday, August 31, 2016 6:50:46 AM > *To:* [email protected] > *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:* [email protected] [mailto:listsadmin@lists. > myitforum.com] *On Behalf Of *Brian McDonald > *Sent:* Tuesday, August 30, 2016 2:33 PM > *To:* [email protected] > *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:* [email protected] <[email protected]> > on behalf of Marcum, John <[email protected]> > *Sent:* Tuesday, August 30, 2016 1:07:40 PM > *To:* '[email protected]' > *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:* '[email protected]' <[email protected]> > *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:* [email protected] [mailto:listsadmin@lists. > myitforum.com <[email protected]>] *On Behalf Of *Brian > McDonald > *Sent:* Tuesday, August 30, 2016 12:45 PM > *To:* [email protected] > *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 <[email protected]> wrote: > > What do you want to know? Just the computer names for 1 and 2? > > > > *From:* [email protected] [mailto:listsadmin@lists. > myitforum.com <[email protected]>] *On Behalf Of *Brian > McDonald > *Sent:* Tuesday, August 30, 2016 12:25 PM > *To:* [email protected] > *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. > > > > > > > > > > > > > > > > > > > >
