Hi . I am looking to build a report that will show all systems in a specific collection that do not have a specific program registered under the add/remove progams . I have tried to build a quer myself but it dosent work pretty well for me since i gives me duplicatets and fulse positives . Does anyone have a similer report created that is willing to share the sql code ? Thanks

Hi,This query will return all computers without .Ne Framework 3.5 SP1installedselect distinct SMS_R_System.Name from SMS_R_System where SMS_R_System.Name not in (select distinct SMS_R_System.Name 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 .NET Framework 3.5 SP1") If you want to create a query you can use this step by step guide - http://agerlund.spaces.live.com/blog/cns!3A51A2B50B5C1F51!357.entryKent Agerlund | http://agerlund.spaces.live.com/blog/

hi,I am getting error in SCCM 2007?possible to help?

What is the error?Standardize. Simplify. Automate.

anyway i was looking to find a quarry to return all station without the configuration manager client agents. and i thought if i replace' Microsoft .NET Framework 3.5 SP1' As shown in my friends query above i would succeed. but then then it brings the below error. if there is any one with the quarry to return all station without the configuration manager client agents. you can help. Msg 208, Level 16, State 1, Line 1 Invalid object name 'SMS_R_System'. JOhn Mukundo IT Sytem Admin Telecom

I dont think SCCM client makes its entry in Add/Remove as SMS Does not do that. I think there is easy way to do it . Goto collection All System (Containing all the machines) in the collection sort the machines with Client type machines not showing clients does not have client or they may have some other issue (WMI corrupt) or some other issues.