1. PDQ Deploy & Inventory Help Center
  2. Community
  3. PDQ Inventory
 

Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.

Running SQL query to find office version

Avatar
Mike Nouri

I need to run A SQL report so as to find out how many devices have office 32 and office 64 bits.

0

Comments

4 comments
Date Votes
  • Avatar
    Christian Bacher

    No need for a complicate SQL Report. You can create a Dynamic Collection based on the Install folder with a file scanner. A 32bit Office on a 64Bit System lays in the (x86) program folder. A 64Bit Office on a 64Bit System in the program folder without (x86). If you still use 32bit Systems, keep in mind that the 32bit Office has the same path like a 64Bit Office on a 64Bit System.

    0
  • Avatar
    Mike Reid

    Is it possible to post the correct filter to setup to find those paths? I am having a bit of trouble with finding out 32bit versions I am trying => Files and Directories > Path > Matches Pattern > C:\Program Files (x86)\Microsoft Office\root

    0
  • Avatar
    Christian Bacher

    Sure, first the scan profile. I'm looking for the excel.exe inside all folders under C:\Program Files (x86)\Microsoft Office**:

    enter image description here

    And then the Collection:

    64bit office on a 64bit system

    enter image description here

    32bit office on a 64bit system

    enter image description here

    32bit systems are not counted here, because a 32bit system only can have a 32bit office installed and the path matches with a 64bit office on a 64bit device.

    If you want to track the 32bit office on a 32bit system too, copy the "64bit office on a 64bit system" collection and change the O/S Architecture from 64-bit to 32-bit.

    0
  • Avatar
    David Hinchman

    Thank you for this! Very helpful

    0