Find computers with Outlook 2007 is installed

[AMD]

Hello,

 

please help me to find all computers with Outlook 2007 installed...

 

we have installed Office 2007 enterprise and Office 2007 professional..

 

and please exclude Outlook 2003 from this query, because some people using this program..

 

Thank you very much.

[Eswar Koneti]

Hello,

 

please help me to find all computers with Outlook 2007 installed...

 

we have installed Office 2007 enterprise and Office 2007 professional..

 

and please exclude Outlook 2003 from this query, because some people using this program..

 

Thank you very much.

 

Try this out should give you all the computers with outlook 2007 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 "%Microsoft office outlook%" and SMS_G_System_ADD_REMOVE_PROGRAMS.Version like "12.0%"

[AMD]

Try this out should give you all the computers with outlook 2007 installed:

 

Thanks...

 

it's seems to be working as well.