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…
SCCM collection Subselected Queries

Have seen lot of questions on how to get list of computers that do not have xxxxxx .This xxxx could be of anything like softwares,file names anything that do not have. In this post,I will go through step by step procedure how to make it simple. Step 1: To get list of computers that do…

Use Subselected query to get the results: select *  from  SMS_R_System where SMS_R_System.NetbiosName like "%rts%" and SMS_R_System.ResourceId not in (select SMS_R_System.ResourceID  from  SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName like "rtvscan.exe" AND SMS_R_System.Client = 1)  

Long back ,I have written a post on www.windows-noob.com how to install SCCM 2007 admin console Via Software Distribution using unattended setup file(.ini). In this post,we will go through how to perform unattended installation of SCCM 2012 RC.We follow the same procedure here as we did in SCCM2007 with minor modifications OR You can use…

In this post,we will see how to get heartbeat discovery (DDR) time for the clients from specific collection using Reports.For troubleshooting client health issues ,we need to know when was the client last reported its DDR . If you need to create collection to list the clients that are not sending heartbeat DDR for past…

Recently have a requirement to uninstall all old adobe versions and install the new on.Looking for something which can be done Via but i found the below method is simple that can remove all the older applications and instal the new one(which can be done Via TS by adding two TS actions one with removal…

If you want to trace the users on what computers are they logged in(please be noted that  this is based on the hardware inventory information and if multiple users logged into same computer will not report to site server until inventory information sent). Take a look at this post for more information about explaining last logged…