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