How to identify which computers are missing Microsoft Office

Brock Bingham candid headshot
Brock Bingham|December 19, 2022
Which computers are missing Microsoft Office?
Which computers are missing Microsoft Office?

Some people love Microsoft Office, and other people, not so much. If you’re anything like me, you keep removing Office from your PC, and your IT department keeps reinstalling it. But how does the IT department know I keep removing Office? Because PDQ Inventory isn’t just great at identifying what apps are installed on a device — it can also quickly identify which apps aren’t installed on a device.

How to create a collection of computers missing Microsoft Office in PDQ Inventory

Here’s how easy it is to create a collection in PDQ Inventory that identifies computers missing Microsoft Office:

  1. In PDQ Inventory, expand Collection Library, then Office Suites.

  2. Right-click on the Microsoft Office collection, then click Duplicate.

    Duplicating dynamic collections

  3. You’ll find the duplicated collection at the bottom of your collections list. Double-click it to open the collection details window.

  4. Rename the collection to something like Computers Missing Microsoft Office, and change the description.

  5. Change the primary filter of the collection to Not Any.

    Collection filters to group computers missing Microsoft Office

  6. When you’re finished, click OK to save and close the collection.

How much time did that take? Five minutes? Here’s a PDQ pro tip: If your boss doesn’t know how fast and efficient PDQ Inventory is, you can easily play it off and make it seem like creating the collection took a solid few hours. Kick back and relax for a while — your secret’s safe with us.

How to generate an Auto Report based on a collection in PDQ Inventory

What’s that? You’ve got five more minutes to spare? In that case, why don’t we make good use of it and create an Auto Report in PDQ Inventory based on our new collection? That should definitely get you nominated for employee of the month.

  1. Right-click on the Computers Missing Microsoft Office collection.

  2. Click New > Report From Collection. This action automatically adds the filters from the collection to the report.

    Building a report from a collection

  3. Click Save, then close the report window.

    Saving reports

  4. Click Auto Reports.

  5. Click New.

    Creating a new auto report schedule

  6. Enter a name for the Auto Report, a path to where the report will save, a file name, and a file type (or format) to save the report as. You can select from several prebuilt file name formats using the drop-down menu.

    Configuring auto report details

  7. Click the Triggers tab.

  8. Select the trigger that works best for your schedule. Since this isn’t a frequently requested report, I’ll configure it to automatically generate the first day of every month using the Monthly trigger.

    Setting triggers for the auto report

  9. If you want to configure the report to send via email, you can do so in the Mail tab. You’ll need to ensure your mail setting are configured in the Tools > Preferences > Mail Server page.

  10. Click on the Reports tab, then click Attach.

  11. Locate and select the Computers Missing Microsoft Office report.

    Attaching the report to the auto report schedule

  12. Click OK to save and close the Auto Report window.

In about ten minutes, we created a collection to group computers without Microsoft Office, a report to identify the collection members, and an Auto Report schedule to automatically generate the monthly report. I’d say that’s ten minutes well spent.

PDQ Inventory: I hope you enjoy free time

With PDQ Inventory, tasks that would typically take hours or days to complete can be accomplished in minutes. No more stressing about which devices have which software. Or better yet, which devices are missing a specific software.

Looking to free up some “me” time at work? Download a 14-day trial of PDQ Inventory and Deploy today. You’ll be up and running in minutes. Once you’ve got everything configured, the real question is, what will you do with all the time you’ll be saving? I recommend crocheting. Who doesn’t like homemade scarves and beanies?

Brock Bingham candid headshot
Brock Bingham

Born in the '80s and raised by his NES, Brock quickly fell in love with everything tech. With over 15 years of IT experience, Brock now enjoys the life of luxury as a renowned tech blogger and receiver of many Dundie Awards. In his free time, Brock enjoys adventuring with his wife, kids, and dogs, while dreaming of retirement.

Related articles