Centaur63

I posted this inside SUP forums

http://cid-339f51e91...M%20Updates.GIF The above link is what i am seeing in Software Updates > Critical Updates > All Updates What i am trying to do is start over with deploying WSUS & SUP. First thing i did was remove SUP then i uninstall WSUS. But yet i can still see those old updates in there. They are not actully there bacuse when i click it and select download or anything i get "All Software updates in this selection are expired or metadata-only. The deployment cannot be created." I read somewhere that this stuff is located in the SQL Database. How do i remove this old meta data out of sccm? Any help would be greatly appreciated

http://cid-339f51e91e743385.photos.live.com/self.aspx/Support/SCCM%20Updates.GIF The above link is what i am seeing in Software Updates > Critical Updates > All Updates What i am trying to do is start over with deploying WSUS & SUP. First thing i did was remove SUP then i uninstall WSUS. But yet i can still see those old updates in there. They are not actully there bacuse when i click it and select download or anything i get "All Software updates in this selection are expired or metadata-only. The deployment cannot be created." I read somewhere that this stuff is located in the SQL Database. How do i remove this old meta data out of sccm? Any help would be greatly appreciated.

Is it possible to put them into a group and have it populate the list that way so i can clean up sccm? Right now nothing is being populated?

Thanks alot, This is my query statement: select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.UserAccountControl = "4098" I will give it 30-40 mins and see if it populates the computers.

Thanks, UAC on the computer resource should have 4098 in it correct. The machines have 4096 along with some of the active machines on the network. It dosnt seem to be picking up these computers.

How do i Setup a collection to find all the Disabled computers? I am cleaning up my ADUC and there are alot of computers that I disbaled that have not been on the network for sometimes. I am unble to delete them from ADUC just yet. Because i need to be sure they are no in use anymore. Is here a way for me to setup a collection in SCCM that querys all the disabled computers?

That seemed to work. Thanks alot for your help

I think i may have found the problem. The MP is set to the wrong Server. It is set to the one that has died. How can i fix that?

http://cid-339f51e91e743385.photos.live.com/self.aspx/Support/sccm.GIF sorry that is the link of what i am seeing

I am having trouble trying to figure out how to approve my clients. As it stands right now they have N/A for approved. When I right click the client i do not see the approve option. I am in the All System Collection if that helps at all. I attached a screen sho tof what i am looking at. Any help with this would be great. Thanks again for any help or suggestions you can give me.