Hi,

My company plan to release OneDrive for Business to our staff members for Cloud storage. A number of workstations have Office 2013 installed including the local OneDrive for Business client - however a uncertain number of workstations do not have the OneDrive feature enabled within the Office 2013 installation in our fleet. The goal is to identify these workstations and deploy an Office update to enable the feature.

I've created a device collection (OneDrive Installed - Active Staff PCs last 45 days) to query and filter workstations within our fleet that DO have OneDrive for Business installed and then using this collection to filter workstations that DO NOT have OneDrive for Business installed (OneDrive Not Installed - Active Staff PCs last 45 days).

Collection Name: OneDrive Not Installed - Active Staff PCs last 45 days

Included Collections: Active Staff PCs last 45 days

Excluded Collections: OneDrive Installed - Active Staff PCs last 45 days

Unfortunately I have found many workstations within the OneDrive Installed collection that do not have OneDrive installed and workstations within the OneDrive not Install Collection that do have OneDrive installed! As a result I am not confident in the filter and hesitant to deploy OneDrive for Business to any Device Collection yet.

Below are two querys I have tried to use for filter but both get inconsistency as mentioned above.

First Query

Installed Applications. Display Name is like "%OneDrive for Business%"

or

Installed Applications. Display Name is like "%SkyDrive Pro%"

Second Query

Installed Executable. Executable Name is equal to "GROOVE.EXE"

My question, does any body have a better method in discovering applications via SCCM query's? Should I be searching via product ID instead or any other criteria?

 

I used this website for setting up my collections above http://blogs.technet.com/b/jchalfant/archive/2014/05/09/collection-of-computers-missing-an-application-software-title-in-configuration-manager.aspx

Thank you in advance for any assistance.

Entropy

• Edited by EntropyMAD Friday, June 26, 2015 3:57 AM

Hello,

Have you seen this article?

Use Office Customization Tool (OCT) to change users' configurations after installing Office 2013

Create a customized msp file with OCT, and run it with msiexec

Hi thanks for the reply.

That is the method I am using to deploy OneDrive for Business to our workstations. However the issue is identifying which workstations do not have it installed.

That question cannot be answered without sitting in front of the system. Use Rersource Explorer and examine machines that are / are not in the collection you created in order to find out why the are (not) member of the collection.