SMS Query for Office XP

[alcachofa]

I cannot create a working collection to list Office XP SP2 or SP3 systems. The thing is that I have created several different queries and they work fine, but when I create the collection based in any of these queries it does not work, does not list anything at all.

The query I am currently using to list all Office XP SP3 systems is:

select distinct SMS_R_System.Name, SMS_G_System_OPERATING_SYSTEM.Name, SMS_G_System_SoftwareProduct.ProductName, SMS_G_System_SoftwareProduct.ProductVersion from SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_SoftwareProduct on SMS_G_System_SoftwareProduct.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareProduct.ProductName like "%Office XP%" and SMS_G_System_SoftwareProduct.ProductVersion = "10.0.6626" order by SMS_R_System.Name

I found this document useful to know how to check the version of Office XP:

http://support.microsoft.com/default.aspx?scid=kb;[LN];291331

Can someone post what query you use to check for Office XP version? Is there any way to check the file version of mso.dll?

Thank you.

 

[Mich]

If your query works fine through QA, but your collections aren't populating it might be an issue with updating your collection.

Right-click the collection, All Task, Update Collection Membership.

-If it ain't broke, break it and make it better.

 

[alcachofa]

I have tried to refresh and to update the collection membership but that does not work either. Any other suggestion please?

 

[Mich]

Here's one that works for me,

Select SYS.Netbios_Name0, SYS.User_Name0, SP.ProductName, SP.CompanyName, SP.ProductVersion
FROM v_GS_SoftwareProduct SP
JOIN v_R_System SYS on SP.ResourceID = SYS.ResourceID
WHERE SP.ProductName like '%Office XP%' AND SP.ProductVersion = '10.0.6626' 
Order by SP.ProductName, SP.ProductVersion

There are some tables in your query that I'm not familiar with. That might be the problem or you might have just renamed them.

-If it ain't broke, break it and make it better.