Microsoft Configuration Manager
An integrated solution for for managing large groups of personal computers and servers.
4,502 questions
Check out this similar question (and answer):
Create a dynamic collection of newly joined clients - is it Possible?
M Tran
491
Reputation points
I am looking for a way to create a dynamic collection that pulls only freshly joined clients (i.e: when a newly set up computer joins the domain and gets the SCCM client installed). Is this even possible?
I tried the query below but it pulled computers that came back online after being offline for a period. It did not pull new clients. This is not what I am looking for.
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 DateDiff(dd,SMS_R_System.CreationDate, GetDate()) <= 1
Why I need this collection? I have a group of standard apps that needs to be installed whenever we set up a brand new computer. These apps have already been installed on existing clients. I do not want to deploy the apps to the "all workstations" collection, to avoid any possible issues or complications, so I just want these standard apps to install on fresh computers only.
Any suggestions are greatly appreciated.
Thank you!
Accepted answer
3 additional answers
Sort by: Most helpful
-
M Tran 491 Reputation points
2022-04-19T15:09:35.173+00:00 Thank you @Simon Ren-MSFT and @Sherry Kissinger !
I will try this. I think the post is what I am looking for.
-
Simon Ren-MSFT 36,556 Reputation points Microsoft Vendor2022-04-22T07:49:13.987+00:00 Hi,
Hope everything goes well. May we know the current status of the question? If there is any other assistance we can provide, please feel free to let us know, we will do our best to help you.
Best regards,
Simon -
M Tran 491 Reputation points
2022-04-22T12:42:23.777+00:00 I did create a collection with the query from @Sherry Kissinger . So far it has not picked up any clients. I will have a new laptop up soon to see if the 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 join sms_statusmessage on SMS_R_System.Netbios_name0=sms_Statusmessage.machinename where sms_statusmessage.messageid='10800' and datediff(DD,sms_statusmessage.time,GetDate()) <2 and SMS_R_System.OperatingSystemNameandVersion like "%Workstation 10%"However, when I go back to the query and click on "show query design", I got this error, so I am not sure...
-
Sherry Kissinger 5,261 Reputation points2022-04-23T10:57:40.237+00:00 Yes, you can NOT EVER go to "show query design". some of the elements in that query are not available in the "gui" for collection query creation; but it functions for me... All I can think of is that you literally do not have any clients that fit the criteria of "Workstation 10" and have sent a status message of 10800 within the last 2 days.
an easy way to see "if it works at all" is to simply change it from < 2 (within 2 days) or instead something like < 30; presuming you have had some workstation 10 clients in the last month; just to see the query work at all. Then adjust to your preference. For us, 2 days was plenty to "target new clients as fast as we can with <insert super important thing>, regardless of any other considerations... like if the new device was for the CEO and heaven forbid he get rebooted in the middle of his work day--TOO BAD, that <super important thing> overrides any/every other consideration"
-
M Tran 491 Reputation points
2022-04-26T12:14:33.123+00:00 It is working now with < 2. The collection was sitting with the hour glass for several days. I just closed my sccm console and reopened. Thank you very much for your guidance.
Will these machine eventually "leave" the collection on their own after some time has elapsed? That is what I would want.
Thank you
Sign in to comment -
-
Simon Ren-MSFT 36,556 Reputation points Microsoft Vendor
2022-04-14T18:20:31.03+00:00 Hi @M Tran ,
Thanks for posting in Microsoft MECM Q&A forum.
==>Why I need this collection? I have a group of standard apps that needs to be installed whenever we set up a brand new computer. These apps have already been installed on existing clients. I do not want to deploy the apps to the "all workstations" collection, to avoid any possible issues or complications, so I just want these standard apps to install on fresh computers only.
For this purpose, we can add the computer to the specified collection during OSD, so it will get the policies (apps, updates etc.) after OSD completed. Some threads for your reference:
ADD A DEVICE TO A COLLECTION DURING A TASK SEQUENCE
Add device to collection as part of OSD Task Sequence
How to add a Known/Unknown Computer to a specified collection during OS Deployment
Adding a device to an SCCM collection during OSDHope it helps. Have a nice day!
Best regards,
Simon
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.-
M Tran 491 Reputation points
2022-04-18T12:45:40.593+00:00 Thank you for your answer. Yes I am aware of the OSD method and adding apps to task sequence. (I'm working on this for bare bone deployment). However, in my environment we don't wipe out stock OS when a brand new computer comes in. We set it up and join it to the domain, then let SCCM push out the client and apps on its own. For this reason, I would like to create the collection in question. Just not sure if it's even possible.
Thank you again for always answering my questions.
-
Simon Ren-MSFT 36,556 Reputation points Microsoft Vendor
2022-04-19T09:00:55.127+00:00 Hi,
You could refer to @Sherry Kissinger helpful link. Hope it helps. Have a nice day!
Best regards,
Simon
Sign in to comment -
-
Sherry Kissinger 5,261 Reputation points
2022-04-26T13:34:11.713+00:00 "Will these machine eventually "leave" the collection on their own after some time has elapsed? That is what I would want."
That is what "should happen", yes. But that's why you shouldn't just believe me, lol. "Trust, but Verify". I suggest you literally write down the machines that are in that collection as of "now" on a notepad or an Appointment to yourself in 3 days time... to go check that the ones that are in there now... are no longer there in 3 days (and potentially other ones have dropped in).
Don't just trust me. I could be evil. You don't know.
fyi, I tend to look at sql, not the console. select fcm.Name [ComputerName] from v_fullcollectionmembership fcm where fcm.collectionid = (Select collectionid from v_collection c where c.name = 'WhateverYouCalledThatCollection')
would be one possible way to list boxes in that collection, without looking in the console.
-
M Tran 491 Reputation points
2022-05-17T19:48:42.66+00:00 Just want to thank you for the query. The collection "newly joined clients" has been working as expected. New clients do fall off after 2 days. Just a quick question to make sure I get it right. I set the limiting collection to "all workstations" only. Server clients shouldn't make their way into this collection, right? I just want to make sure any servers will stay out of it.
Thank you!
Sign in to comment -