Long back have posted how to download prerequsisits which are required for configMgr 2012 RC1 http://eskonr.com/2011/10/configuration-manager-2012-prerequisites-download/ . Day ago there was ConfigMgr 2012 RC2 released with some modifications ,avilable here to download ConfigMgr 2012 RC2 http://eskonr.com/2012/01/configmgr-2012-rc2-released/ . In ConfigMgr 2012 RC1 we have 13 files are prereq where as in RC2 we have 25 files as prereq.…

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…