myITforum.com Community Forum myITforum.com Community Forum

Home  Forums  Blogs  Live Support chat  Search Articles  Wiki  FAQ  Email Lists  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Photo Gallery  Member List  Search  Calendars  FAQ  Ticket List  Log Out

All Forums RSS Feed Subscription:


  


Collection memberships not updating

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
  Printable Version
All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> Collection memberships not updating Page: [1]
Login
Message << Older Topic   Newer Topic >>
Collection memberships not updating - 11/21/2008 3:34:33 PM   
criticalerror

 

Posts: 110
Score: 0
Joined: 6/19/2007
Status: offline 		Any idea why the following collection membership would not be updating itself?

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 SystemGroupName = "TCPLUS\\WSUS_10_0500_SL3"

I removed a server from the AD group a week ago and it isnt updating. I also run a security group discovery and that collection does update. I was thinking that the membership was pulled from data in the sms database that is pulled from AD during the security group discovery. Is this wrong?
Post #: 1
RE: Collection memberships not updating - 11/21/2008 3:45:03 PM   
skissinger


Posts: 2293
Score: 145
Joined: 9/13/2001
From: Sherry Kissinger
Status: offline 		I think you want AD System Group discovery, not Security Group discovery.  see this.

You should also be able to right-click/properties on that server object, and see in there what System Groups are listed, and when a system group discovery last touched that record. (Agent Time [number that matches the Agent Name above])

_____________________________

mofmaster@smsexpert.com (version 2007) | http://www.smsexpert.com | http://www.sccmexpert.com
My Blog
Microsoft MVP - ConfigMgr

(in reply to criticalerror)
Post #: 2
RE: Collection memberships not updating - 11/21/2008 4:10:12 PM   
criticalerror

 

Posts: 110
Score: 0
Joined: 6/19/2007
Status: offline 		OK yes you are right it is system group discovery. I have this running every 4 hours.

The 6 agents running are:

Agent 0 SMS_WINNT_Server_Discovery_Agent
Agent 1 SMS_AD_SYSTEM_DISCOVERY_AGENT
Agent 2 SMS_AD_SYSTEM_DISCOVERY_AGENT
Agent 3 SMS_AD_SYSTEM_DISCOVERY_AGENT
Agent 4 SMS_AD_SYSTEM_GROUP_DISCOVERY_AGENT
Agent 5 Heartbeat Discovery

This server is the primary SMS server. The Primary site code is S10 ....

Agent 0 S10
Agent 1 S10
Agent 2 S15 (secondary site)
Agent 3 S16 (secondary site)
Agent 4 S10
Agent 5 S10

AgentTime 0 11/21/08 12:12pm
AgentTime 1 11/21/08 2pm
AgentTime 2 11/21/08 1pm
AgentTime 3 11/21/08 12am
AgentTime 4 11/20/08 12pm
AgentTime 5 11/21/08 2pm

This server was already removed from the Ad group before noon yesterday. I've manually updated the collection membership and refreshed and the server is still in the collection. Odd that the agent is set to run every 4 hours but shows noon yesterday as the last run time.

(in reply to skissinger)
Post #: 3
RE: Collection memberships not updating - 11/22/2008 12:05:13 AM   
SMSExpert

 

Posts: 193
Score: 39
Joined: 10/28/2008
Status: offline
There my be two reasons:
1. The Discovery data records (DDR) for the server  hasn't been processed.
2. The server you are querying for not assigned to the local site (AD System Group Discovery only runs for systems assigned to the local primary site).
 
Workaround:
Are you getting any records of that server in adsysdis.log? if not, just delete that server from the SMS console and update the collection membership. Sometimes, machines are displayed beacuse of default rule of obsolete clients in SMS database. There is certain period of time for the object's record in sms database. Once it comes to obsolete, it automatically removes from the console.
 
Thanks.  
 

(in reply to criticalerror)
Post #: 4
RE: Collection memberships not updating - 11/23/2008 11:31:32 AM   
criticalerror

 

Posts: 110
Score: 0
Joined: 6/19/2007
Status: offline 		1. Ok so what would keep the DDRs from processing? There are no compnent errors.
2. The server IS the SMS Central Site server and is assigned to the correct site. It shows up fine in all collections (all systems, all servers systems, ect.)

I checked the adsysdis.log and all entries for the server are there and correct. I cant delete the server from the console because it is the SMS server and I dont want it removed from the database, just this dynamic collection. In the properties of the server the Obsolete tag is 0 which is correct. The server is reporting fine and is not obsolete.

Basically it works like this. We have all servers broken up in different AD groups depending on their patch day and time. This way the owners of the server can control when they get patched by simply changing their ad group membership. These ad groups are security groups. I then created dynamic collections based of the membership of those groups (see collection query above). The Discovery agent runs every 4 hours and the collection is set to auto update once a day. Well, when I change AD group memberships, those changes arent being reflected in the collections.

I also checked adsysgrp.log and the server and AD group are discovered without issue. The server properties in SMS also show it as being in the correct group. The last discovery was run this morning but the date in time in the server properties is not updated and the server is still a member of the collection even though it is no longer a member of that group.

adsgdis.log:

DDR was written for security group 'TCPLUS\WSUS_10_0500_SL3' - E:\SMS\inboxes\auth\ddm.box\asg1ln25.DDR at 11/23/2008 9:53:6.

which is the group that this server WAS a member of.

makes you say Hmmmmmmmmmmm .....

(in reply to SMSExpert)
Post #: 5
RE: Collection memberships not updating - 11/24/2008 12:37:13 AM  1 votes
SMSExpert

 

Posts: 193
Score: 39
Joined: 10/28/2008
Status: offline 		If you are getting server entry in adsysdis.log, there is no need to delete the record from SMS console/database.
 
If it's a sms server and you want to remove it from console only, not from database, select the option "delete special".

(in reply to criticalerror)
Post #: 6
RE: Collection memberships not updating - 11/24/2008 2:41:28 AM   
criticalerror

 

Posts: 110
Score: 0
Joined: 6/19/2007
Status: offline 		The specific machine isnt really important. That was just 1 example i'm using to show the bigger problem. I dont want to manually remove records from these collections. They should be dynamic collections and should update themselves automatically when changes to the AD groups occur.

(in reply to SMSExpert)
Post #: 7
RE: Collection memberships not updating - 11/24/2008 4:42:19 AM   
SMSExpert

 

Posts: 193
Score: 39
Joined: 10/28/2008
Status: offline 		I agree with you and working for the same. I will update you ASAP.

Thanks.

(in reply to criticalerror)
Post #: 8
RE: Collection memberships not updating - 11/24/2008 5:30:27 AM  1 votes
SMSExpert

 

Posts: 193
Score: 39
Joined: 10/28/2008
Status: offline 		Hi,
Queries will only work if the data has been captured within the SMS Database, queries don't force the update of scheduling at all, it merely asks the SMS Database what information it has on  a particular query.
 
Hope this makes sense.
 
Thanks.


(in reply to SMSExpert)
Post #: 9
RE: Collection memberships not updating - 11/24/2008 9:35:31 AM   
jnelson993


Posts: 959
Score: 132
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline 		Are other collections being evaluated properly?  I'm wondering if there's a clog in the colleval.box?




_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to SMSExpert)
Post #: 10
Page:   [1]
All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> Collection memberships not updating Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts



  
Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.328