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..

[skelters]

I use SCCM 2012 R2 and have found this site very helpful if you ever need some info.....

http://www.windows-noob.com/forums/index.php?/foru...

[skelters]

...Or a point in the right direction.

There's a ton of configuration walkthroughs to get the best out of SCCM.

[TheAngryDog]

Legend, thank you very much!

Bookmarked!

[lestag]

Also look at wildcarding the displayname in case there are any slight variations in name or version