Microsoft Virtual Academy is completely free training areas where Microsoft really provides extra value to IT professionals and it is Cloud based Technology. Microsoft recently added 4 new Windows 8 Courses available on what's new,how to plan and deploy etc. Below are added newly 4 courses on MVA: Exploring Windows 8: Covers key topics for IT Pro’s such as Bit-Locker, client Hyper-V, and Managing Client Access for the Windows Store. Planning and Preparing for Windows 8: Learn how to inventory apps and hardware, assess compatibility, and conduct a successful pilot deployment of Windows 8. Deploying Windows 8: Use proven…
Author: Eswar Koneti
SCCM Inbox Folders plays Vital Role in troubleshooting problems with different components. You should keep an Eye on the inbox folders for a backlog of files that wait to be processed. There are various methods to monitor the inbox folders (tools/Scripts etc). This Post is going to be focus on Despooler.Box\Receive and clean up files residing older than 30 days. Despooler.box\Receive stores the data that is received from a child site or a parent site and process it accordingly.Typically, files are processed and moved as soon as Configuration Manager 2007 receives the instruction file (.ins file). In Short about what…
We have been using different Methods / Scripts to install SMS/SCCM Client from Previous version of Configuration Manager. In SCCM 2012,We do have the same methods what is available in SCCM 2007 , But with the release of Configuration Manager 2012, New tool has been introduced which is ClientpushGenerator.exe. More info will follow. http://technet.microsoft.com/en-us/library/gg682191.aspx This tool can be found from SCCM Installation Drive folder:\AdminConsole\bin\ClientpushGenerator.exe. This procedure requires you to enable Client push installation the site where the clients assigned to. How to enable Client push installation : From the administration Pane--Site Hierarchy—>Sites-->Right click on site ,you see client installation Settings—>Client Push…
Update: SSRS Report for Configuration manager 2012 (all Versions) is available on http://eskonr.com/2014/02/configmgr-ssrs-report-patch-compliance-statistics-last-30-days/ In my previous blogs,I posted couple of reports for Patch compliance status based on the KB/MS ID numbers . SCCM Patch Compliance Progress report: http://eskonr.com/2009/10/patch-status-compliancesoftware-updates-report-in-sms-sccm/ Software Update Compliance Status on Specific Collection : http://eskonr.com/2009/09/report-for-software-update-report-for-software-update-compliance/ SCCM monthly Patch statistics report http://eskonr.com/2011/10/sccm-monthly-patch-statistics-reports-to-the-management-in-a-simplified-manner/ This report is going to be interesting .It has 2 SQL queries in one Report .One with count of Active patches for past 1 month and percentage successful and Other is what are the patches Active on specific collection of machines with Installed,Missing ,required and Percentage of successful. Report looks…
When you deploy software updates using SCCM/configmgr to clients ,patch status will be sent back to SCCM site.It is always good to know the Last state ID's and its state names for custom reporting. Below are the available Last state ID's and State Names. These state IDs do exist in SQL View called v_GS_PatchStatusEx . LastState LastStateName 0 No Status 101 Failed 102 Reboot pending 105 Install Verified 107 Preliminary Success couple of Patch Compliance reports based on laststate/Laststatename are SCCM Patch Compliance Progress report: http://eskonr.com/2009/10/patch-status-compliancesoftware-updates-report-in-sms-sccm/ Software Update Compliance Status on Specific Collection : http://eskonr.com/2009/09/report-for-software-update-report-for-software-update-compliance/ SCCM monthly Patch statistics report http://eskonr.com/2011/10/sccm-monthly-patch-statistics-reports-to-the-management-in-a-simplified-manner/
Collection to check if any of Primary or Secondary site not installed with SUP Role or any other Role? 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 where SMS_R_System.SystemRoles like "SMS Site System" and SMS_R_System.ResourceId not in (select ResourceID from SMS_R_System where SMS_R_System.SystemRoles like "SMS Software Update Point") Collection can be modified to check if any of the Roles is missing on sites.
Getting Active Directory computer information into SCCM Database can be done by configuring Active Directory discovery Methods in SCCM Configmgr but there are cases, wherein some of the computers may not be discovered or Computers do not exist in AD but do available in SCCM. In this blog post, we will get the list of all computers from AD into the SCCM database. After which, we can create custom reports for identifying the list of the computer's AD and not within SCCM and do vice versa. I have used the MaikKoster Old blog post as reference and made some customization's/Updates to…
Another interesting package replication problem.John Marcum posted solution on his blog with DB edit but that did not solve my problem though package issue is similar. I have to do couple of more things to fix the issue what John said in his blog. Am not going to explain more about why it happens etc. If you interested,Read Johns Blog. When you do Preload for Bulk number of PCK file,Sometimes you may not succeeded in decompressing all the files and arise issues like below from distmgr.log . From the console,if you look at package status,you end up with Install pending…