Collections
if you can create queries then you can have dynamic collections
174 topics in this forum
-
I created a collection to dynamically add resources. here is the query language: select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SoftwareProduct on SMS_G_System_SoftwareProduct.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SoftwareProduct.ProductName = "Internet Explorer 8" Some resources get added but not what I'm expecting. I am using this group membership to apply internet explorer updates. Is there a way I can force systems to check against the query and add to the group? Thanks, Justin
-
- 20 replies
- 8.7k views
- 1 follower
-
-
Hi All, First apologies if this has come up before. I am currently deploying some updates but before i applied the updates i wanted to find what clients had the particuliar software version installed. The queries worked fine and i have successfully deployed the updates. Now the clients have the latest version of the software the queries should no longer produce the clients as results. But for some reason the queries seem to of not updated. Is there any way to force the query to update the results so it no longer shows these clients?
-
- 6 replies
- 5.2k views
- 2 followers
-
-
How do I create a collection that lists all the computers with a program installed? I'm not concerned about the version of the program though. I have one that I was trying but it doesn't seem like it is working. Does the "like" statement not work?
-
- 1 reply
- 3.3k views
- 2 followers
-
-
Hello, I am really hoping someone has either a good script they have found our a good way to clean up and remove old collections quickly. The problem I have is this new company I am at use to make a 'temp' collection each time they had to push out a single install to one machine, however they never cleaned those up and deleting them individually would take a very long time. So my question would be: Does anyone know how to delete multiple collections at once? Thank you all,
-
- 1 reply
- 7.9k views
- 1 follower
-
-
Trying to create a collection that will automatically query and update based on users in an OU. Would like to set it up so we can add more queries that will populate users from other OUs as well. Will help with software distribution after training. as well as when users are moved base on new job position. Thank you for any help!
-
-
- 9 replies
- 33.3k views
- 2 followers
-
-
Hey all, I'm looking to use Powershell to list all collections a particular Computer is a member of. I have a way of listing all the members of a particular collection, but I don't have the reverse, which would be listing all the collections a member is in. I'll post what I've got. PS C:\> (get-command Get-CollectionMember).ScriptBlock Param($CollName) $SiteCode="ATL" $SCCMServer="SCCM" # Get a list of collections and find the object to build the collection list. $Collection = Get-WmiObject -ComputerName $SCCMServer -Namespace ` "root\sms\site_$SiteCode" -Class 'SMS_Collection' $MyCollection = $Collection | Where-Object { $_.Name -eq $CollName …
-
- 5 replies
- 32.1k views
- 1 follower
-
-
in my environment computers have been removed from AD but not from sccm. i need help creating a collection to find all computers which have not responded for 90 days and more. Basically dead computers in the Domain
-
- 1 reply
- 3.3k views
- 1 follower
-
-
Hey guys, After setting up a new domain and deploying SCCM 2012 I came to realize how much work it actually is to set up new applications. I have made a script which creates AD groups and Collections. I still create the Applications manually because they usually differ when it comes to how they need to be set up. Some products can be imported as Applications (MSI etc) while some (Autodesk products in particular) need to be set up as Packages. Here's a link to the script. http://heineborn.com/tech/powershell-create-collections-and-ad-groups/ Enjoy!
-
- 0 replies
- 7.5k views
-
-
So, I've ran into a bit of a conundrum. I have a large amount of domin-joined devices populated and organized in AD. I want to break them up for specific software deployments by further separating them using Device Collections in SCCM 2012. I use System Resource > System OU Name to break them down into generalized collections, but often times need to break them down further by either excluding nested OU's or only including devices with specific naming strings. My conundrum is this: When creating a query that only lists machines with a specific name string I get no results listed in the collection (see example 1). Additionally, I can't seem to write a query that exc…
-
- 6 replies
- 33.9k views
- 3 followers
-
-
Hi all, ARGH! SCCM 'could' be so good if it wasn't for the little niggles. There is a machine on our network which won't PXE boot. We had the TS assigned to two collections. 'Unknown computers' and 'Windows XP Deployment'. So long as I can get the machine to PXE boot I'm not bothered. The machine was in the all systems collection so I have deleted it. Then I tried booting the machine up thinking it would be detected as an unknown computer.....nope Then I tried putting the machine name and MAC into a txt file and loading this into the Windows XP Deployment collection.....nope. The reason is that although I have deleted it from the all systems colle…
-
-
- 6 replies
- 10.1k views
-
-
Hi! Help create a query to select the subnet. I use the following: select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.IPSubnets = "192.168.100.0" but this only works with /24 subnet. I have many subnets /25 /26, and I can not automate this collection.
-
- 0 replies
- 3.1k views
-
-
Well i would like to know how to make the collection of those clients are only assigned and approve but no client install on it. thanks
-
- 4 replies
- 17k views
-
-
Long time reader/first time poster! We employ some s/ware harvesting using s/ware metering at our site and noticed issues around client repairs. We can exclude PC's which are fresh builds easily but I need a way to build a collection that includes PC's which have had their client reinstalled in the last 90 days. I've been racking my brain for the last few hours trying to come up with a solution, anyone had any success attempting something similar?
-
- 2 replies
- 9.3k views
-
-
Hi I would like to know how to keep the inventory of the client information in a specific collection. Today if one of the client is offline or not in the netowrk it drops from that collection. The collection query is designed to obtain which devices have a particular application installed. Is there a palce I have to configure to keep the records for number of day? Thanks in advance...
-
- 0 replies
- 3.1k views
- 1 follower
-
-
Struggling with this one. I can't seem to figure this out. I am trying to filter by OS in this query. What I have is working but I can't seem to get it to filter by OS type. I want only Windows 7 and Windows XP machines to show up in this collection. If anyone can help I would greatly appreciate it. select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_NETWORK_ADAPTER_CONFIGURATION on SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceId = SMS_R_System.ResourceId where SMS_R_System.Name not in (select SMS_R_SYSTE…
-
- 0 replies
- 3.1k views
-
