locked
SQL Query for machines with Office 2010 x64 bit version RRS feed

  • Question

  • Hi All, how would you all run a sql report for office 2010 x64bit? I see that from Add/Remove program both x32 and x64 is listed the same way?

    How about this?

     

    SELECT     TOP (100) PERCENT dbo.v_R_System.Netbios_Name0, dbo.v_GS_SoftwareFile.FileName, dbo.v_GS_SoftwareFile.FileVersion,
                          dbo.v_GS_SoftwareFile.FilePath
    FROM         dbo.v_GS_SYSTEM INNER JOIN
                          dbo.v_R_System ON dbo.v_GS_SYSTEM.ResourceID = dbo.v_R_System.ResourceID INNER JOIN
                          dbo.v_GS_SoftwareFile ON dbo.v_GS_SYSTEM.ResourceID = dbo.v_GS_SoftwareFile.ResourceID
    WHERE     (dbo.v_GS_SoftwareFile.FilePath LIKE '%Program Files%' or
                          dbo.v_GS_SoftwareFile.FilePath LIKE '%Program Files (x86)%') and (dbo.v_GS_SoftwareFile.FileName like '%OUTLOOK.EXE%')
    ORDER BY dbo.v_R_System.Netbios_Name0

    Thursday, December 29, 2011 5:00 PM

Answers

  • IMO the easiest way to do this is via the 64bit ARP only 64bit application will be listed.

     

    Try this http://tinyurl.com/bnqt9bb


    http://www.enhansoft.com/
    • Marked as answer by Massara Friday, December 30, 2011 2:21 PM
    Thursday, December 29, 2011 10:05 PM

All replies

  • I would use the Add/remove programs displayname to get the Office installations.
    Kent Agerlund | My blogs: blog.coretech.dk/kea and SCUG.dk/ | Twitter: @Agerlund | Linkedin: Kent Agerlund
    Thursday, December 29, 2011 5:27 PM
  • I would use the Add/remove programs displayname to get the Office installations.
    Kent Agerlund | My blogs: blog.coretech.dk/kea and SCUG.dk/ | Twitter: @Agerlund | Linkedin: Kent Agerlund


    I think he's saying that both x64 and x86 have the exact same display name in ARP. If that's the case it's not gonna be easy. For instance I run x86 office on x64 windows so my install path for office is program files (x86) but that is x86 office. If I were running x64 it may be in program files but on an x86 OS with x86 office it would also be in program files so the instal path isn't a reliable way to know whether or not office is x64.

     


    John Marcum | http://myitforum.com/cs2/blogs/jmarcum/|
    Thursday, December 29, 2011 6:55 PM
  • Yeap I want to query for machines that have Office 2010 x64 bit version
    Thursday, December 29, 2011 7:04 PM
  • IMO the easiest way to do this is via the 64bit ARP only 64bit application will be listed.

     

    Try this http://tinyurl.com/bnqt9bb


    http://www.enhansoft.com/
    • Marked as answer by Massara Friday, December 30, 2011 2:21 PM
    Thursday, December 29, 2011 10:05 PM
  • I see thanks Garth and All

     

    SELECT

          CS.Name0,

          ARP64.DisplayName0,

          ARP64.Version0

     FROM

          dbo.v_GS_COMPUTER_SYSTEM CS

          join dbo.v_GS_ADD_REMOVE_PROGRAMS_64 ARP64 on CS.ResourceID = ARP64.ResourceID

    Where

          ARP64.DisplayName0 like '%Microsoft Office Professional Plus 2010%'

    Friday, December 30, 2011 2:21 PM