SCCM configMgr collection computers do not contain letters in it

The collection listed below might help you to identify if any computers in organization that do not follow the standard naming convention .

Below collection is created to list servers and do not contain specific words in computer name:

select SMS_R_System.Name, SMS_R_System.OperatingSystemNameandVersion from  SMS_R_System where (SMS_R_System.OperatingSystemNameandVersion like "%Server 6.%" or SMS_R_System.OperatingSystemNameandVersion like "%Server 5.%") and SMS_R_System.ResourceId not in (select ResourceID  from  SMS_R_System where SMS_R_System.Name like "%xxx%")

The Logic is : list all servers with criteria given above and computer do not have xxx word in it.

Please change the bold letters as per the requirement.

 

2 Responses to "SCCM configMgr collection computers do not contain letters in it"

Leave a Reply to Chris Cancel reply