<div>
This works, but I realised my issue is not my query, I am having separate issues with clients reporting in to SMS.<br />
<br />
Thanks for the answer.
</div>


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.

<div>
<div class="content wysiwyg-content">
I am trying to create an automatic system in SMS to upgrade machines from Office 2003 to Office 2007. &nbsp;Fairly simple... Create collection of machines without office 2007, create program to push it, advertise on a reoccurring schedule.<br />
<br />
Only problem is, I can't for the life of me get a collection that accurately depicts Office 2007. &nbsp;Anyone have a query statement I could use, or provide guidance?
</div>
</div>


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?

Query SMS for machines with Office 2003?

The Microsoft Server topic includes all of the legacy versions of the operating system, including the Windows NT 3.1, NT 3.5, NT 4.0 and Windows 2000 and Windows Home Server versions.

Microsoft Server OS

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).

Windows Server 2003

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.