Collections
if you can create queries then you can have dynamic collections
174 topics in this forum
-
Hi, Can someone please help me with a query to find a file in a particular location. thank you
-
-
- 2 replies
- 23.9k views
- 2 followers
-
-
Hello All I am very new to SCCM 2007 and I had few confusion which I came across while practicing in the lab enviornment. 1. While learning things in lab , we created a domain controller and we installed all the pre requisite applications on this system. Say, I already have a domain controller and I dont want to risk it by making it a MP and want to keep a server separately just for MP, what should be the approach in that case. 2. While working in test lab , I worked on the collection which are already created and hence looking for some sort of tutorial or information from where I can learn creating custom collections as per my need. 3. Looking for some d…
-
- 0 replies
- 3.6k views
-
-
Hey guys, Is there a way to use remote tools for a user object? Under the All users collection the Start -> Remote tools is not available. Does something need to be enabled in Remote Toosl Client Agent? I couldn't find any answers or resources on the web. Alternatively is there a way to add an Active Directory attribute under the user object that will display the Computer Name? Thanks! Jay
-
- 1 reply
- 3.5k views
- 2 followers
-
-
Currently we have been pushing out full copies of Windows 7 Professional to all of our workstations. However we are looking into pushing Windows Thin PC (based off of windows 7) for alot of our old warehouse machines. We currently have the machines being split up into sites. This collection is where we assign our software. This WQL query is: 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.SMSInstalledSites = "XX1" and SMS_R_System.Client is not null We are new to the SCCM game and are not familiar with …
-
- 2 replies
- 4.7k views
-
-
Hi, i have a simple query that imports computers from an on like XenDesktop55. Under that OU there is another OU "Controller" where one computer object is in. "Controller01". Now, i have in my collection all computers from XenDesktop55 and the Controller01 computer. How can i only get the computers from the first OU? My query is this: 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.SystemOUName = "INTERN.NET/XENDESKTOP55" Thanks
-
- 0 replies
- 3.1k views
- 1 follower
-
-
Hello! I want to have an uninstall collection where the query check if computers is NOT a member of a group but DOES have the application installed. The problem is i cant get it to work with the SMS_G_System_ADD_REMOVE_PROGRAMS_64 table only regular SMS_G_System_ADD_REMOVE_PROGRAMS. I have a computer that is now a member of the group but does have the program installed. This query works: 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_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.Reso…
-
- 1 reply
- 5k views
-
-
I am trying to create a collection, and the criteria for the membership is "system resource > system group name" however when I select the value button, only about 20 of my 100 groups on Active Directory appear, and the one group I wish to use isnt in the list Is there any reason why only a fifth of my groups appear? I have all of the active directory discovery methods enabled and scheduled to run daily so I know they're working. Do i have to do anything to the group on AD to make SCCM see it? Thanks Jim
-
- 2 replies
- 5k views
-
-
We are currently setting up a SCCM 2007 server (no MDT at this time). I have the Collection Variable "OSDComputerName" set so it prompts us for the computer name. Besides that, I have have a Batch file that I would like to run during the OSD Take Sequence but it requires some user input for a field "Username". It is possible for me to create a Variable called "OSDUserName" and have that information passed along to the batch file? Thanks in advance
-
- 2 replies
- 5.2k views
-
-
quick question, I am logged in as 'admin' to sccm console. I have an approved client 'a' in sccm. it shows in the all systems collection. Then i add it to collection 'b' by right-clicking and clicking on add to collection. is there any entry in any of the logs that 'admin' has added 'a' into collection 'b'? TIA, peggy
-
- 4 replies
- 13.5k views
- 1 follower
-
-
HI, Just wanted some advice, how would i go about trying to find the best way to find sccm clients that have not contacted the server in 10 days for example. or machines that have not received critical updates. how would i write the query for that? thank you
-
-
- 1 reply
- 12k views
- 1 follower
-
-
Is there any query to find the current user logged into the computer. I have set of workstations in a domain, i want to know which user is logged in to which machine. I have heard that there is SQL query which resolves this issue. Any idea how it can be done (through sccm or SQL). Please help me out. I am currently using sccm 2007 R3.
-
- 1 reply
- 4.9k views
-
-
I have deployed SCCM 2007 R3 in my company.. I have created collections for laptops and Workstations. We have symantec antivrus clients (12.1) installed on laptops and workstations. Can i write a query to find the computers where symantec AV clients are not installed. I wrote query to find symantec AV installed, its working fine. But how do i find computers where symantec AV is not installed. Please help me out...
-
- 1 reply
- 4.4k views
-
-
I am running SCCM 2007 Sp2 with R2 with AD system discovery. I am currently able to populate collections based on queries referencing system group or system name. I'd like to build a collection based on a query that references the description field in AD. I added "description" to the fields in AD System Discovery. After adding this yesterday I manually ran system discovery. I figured I'd give it a day to collect the information and check the adsysdis.log file. Today I found no errors in the log file regarding failure to collect the description data from AD. According to other articles I have found, I should now be able to find "description" both as a field …
-
- 1 reply
- 5.2k views
-
-
Hi! I have a collection grabing all the computers that are a member of group2, and that works great. I also have this group1 that are a member of group2 with a lot of computers in it but that does not work. Is it possible to also grab the computers in Group1 aswell? SQL Query: 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.SystemGroupName = "DOMAIN\\Group2" Thx for the help! EDIT: Added a picture to show you what i mean. http://imageshack.us/photo/my-images/16/sccmcollection.jpg/
-
- 0 replies
- 4.2k views
-
-
Hello, Can we use collection query for local users? or reports? And i also need a collection like unreacable clients (bacouse of firewall). Thankx....
-
- 0 replies
- 3.4k views
- 1 follower
-
