Which computers are missing Microsoft Office?

Shane head shot
Shane Corellian|Updated February 1, 2021
Generic blog header
Generic blog header
    No Data

    We hear variations of this question quite often. Sysadmins write in and say something like “Hey, it’s great that I can see what applications are installed but how can I find the computers that are missing certain applications?”

    This is a valid question and, good news, you can, most likely, have it answered quickly and for free. PDQ Inventory Collections are a great way to organize your office computers by which software is or ISN’T installed. 

    Let’s take Microsoft Office. Out of the box PDQ Inventory has a collection called Systems with Microsoft Office. Under this collection exist 3 child (or sub) collections. The parent collection (systems with Microsoft Office) has a simple filter. Show all computers that have an application containing Microsoft Office in the name. Each child collection has a filter which identifies even more specifically as to whether the computers have 2003, 2007 or 2010 versions of Microsoft Office. That is all fine and good but let’s take this a little farther and identify computers missing Office.

    Since we already have a Collection which already identifies which systems have Microsoft Office you can build a collection which effectively says “show me computers that aren’t in the collection called Systems with Microsoft Office”.

    Use the following steps:

    1. Create a Dynamic Collection called “Systems missing Microsoft Office”

    2. Add a filter type of Collection and specify that any computer cannot be a member of the collection “Systems with Microsoft Office”

    3. Save it and look at the results. Wait… We don’t care about Servers since they will never have Office installed. So let’s define another filter to strip out servers. 

    4. Edit the Collection and add a new Operating System filter (click the blue + icon to add a new filter) where the OS Name does not contain the word “server”. Let’s also add a Never Scanned is False filter to strip out any computer from showing up which has never had an inventory scan.

    Shane head shot
    Shane Corellian

    Shane is the co-founder of PDQ.

    Related articles