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