SCCM 2007 Queries

[TheAngryDog]

Does anyone here know much about SCCM 2007? I need to find out which systems in a collection has a MS Online Sign-in Assistant installed. Some of the systems are 32 bit and some are 64bit.

This is what I currently have;

select distinct SMS_R_System.Name, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName, SMS_G_System_ADD_REMOVE_PROGRAMS.Version 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 = "Microsoft Online Services Sign-in Assistant" order by SMS_R_System.Name

But this only seems to be picking up 32bit systems.

Can anyone help please?

Thanks.

[TheAngryDog]

I've figured it. Needed to add _64 after the ADD_REMOVE_PROGRAMS bits..

[TheAngryDog]

Legend, thank you very much!

Bookmarked!