Author: Eswar Koneti

Have tried installing SCCM 2012 RC1 on my LAB but it doesnt have internet connection. The setup files are avilable with me which has internet connection(office network) but it is 32 Bit operating System.SETUPDL.exe will not run on 32 bit Operating System. If you  have internet connection ,you can run SETUPDL.EXE from your command prompt(run with Administrator) with command line Drive letter:\ConfigMgr_2012_RC1_ENU_7678\SMSSETUP\BIN\X64\setupdl.exe C:\downloads change the bold letters as per the need. So i have tried downloading all the Prerequisists with the download links given below from 32Bit OS and taken with USB Stick onto My LAB system: Manifest from http://go.microsoft.com/fwlink/?linkid=226250  as…

Read More

As we all know trace32.exe is utility that comes up with sms/sccm tool kit used to read the log files in better way.Tool name has been changed in configuration manager with CMtrace.exe . CMTrace.exe is a good choice for detailed, real-time monitoring of one or more components. You can specify that certain strings or actions be highlighted as they appear on the screen, and you can also filter log-file entries by component, time, thread ID, or entry text. This tool also maintains the entire log file in a window, so historical log-file data is visible at any time. Where is…

Read More

Here’s the “official” announcement on the Microsoft Server and Cloud Platform Blog, along with the list of features added to the RC . You can download SCCM 2012 RC from http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=27841 ,Registration Required before download. Please note: System Center 2012 Configuration Manager and System Center 2012 Endpoint Protection are now provided as a single installation package. In the Release Candidate, we’ve introduced some additional and enhanced capabilities, including: 1.Improved endpoint protection functionality, with integrated setup, management and reporting for System Center 2012 Endpoint Protection. 2.Improved application catalog design that provides a better, more responsive experience when requesting and downloading applications. 3.New…

Read More

This is continuation to the post avilable here on http://eskonr.com/2010/03/monthly-patch-statistics-reports-to-show-up-to-the-management-in-a-simplified-manner/ Report posted on the above link doesnt give you the required information what it gives in SMS 2003 since some of the columns in have been changed i.e product has blank value from v_GS_patchstausEX view etc in sccm 2007. Below is the modified report that works in SCCM environment. 1) Patch Management summary: select summ.ID,summ.QNumbers as 'Q Number', COUNT(distinct ps.ResourceID) as 'Requested', COUNT(distinct case when ps.LastState=107 or ps.laststate=102 or ps.laststate=105 then ps.ResourceID else NULL End)  as 'Installed', ROUND(100.0*COUNT(distinct case when ps.LastState=107 or ps.laststate=102 or ps.laststate=105 then ps.ResourceID else NULL End)…

Read More

Have you been asked by your boss saying can you send me the report for the applications that are deployed last month with Success rates /failures? You will be wonder after looking at the success rate 🙂 and start troubleshooting why is this . We will be deploying number of applications per day using SCCM and difficult to track the status of each application and export to document . This report will give you all the advertisements that are deployed with in specific date/time. Create a new report with the below SQL query with 2 prompts (start time and end time) select adv.AdvertisementName as…

Read More

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 of old adobe versions and other for installation of New adobe). Thought of sharing with you here how to remove different versions of applications at one go. Thanks to john Marcum for providing me the command line. Here is the simple script that checks if the application is…

Read More

I was thinking to share something interesting with you all and it is very useful at times when you are dealing with installation or Uninstallation of applications ,but due to other priority works,i could not post it early. We recently started application deployment (running on SCCM 2007) for new client and lot of applications are msi without sms /PDF (automation file) file and we follow the process of collection creation based on product ID. we have package available with us without product ID but to know the product ID of the application either we have to edit the package using…

Read More

Create New SCCM collection and paste the below query into it. select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from  SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.Caption like "Microsoft Windows 7%" and SMS_G_System_COMPUTER_SYSTEM.SystemType = "x64-based PC" Also need report :look at here http://myitforum.com/cs2/blogs/skissinger/archive/2009/06/23/32bit-vs-64bit-report.aspx

Read More