PDQ.com mobilePDQ.com desktop
Support

Which computers are missing Microsoft Office?

Shane CorellianShane Corellian
·

We hear variations of this question quite often. Sys Admins 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. (OK, it’s a tad smarter than that, but I’ll get into the specifics of the filter later). 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.

There are two excellent ways to do this. One is slightly more intuitive so we’ll discuss this method today.

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”. Let’s use the following steps:

  • Create a Dynamic Collection called “Systems missing Microsoft Office”

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

  • 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. 

  • 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.

Ready to get started?

Take our 14-day Free Trial.
This round is on us!

Don't miss the next post!

Using PowerShell to Install Printers

When installing printers, we will need to do the four things; Add Driver to the Store, Install the Driver, Create Printer Port, and Install the Printer