Here is a quick one I put together. Edit as necessary. select * from SMS_R_System inner join SMS_G_System_SERVER_FEATURE on SMS_G_System_SERVER_FEATURE.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SERVER_FEATURE.Name = "DHCP Server"
Daniel Ratliff From: [email protected] [mailto:[email protected]] On Behalf Of Lawrence, Tony Sent: Friday, February 19, 2016 4:29 PM To: [email protected] Subject: [mssms] SCCM Collection - Server Roles Hello and happy Friday to you all... well that depends what time zone you in as I write this.. I have been researching collection queries and have some information but not all is valid. Is there any websites or queries you fellow SCCM admins have on creating collections base on Servers and the roles they have installed? I am also looking at services as well. I might be over complicating things, but would like to create server role collections for a SCEP Exclusions base on what the server function is. So the SCEP exclusion is deployed to the Server role instead of all servers..... Any information or guidance on this would be much appreciated. Regards Tony This email and any attachments are confidential and may also contain copyright material of the Lend Lease Group. If you are not the intended recipient, please notify us immediately and delete all copies of this message. You must not copy, use, disclose, distribute or rely on the information contained in it. Copying or use of this communication or information in it is strictly prohibited and may be unlawful. Contracts cannot be concluded with the Lend Lease Group nor service effected by email. None of the staff of the Lend Lease Group are authorised to enter into contracts on behalf of any member of the Lend Lease Group in this manner. The fact that this communication is in electronic form does not constitute our consent to conduct transactions by electronic means or to use or accept electronic records or electronic signatures. Confidentiality and legal privilege attached to this communication are not waived or lost by reason of mistaken delivery to you. Lend Lease does not guarantee that this email or the attachment(s) are unaffected by computer virus, corruption or other defects and accepts no liability for any damage caused by this email or its attachments due to viruses, interception, corruption or unauthorised access. Lend Lease Group may monitor email traffic data and also the content of email for the purposes of security and staff training. Please note that our servers may not be located in your country. A list of Lend Lease Group entities can be found here<http://www.lendlease.com/OperatingEntities>. The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
