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.