Solved

Query SMS for machines with Office 2003?

Posted on 2008-09-29
2
855 Views
Last Modified: 2013-11-21
I am trying to create an automatic system in SMS to upgrade machines from Office 2003 to Office 2007.  Fairly simple... Create collection of machines without office 2007, create program to push it, advertise on a reoccurring schedule.

Only problem is, I can't for the life of me get a collection that accurately depicts Office 2007.  Anyone have a query statement I could use, or provide guidance?
0
Comment
Question by:tbkurtz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 29

Accepted Solution

by:
matrixnz earned 500 total points
ID: 22603879
Easiest method is to use Add/Remove Programs Display name, this is normally the most accurate method for detecting software installations, you could use software inventory, however this method can be very inaccurate.

If you need help with the query feel free to ask.

Cheers
0
 

Author Closing Comment

by:tbkurtz
ID: 31501152
This works, but I realised my issue is not my query, I am having separate issues with clients reporting in to SMS.

Thanks for the answer.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question