When listing out a collection one of the columns displayed is 'Approved', with values either Approved or N/A Does anyone know the query or what field to query to produce a collection of only Approved (or only N/A) entries? I've not yet been able to find a view or table with 'Approved' as a field. Thanks, Jeff Kantner Bechtel

My first question is why? If the client is a native client then Approved is set to N/A automatically? Are you trying to create a collection of "alive" machines? http://www.sccm-tools.com http://sms-hints-tricks.blogspot.com

We are in mixed mode. The immediate reason is that in my mix of Approved and N/A collection objects, the 'Approved' group appears to represent (for the most part) clients that have been migrated to SCCM. The 'N/A' group seems to be comprised of clients still with an SMS client. I want to build a collection of just the 'N/A' group to use as a client push target. Thanks.

In you client keydata table approvalstatus = 1 means client is approved if not its not approved. Select * from ClientKeyData where ApprovalStatus <> 0Surendar Reddy

select * from ClientKeyData where ApprovalStatus <> 0 That is SQL and cannot be used for building collections. http://social.technet.microsoft.com/Forums/en/configmgradminconsole/thread/60af8546-332e-4269-94ab-3734150f670a shows the idea to do it.