Office 2007 SP1 query

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

Office 2007 SP1 query

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> Office 2007 SP1 query

Page: [1]

Message

<< Older Topic Newer Topic >>

Office 2007 SP1 query - 10/13/2008 4:27:21 AM

gavoz

Posts: 10
Score: 0
Joined: 7/22/2008
Status: offline

Hi all,
i created 2 simple queries to disply all workstations with and without SP1 for Office 2007 installed.

Office 2007 SP1 is installed:
select SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_System.Name,SMS_R_System.SMSUniqueIdentifier,SMS_R_System.ResourceDomainORWorkgroup,SMS_R_System.Client from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "2007 Microsoft Office Suite Service Pack 1 (SP1)"

Office 2007 SP1 si not installed:
select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where (SMS_R_System.Name != "EP002817" and SMS_R_System.Name != "EP004289" and SMS_R_System.Name != "EP004353" and SMS_R_System.Name != "EP004657" and SMS_R_System.Name != "EP004729" and SMS_R_System.Name != "EP004749" and SMS_R_System.Name != "EP004785" and SMS_R_System.Name != "EP004825" and SMS_R_System.Name != "EP004875" and SMS_R_System.Name != "EP004879" and SMS_R_System.Name != "EP004919" and SMS_R_System.Name != "MULETTO 4" and SMS_R_System.Name != "MULETTO 5" and SMS_R_System.Name != "MULETTO 6" and SMS_R_System.Name != "MULETTO 7" and SMS_R_System.Name != "MULETTO 9" and SMS_R_System.Name != "EP002525" and SMS_R_System.Name != "EP005721" and SMS_R_System.Name != "EP005723" and SMS_R_System.Name != "EP005731" and SMS_R_System.Name != "EP005745" and SMS_R_System.Name != "EP005747" and SMS_R_System.Name != "EP005749" and SMS_R_System.Name != "EP002585" and SMS_R_System.Name != "EP005015" and SMS_R_System.Name != "EP002719" and SMS_R_System.Name != "EP002683" and SMS_R_System.Name != "EP003163" and SMS_R_System.Name != "EP005209" and SMS_R_System.Name != "EP005215" and SMS_R_System.Name != "EP005219" and SMS_R_System.Name != "EP005235" and SMS_R_System.Name != "EP005271" and SMS_R_System.Name != "EP001361" and SMS_R_System.Name != "EP004111" and SMS_R_System.Name != "EP002399" and SMS_R_System.Name != "EP001357" and SMS_R_System.Name != "EP005289" and SMS_R_System.Name != "EP004109" and SMS_R_System.Name != "EP005293" and SMS_R_System.Name != "EP001417" and SMS_R_System.Name != "EP005301" and SMS_R_System.Name != "EP002579" and SMS_R_System.Name != "EP001621") and (SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName != "2007 Microsoft Office Suite Service Pack 1 (SP1)")

Thanks,

-
Andrea Gaviraghi