SCCM 2007 Queries
Discussion
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.
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.
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...
http://www.windows-noob.com/forums/index.php?/foru...
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff