tag:blogger.com,1999:blog-8229131257128040189.post6096372097103101848..comments2023-04-11T11:36:03.057+01:00Comments on Think Big - with Powershell: List members of SCCM collection - SCCMTompahttp://www.blogger.com/profile/00462564333522996562noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-8229131257128040189.post-44292531097055646692017-11-10T22:25:40.885+00:002017-11-10T22:25:40.885+00:00Heya i am for the first time here. I found this bo...Heya i am for the first time here. I found this board and I in finding <br />It truly helpful & it helped me out much.<br />I am hoping to give one thing again and aid others such as you helped me.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8229131257128040189.post-4081497725620499092015-08-11T20:41:07.078+01:002015-08-11T20:41:07.078+01:00WMI will have the same delegation model as the con...WMI will have the same delegation model as the console. However, you can grant read access on the SQL instance and the DB for a user running this, you can strip out the WMI queries for the site and the server name enumeration and that would mean you only do SQL queries.Tompahttps://www.blogger.com/profile/00462564333522996562noreply@blogger.comtag:blogger.com,1999:blog-8229131257128040189.post-67527630651557792602015-08-10T17:53:46.355+01:002015-08-10T17:53:46.355+01:00Is there a WMI way to do this? To make a tool for ...Is there a WMI way to do this? To make a tool for people who don't have access to the SCCM 2012 Console?<br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8229131257128040189.post-89728381717925690372014-03-20T21:15:14.454+00:002014-03-20T21:15:14.454+00:00Indeed, in SCCM 2012 things are getting easier wit...Indeed, in SCCM 2012 things are getting easier with the built-in cmdlets. This article was originally written for SCCM 2007.:<br />http://technet.microsoft.com/en-us/library/jj821831(v=sc.20).aspx<br />Tompahttps://www.blogger.com/profile/00462564333522996562noreply@blogger.comtag:blogger.com,1999:blog-8229131257128040189.post-32296150998763841492014-03-13T18:16:26.681+00:002014-03-13T18:16:26.681+00:00There is a significantly easier way to do this.
G...There is a significantly easier way to do this.<br /> Get-CMDevice -CollectionName "My Collection" | Select Name<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8229131257128040189.post-86278692802983175122013-08-05T16:40:16.457+01:002013-08-05T16:40:16.457+01:00Here's what I came up with. It does require y...Here's what I came up with. It does require you to use the ConfigMgr 2012 SP1 module which you need to run in (x86) mode:<br /><br />function Get-CollectionMembers{<br />[CmdletBinding()]<br />param(<br /> [Parameter(Mandatory=$True)]<br /> [String]$CollectionName<br />)<br /><br />$CollectionID = Get-CMDeviceCollection -Name $CollectionName | Select CollectionID<br />$ComputerList = Get-CMDevice -CollectionId $CollectionID.CollectionID | Select -Property Name <br /><br />ForEach ($ComputerObject In $ComputerList){<br /><br />Get-ADComputer -Identity $ComputerObject.Name -Properties CanonicalName | Select Name,CanonicalName<br /><br />}<br />}<br />Anonymousnoreply@blogger.com