Author: Eswar Koneti

For those who have/do not have environment to explore system center configuration manager 2012 and its features before the product is launched and get ready for it ,Microsoft has few labs (hope will have more labs on all the features of it soon). This lab should be off help to see how it looks like and its roles and much more. TechNet Virtual Lab: Introduction to System Center Configuration Manager 2012 TechNet Virtual Lab: Migrating from Configuration Manager 2007 to Configuration Manager 2012 http://go.microsoft.com/?linkid=9796179- TechNet Virtual Lab: System Center 2012 Configuration Manager: Application Management http://go.microsoft.com/?linkid=9796558 - TechNet Virtual Lab: System…

Long back i posted report  http://eskonr.com/2009/12/sccm-report-for-computers-asset-information-including-sn-number-and-model-name/ to get computer information like computer name,Serial number,Processor,Physical memory,service Pack,computer model etc In this post ,i have modified the report little bit from previous post to add more fields that gives you lot more information about the computer . It is  very simple and straight forward report that just use Where class what columns do you get after running this report ? Name,Serialnumber, Manufacturer,Model,Processor,Memory (KBytes),Size (MBytes),MAC Adress,IP Adress,AD Site,Last user logged in,Operating System,Service Pack,Creationdate in SMS,Last Hardware Scan SELECT distinct sys.name0 as 'Computer Name', sys.AD_Site_Name0 as 'AD Site', CS.domain0 as 'Domain', sys.User_Name0 as 'Last Logged On…

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.

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 not have xxxx,create a collection query that has xxxx. I think this is pretty much easy how to do it using criteria. Create new collection and edit the query . Click on Criteria Tab , click Yellow Burst In the Criterion properties page, click on…

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)

In my previous post,we saw how to create SCCM report to list clients with its heartbeat time stamp . In this post ,we are going to see ,how to create Create a collection to list clients that are not sending or not reported to SCCM since X days based on its heartbeat (DDR) agent time. To get clients that are not sending heartbeat DDR ,we will use sub selected query which means ,we first create collection that list all clients have heartbeat DDR < 23 days and use this in subselected query to list clients that are not in first created query.…

System Center solutions help you manage your physical and virtual IT environments across datacenters, desktops, and devices. Using these integrated and automated management solutions, you can be a more productive service provider for your business. System Center captures and aggregates knowledge about systems, policies, processes, and best practices so that you can optimize your infrastructure to reduce costs, improve application availability, and enhance service delivery. For more info about avilable Pre-Release products and downloads ,please read http://technet.microsoft.com/sv-se/evalcenter/hh505660.aspx?ocid=otc-n-se-loc

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 configuration manager 2012 site server to install the console from ConfigMgrSiteServerInstallationPath>\tools\ConsoleSetup for more info read http://technet.microsoft.com/hi-in/library/gg712320(en-us).aspx#BKMK_InstallConsole As a best practice, initiate the Configuration Manager console installation from a site server rather than the System Center 2012 Configuration Manager installation media. The site server installation method copies the Configuration…