Link to home
Start Free TrialLog in
Avatar of rdefino
rdefinoFlag for United States of America

asked on

How to automate moving a system in SCCM to a particular Collection

Is it possible that when a system receives the sccm client and registers on the sccm server that it can be automated that the system is moved to a collection?

Problem is we are rolling out the client and when the system show up on the sccm console I can't tell when they show up or if they are newly registered or not. "All systems"  shows all the systems so I don't know what new and whats not.

Is there a way to set the column to display what collection the systems are in? I have set that the column would display id end point protection is enabled, but that doesn't seems to be working right. There are system with EP installed and enable but that column display doesn't show it.

any ideas?
Avatar of David Paris Vicente
David Paris Vicente
Flag of Spain image

It´s possible to create a collection and filtered by some attribute.

What I´m saying is when you create a Collection on is properties you can define a rule with a query statement for the Membership rules.
Example:

I want to insert in a Collection all the machines that have memory > 6050360

So in my created Collection let´s say "Memory" I create a membership rule like 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 inner join SMS_G_System_X86_PC_MEMORY on SMS_G_System_X86_PC_MEMORY.ResourceID = SMS_R_System.ResourceId where SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory > 6050360

In this Collection every client that don´t have the memory >=6050360 will not show up in this collection, but will show up On the Default Collections, like all systems, Desktops and server etc.

So you just have to find a difference between the new and the old clients and create a membership rule in a collection.

Let us know if this helped.

Regards

David
ASKER CERTIFIED SOLUTION
Avatar of merowinger
merowinger
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rdefino

ASKER

HI merowinger,

Where and how would I add this query?

Thanks
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rdefino

ASKER

Let me give it a shot. thanks