Bump. Thanks, ________________________________
Mark Mears [email protected]<mailto:[email protected]%0d> Phone: (757) 945-2651 [cid:[email protected]]<http://www.cireson.com/> [cid:[email protected]]<http://twitter.com/teamcireson> Check out our System Center App Store: www.cireson.com/app-store ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Mark Mears Sent: Tuesday, October 22, 2013 12:16 PM To: [email protected] Subject: [mssms] Collection Views not populating from CAS My customer has a CAS and three Primary sites below the CAS. We have defined several collections from the CAS and have run AD System Discovery from the Primary site (since it does not exist on the CAS) without seeing these collections being able to display the members of the collections using the "Show Members" functionality. The correct number of clients is displayed in the console but when "Show Members" is selected nothing is returned, looking like the collection is empty. Backing up to the parent item displays the correct member count. Further poking around in the SMSProv.LOG indicates that the SQL query being used to populate the collection is: SELECT * FROM SMS_CM_RES_COLL_C90100019 where (ClientType is NULL and EASDeviceID in NULL) OR ClientType != 3 When I do a normal select on the view above it returns zero rows. Since the console is based on these collection memberships to populate the console collections, returning zero rows effectively shows a "No items found" message for the collection. The creation of new collections has been tried and new collections show the same thing. How do the collection views get generated or refreshed? I understand that collection rules and memberships are sent to lower sub-sites using the SQL Broker service but don't know where it goes from there. This same condition exists in all 3 primaries. Looking at the same collection on the Primary site shows the expected results, the proper count and the "Show Members" functionality works. Has anyone seen this before and how can I get this corrected? Thanks, ________________________________ Mark Mears [email protected]<mailto:[email protected]%0d> Phone: (757) 945-2651 [cid:[email protected]]<http://www.cireson.com/> [cid:[email protected]]<http://twitter.com/teamcireson> Check out our System Center App Store: www.cireson.com/app-store ________________________________
<<inline: image001.png>>
<<inline: image002.jpg>>
