No announcements
Found 1763441 threads
-
0 VotesSCCM Query not listing all computers in collection
Thank you Sherry, I would like to get the below information for all the computers. please let me know the query to pull from SQL.Answered | 11 Replies | 1507 Views | Created by IN-RMJ - Monday, April 8, 2019 9:17 AM | Last reply by Ray Jia - Tuesday, April 9, 2019 11:50 AM
-
0 Votes
SCCM- list of all collections in SCCM
http://sccm.blog.com/2013/04/08/to-find-out-the-collection-count-sql-query/NarahariAnswered | 3 Replies | 15555 Views | Created by Narendra Nadh - Monday, April 8, 2013 2:29 AM | Last reply by Narahari B - Monday, April 8, 2013 11:31 AM -
1 Votes
A list of all the collections computer "x" is in?
here you go : select a.CollectionId, b.Name from dbo.v_R_System r join dbo.v_FullCollectionMembership a on R.ResourceID = a.ResourceID ...Answered | 3 Replies | 2982 Views | Created by David Zemdegs - Thursday, November 10, 2011 1:49 AM | Last reply by David Zemdegs - Thursday, November 10, 2011 9:17 PM -
1 Votes
SCCM Query for number of members in all collections
try this : http://eskonr.com/2012/11/sccm-report-count-computers-from-collections/Please click on "vote as Helpful" if you feel this post helpful to you.Answered | 2 Replies | 13964 Views | Created by Pierre-Luc R - Thursday, November 22, 2012 7:20 PM | Last reply by Pierre-Luc R - Friday, November 23, 2012 2:32 PM -
0 Votes
Collection / Query Listing All Servers with Client Installed
Good Morning - Tonight our team is patching all Windows Servers on our network for the first time with SCCM 2012.Answered | 1 Replies | 3687 Views | Created by Ben Kellermann - Friday, September 7, 2012 3:39 PM | Last reply by Joyce Wang [MSFT] - Friday, September 7, 2012 8:55 PM -
0 Votes
Report to list all computers and their collection membership
Hi I am currently working on a site where direct membership is used for collections but a need has arisen to move to AD Queries.Answered | 2 Replies | 1157 Views | Created by Matthew Thorley - Wednesday, May 28, 2014 11:04 AM | Last reply by Sherry Kissinger - Thursday, May 29, 2014 1:19 AM -
0 Votes
SCCM - Query based collections
Try this :-- SELECT TOP (100) PERCENT dbo.v_Collection.Name, dbo.v_Collection.CollectionID, dbo.v_CollectionRuleQuery.RuleName, dbo.v_CollectionRuleQuery.QueryID, ...Answered | 1 Replies | 2919 Views | Created by Narendra Nadh - Wednesday, April 17, 2013 10:34 AM | Last reply by Narahari B - Wednesday, April 17, 2013 10:52 AM -
5 Votes
SCCM Collection not updating all computers from OU.
After adding % to query , it picked one more computer in collection.Answered | 16 Replies | 39386 Views | Created by veday001 - Sunday, May 29, 2011 1:47 PM | Last reply by sharepointisneedlesslycomplex - Monday, July 23, 2018 6:30 PM -
0 Votes
SCCM query collection not updating
The 'Office 2007 machines' collection is a query to check all the machines (that are in the 'All Windows XP Systems' collection) ...Answered | 7 Replies | 10148 Views | Created by Paul_G_2010 - Friday, March 11, 2011 10:31 AM | Last reply by Paul_G_2010 - Friday, March 11, 2011 2:29 PM -
0 Votes
SCCM Collection Query vs.
Why does the same query pulls out different number or items in collections and in query tab?Answered | 7 Replies | 5202 Views | Created by Ovidiu Spinean - Thursday, August 27, 2009 2:05 PM | Last reply by WorkMe2 - Saturday, September 5, 2009 5:33 PM -
3 Votes
SCCM collections that query Active Directory OU's not pulling all PCs across
We had missing Servers in several of my collections even though my query points to the correct paths.Answered | 3 Replies | 8404 Views | Created by Jon Day - Wednesday, May 9, 2012 2:02 PM | Last reply by skadek - Wednesday, April 30, 2014 10:38 PM -
0 Votes
Software Update Compliance Report Doesn't List Results For All Collection Computers
Below is the query I set up for the collection.Answered | 5 Replies | 2433 Views | Created by Ben Kellermann - Monday, August 27, 2012 3:41 PM | Last reply by Garth Jones - Saturday, July 6, 2013 3:59 PM -
0 Votes
SCCM 2012 Collection Query
If all you are going to do it deploy this application to any computer that has the application, then adding the last logon user will have no benefit.Answered | 6 Replies | 4026 Views | Created by Uttam blog - Thursday, April 4, 2013 8:32 PM | Last reply by Garth Jones - Friday, February 6, 2015 1:30 PM -
0 Votes
List All Collection ID's
There is also a builtin report called "All Collections"which will list all collections in the site and their collectionIDs.Answered | 3 Replies | 480 Views | Created by reduca - Wednesday, October 29, 2014 5:28 PM | Last reply by reduca - Wednesday, October 29, 2014 5:46 PM -
0 Votes
SCCM 2012 Collection Query Timings
Update all collection every 15 minutes is a huge hit to your CM12 server.Answered | 2 Replies | 545 Views | Created by RCCMG - Monday, June 23, 2014 6:49 PM | Last reply by RCCMG - Monday, June 23, 2014 7:35 PM -
3 Votes
SCCM 2012: move list of computes
#1: read all computer name from the csv #2: read all collection members of the source collection #3: loop through the ...Answered | 9 Replies | 1060 Views | Created by janhoedt - Tuesday, June 10, 2014 9:14 AM | Last reply by TorstenM - Thursday, June 12, 2014 3:54 PM -
0 Votes
SCCM Query for list of Collection with Direct membership
See if our report can help you : https://www.systemcenterdudes.com/sccm-2012-collections-report/ Benoit Lecours | Blog: System Center DudesAnswered | 3 Replies | 7189 Views | Created by San_02us - Wednesday, March 30, 2016 12:15 PM | Last reply by Benoit Lecours - Thursday, March 31, 2016 11:25 AM -
2 Votes
Querying SCCM for Collection rules by Powershell
Any other suggestion on how to get the full list in Collection Rules?Answered | 5 Replies | 25135 Views | Created by Robert L Barnett - Wednesday, January 21, 2009 10:03 PM | Last reply by Heyvoon - Friday, June 26, 2015 10:09 AM -
0 Votes
SCCM not removing computer from collections
So the only alternative would be to manually remove the computer from AD and the All Systems Collections within SCCM Console and run an update Collections ...Answered | 6 Replies | 5002 Views | Created by Mark Sandfox - Tuesday, January 27, 2009 2:21 PM | Last reply by Stefan Ringler [MSFT] - Tuesday, January 27, 2009 4:11 PM -
4 Votes
Havin a list of computers how to make a collection.
I use a free tool from SCCM expert.Answered | 4 Replies | 21461 Views | Created by muralla - Wednesday, February 2, 2011 3:19 PM | Last reply by Anil_SCCM - Tuesday, February 19, 2019 12:37 AM - Items 1 to 20 of 1763441 Next ›
No announcements
