Collections
if you can create queries then you can have dynamic collections
174 topics in this forum
-
Hi, i want to build a dynamic collection to deploy our software on a fresh installed client. Ive created a TS to deploy Windows 7 (PXE boot) and joining our domain. Works fine until here. After joining the domain the pc should get all our standard software - like Office 2010, 7zip...... as fast as possible. Ive created a new collection with the following query: The Testsystem shows up. And Office 2010 Installation starts after a few minutes. But after the sucessfully Installation the Testsystems dont disappear from the collection. (ive startet a manual hardware inventory after the office installation - after that i can see the Microsoft Office Profession…
-
- 3 replies
- 15.1k views
-
-
Im looking for a Query for model type for example we have LENOVO M73Z, LENOVO M72Z, DELL ect. I would imaging a bios of Query of some sort would be the one i need?
-
- 2 replies
- 3.8k views
- 1 follower
-
-
I want to make a query that collects the machines of all employees here, and not the students machines. How to do this?
-
- 4 replies
- 4.3k views
- 1 follower
-
-
Greetings, I was wondering if someone could show me how to create a query based on a query in SCCM 2012. We have a program that has a certain number of computer based licenses. So, I need a collection of computers based on an AD group or User Based Collection (if that makes sense). I need the computer collection to be based on the users’ computers and only their “primary” systems (which still haven’t come in yet). Please let me know what you think. Thanks in advance!
-
- 0 replies
- 3.5k views
- 1 follower
-
-
I need to swap the AV client on a few thousand machines. I have a collection that shows all machines with a specific version of an .exe file that belongs to the old AV client that is no longer present post upgrade. I have other collections that divide that one by departmental OU so I can target different departments on different nights. The head of one of those groups wants his team broken down further, he'd like them done over two different nights. I tried creating a collection that targets machines ending in even or odd IP addresses but there's lots of overlap since some machines show several different values in SMS_R_System.IPAddresses. Using MAC address isn't much…
-
-
- 3 replies
- 7.2k views
- 1 follower
-
-
Trying to make a collection of "all systems that have checked in with AD in the last 90 days" and I am not having much luck. I think I need to query on the pwdLastSet AD attribute but I can not figure out how best to do it. Thank
-
-
- 6 replies
- 7.9k views
- 1 follower
-
-
A quick question for all of the GURUS on this forum. I am trying to create a collection that is based on having a specific driver version installed on a server. Can anyone point me in the right direction as to what the query language should look like? thank you ahead of time for the help.
-
- 6 replies
- 14.6k views
- 1 follower
-
-
Hi all, I've been reading articles an topics here that already helped me a lot, but i'm very new here as a members. I'll need your help to set my mind about Active directory group based collections in SCCM 2007. My configuration: Both "AD System Group discovery" and "AD Security Group discovery" are enabled with the polling schedule set to occur once a day. Active Directory group based collection are also set to update once a day. and dynamic update i activated. My problem: Sometimes it take a very long time to see a computer added to an AD group, appear in the appropriate collection. My questions: 1- Does it make any sense to activate dyn…
-
- 0 replies
- 4.1k views
-
-
Hello, i try to deploy a special task sequence to a specific user group, unfortunately its not possible to deploy a task sequence to a user collection, so my question: is it possiable to build a computer collation based on primary users from a specific user security group?
-
- 8 replies
- 20.1k views
- 1 follower
-
-
My first post in forums! Thanks to everyone who contributes here, what a great resource. I am getting up to speed with SCCM 2012 R2. I recently installed clients using Client Push on over 100 servers. I have a pair of collections I created for ease of deploying client hotfixes. The collections are based on a query for Processor.Address Width = 64 (64-bit AMD64 client machines) and another collection for Processor.Address Width = 32 (32-bit x86 client machines). OK so that was easy, and clients have *started* to populate the collection, but I have 100+ 64-bit clients and only 38 of them are in my 64-bit collection. Everyday, the number ticks upward by about a dozen…
-
- 1 reply
- 3.7k views
-
-
I am working on several SQL queries that will return a list of referenced collections names of a top level collection. I am able to query the top level collection name along with the refrenced collections but I can't seem to seperate the two. I'm wanting to import this into Report Builder and have sub-selects. For instance, I have 8 top level collections. One of the collection names is 'XXX WRK_NA' it has 24 referenced collections. I want to be able to click the '+' for the subselect and it would reveal the 24 referenced collections in a list. I have included two queries below: Top Level Collection Query: SELECT DISTINCT COUNT(v_R_System.Operating_System…
-
- 0 replies
- 3.3k views
-
-
Hi Am hoping someone can help me out with this query. The query below pulls all the PCs that do not have the SCCM Client installed. Our discovery is based on the AD. The problem is we have all sorts of OS in our environment. How can I pull only Windows XP, Vista and 7 and exclude OSX, Linux and Server OS. 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 (Client = 0 or Client is NULL) Thanks
-
- 4 replies
- 13.9k views
-
-
I'm pretty new to building queries and am currently trying to familiarize myself with SQL and the SQL Views to further help run queries. I've been having a hard time trying to build a collection of computers that have one of our inventoried software items on it. Within Inventoried Software, I have several products with different names all containing the word Coupon. Coupon toolbars, programs, etc. These are all security threats, and I have positive software counts for each. I'd like to create a collection (or run a report) of all machines with this software installed so I can remove the software. I've tried different variations of criteria in my query statemen…
-
- 1 reply
- 4.8k views
-
-
Hello, I'm trying to make a collection with computers that doesn't have flash plugin installed. I have done this in the past, but cannot figure why it isn't working this time. The result is showing a whole lot of PCs I know has it, including my own. We did however recently convert to SCCM 2012, but that shouldn't change anything... My settings are like this: any comments would be appreciated!
-
-
- 2 replies
- 3.8k views
- 1 follower
-
-
Have a few issues here - if this isn't the right place, please let me know... Right now my company applies some Group Policies to the AD Site (like wsus server, proxy settings, and timezone). This works great -- most of the time. The main trouble we have been running into is VPN users. No matter where they are, if they are VPN'ed in, they are attached to the Corporate HQ AD site, and get the timezone the corporate office is in. The main issue we have is people that travel from location to location - we need them to get the correct settings no matter where they are at. I read the pinned topic about creating collections based on IP address and it got me thinking. I…
-
- 0 replies
- 2.7k views
-
