[mssms] Creating Collections using SQL Central site replication? [yhsdd]
The flag on the child site for both of these collections is 2
Thanks,
Christopher Stauffer <><
Enterprise SMS Admin
MCTS ConfigMgr 2007
MCP SMS 2003
Email: CStauffer@myitforum.com
Blog: http://myitforum.com/cs2/blogs/cstauffer/
From: "Chris Stauffer" <cstauffer@myitforum.com>
Sent: Monday, June 22, 2009 9:29 AM
To: mssms@lists.myitforum.com
Subject: Re: [mssms] Creating Collections using SQL Central site replication?
369 PA100165 PA1 - Machines that failed to scan 18 6/5/2009 13:32 6/18/2009 13:29 6/21/2009 13:31 6/21/2009 13:31 6/21/2009 13:31 _RES_COLL_PA100165 1 6/21/2009 13:31 7DA569C000100008 0 6/19/2009 15:01 1033 <Binary data>
371 PA100167 PA1 - Test 2 18 6/19/2009 9:27 6/19/2009 9:27 6/22/2009 8:27 6/22/2009 8:27 6/22/2009 8:27 _RES_COLL_PA100167 1 6/22/2009 8:27 Testing query replication 6D3369C000100100 0 6/19/2009 9:31 1033 <Binary data>
Looks like the Value is 18.
I created a second collection using the same setup and have the save values and results. Central site is correct but child sites dont get the new query.
Thanks,
Christopher Stauffer <><
Enterprise SMS Admin
MCTS ConfigMgr 2007
MCP SMS 2003
Email: CStauffer@myitforum.com
Blog: http://myitforum.com/cs2/blogs/cstauffer/
From: "Chris Stauffer" <cstauffer@myitforum.com>
Sent: Saturday, June 20, 2009 10:17 AM
To: mssms@lists.myitforum.com
Subject: Re: [mssms] Creating Collections using SQL Central site replication?
Dont know i will look on monday :-)
Thanks,
Christopher Stauffer <><
Enterprise SMS Admin
MCTS ConfigMgr 2007
MCP SMS 2003
Email: CStauffer@myitforum.com
Blog: http://myitforum.com/cs2/blogs/cstauffer/
From: "Mark A Mears" <mark.mears@macys.com>
Sent: Friday, June 19, 2009 1:28 PM
To: mssms@lists.myitforum.com
Subject: Re: [mssms] Creating Collections using SQL Central site replication?
In the Collections table on the central site, what is the value of the
Flags column for that collection?
Thanks,
Mark
From:
"Chris Stauffer"
To:
Date:
06/19/2009 01:09 PM
Subject:
[mssms] Creating Collections using SQL Central site replication?
Sent by:
admin@lists.myITforum.com
I followed the directions to create the collection for machines that have
failed the WSUS scan as per these directions:
http://www.myitforum.com/articles/1/view.asp?id=5578
but the changes i made to the view query statement are not replicating to
child sites.
The query works on the central site but all the the child sites show all
of the clients for the site.
After reviewing the views code in SQL it is clear that the changes where
not replicated.
Any suggestions. This does not look like it is a solution that can be done
from the central site.
I would hate to have to replicate these changes manualy to 40 + sites.
Thanks,
Christopher Stauffer <><
Enterprise SMS Admin
MCTS ConfigMgr 2007
MCP SMS 2003
Email: CStauffer@myitforum.com
Blog: http://myitforum.com/cs2/blogs/cstauffer/
==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/smslist/
==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/smslist/
==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/smslist/
==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/smslist/
Published with BlogMailr
Trackbacks
No Trackbacks
Comments
No Comments