Author: Eswar Koneti

SCCM 2012 is now configured up to 20 Site roles which you can install/Configure on single machine or distribute to different machines for load balancing . Site server Site Database Server Site system Application Catalog Web Service Point Application Catalog Website Point Asset Intelligence Synchronization Point Component server Distribution Point Endpoint protection Point Enrollment Point Enrollment Proxy Point Fallback status Point Management Point Mobile Device Management Point Out of band service Point Reporting services Point software update point State Migration Point System health Validator Point

You have Username but unsure what is their computer name where they logged into to track it(this all happens if and only if sccm client is healthy else you see old information). This report gives you all the machines name with your supplied user names if you have bulk users to know all . Create report with below SQL code and Run Other SCCM reports based on last logged on user names http://eskonr.com/2011/03/sccm-report-for-computers-with-last-logged-on-user-from-collection/ http://eskonr.com/2011/03/sccm-report-to-list-all-computers-based-on-last-logged-on-user-name-from-collection/ SELECT  GS.Name0, GS.UserName0, WS.LastHWScan, GS.Domain0, OS.Caption0, SYS.SystemRole0 FROM v_GS_COMPUTER_SYSTEM GS, v_GS_OPERATING_SYSTEM OS, v_GS_SYSTEM SYS, v_GS_WORKSTATION_STATUS WS WHERE GS.ResourceID = SYS.ResourceID AND WS.ResourceID = GS.ResourceID AND OS.ResourceID…

Hi Everyone, This is our first post in a long while, we've had our heads down ramping up on System Center 2012 and helping the first wave of early adopters. As part of some of the work we've done, we found one common scenario where customers are looking to migrate their server patching from WSUS to System Center 2012 Configuration Manager.  For desktop migrations, customer are usually happy to take all updates or the majority of updates and just start fresh.  For servers, they want to be sure that they only thing they pull across is whatever was approved by…

create reports for the requirement and i first start analyzing the necessity and find the information about the required information where they stored in SCCM Database (SQL views). Most of the reports (SQL) that i have created in this blog created with basic syntax’s like joins. Only certain reports go beyond the joins but still not that difficult until you know the logic to achieve the results. In this post, i wanted to bring up, how the SQL syntax join's will help you to achieve the desired results. You basically need to understand how these joins works. Joins? In…

It was yet another big day for Microsoft and the Windows 8 team as the RTM build was officially made available to download for MSDN and TechNet subscribers. So How to activate windows 8 enterprise Via command prompt with product key. Step 1: Right click on cmd and select run as administrator step 2: type SLUI.EXE 3 and press Enter Step 3: Type your MAK key in and click "Activate"

This blog post will help you to identify packages (count) for which there is no advertisement created and not used these packages in any task sequence.Once you have the packages ,you can further take action whether you really need these packages to exist in SCCM or cleanup to save disk space and avoid unused packages in sccm. SQL Query to run from SQL server management studio or use this to create report. select     PackageType = Case Packagetype When 0 Then 'Software Distribution Package' When 3 Then 'Driver Package' When 4 Then 'Task Sequence Package' When 5 Then 'software Update Package'…

Recently encountered backup issue on one of the primary site server and backup never ends stuck at “info:starting asynchronous do snapshotset… ” though sms_site_backup service running and never(did not monitored for too longtime) ends until you stop it manually. Below is the snapshot captured when error occurred. Why does it hangs over there ? what are the causes ? Tried Restarting the sms_site_backup service but doesn’t fix the issue and log hangs with above message. So decided to restart the sccm server (caution in production server) and check if the sccm services are running or not like sms agent host…

Our engineering team has had an amazing journey this past year with two key releases to help our customers improve their capabilities for deploying Windows in their enterprises.   As you know, we released Microsoft Deployment Toolkit 2012 in April of this year to coincide with the Microsoft Management Summit (MMS) and this enabled a lot of functionality asked for by you.  These are outlined in this post I made back around this release and include an all-new extensible wizard, all-new rebuilt designer, and support for all the enterprise deployment scenarios. On the heels of the 2012 release, our team was…