In my previous blog post,i talked about how to compare 2 distribution points to see if they both have any applications mismatch.This blog post talks about how to distribute the missing apps to the Distribution Point. I have used basic inbuilt Configmgr powershell commands for this activity,more via here Note:Use the package names as input file rather Package ID’s. Below powershell script works for applications,packages,driver packages,boot images and OS images.You need to remove the # tag(to uncomment) to distribute specific package type. #change the path of psd1 import-module F:\sccm\AdminConsole\bin\ConfigurationManager.psd1 #Change the site Code cd P01: $SiteCode = "P01" #provide the…
Author: Eswar Koneti
Good news to Configmgr guys.Yesterday Microsoft announced another Free book called “Microsoft System Center: Troubleshooting Configuration Manager “ which talks about site hirarchy,distribution points,understanding configuration manager components,log files,troubleshooting scenarios. I think this guide will provide you to understand various components of Configuration Manager on both the server and client side work together while performing the tasks also the real world troubleshooting with log files. Download the Configuration manager 2012 Troubleshooting Guide from here If you are looking for Configuration Manager 2012 Field Experience guide from Microsoft experts,download it from here via http://blogs.msdn.com/b/microsoft_press/archive/2013/11/12/free-ebook-microsoft-system-center-troubleshooting-configuration-manager.aspx
If you search on the web for Configmgr patch compliance report ,you get various links that talk about compliance reports ,you utilize them to start working on the customized report the way you want but i was looking for something that give me the overall compliance status for each month ? search did not provide me much useful information on this ,I then decided to create and share to public. How do you monitor the overall patch progress for the current month and its previous months ? let say,for the current month,compliant machines are 500(which have got all approved patches) and…
Full details:http://social.technet.microsoft.com/Forums/systemcenter/en-US/82a7862a-fc1c-4c45-9635-ee44489c2673/file-inventory-report-query-by-name-count-and-machineid?forum=configmgrreporting select cs.Name0 [Computer name],COUNT(*) as [No of Times] from v_GS_SoftwareFile SF,v_GS_COMPUTER_SYSTEM cs where FileName like '%.mdf%' and SF.ResourceID=cs.ResourceID group by cs.Name0 order by 2 desc
Long ago,posted Configmgr SP1 SQL Views in spreadsheet which you can download it via post http://eskonr.com/2013/04/download-sccm-2012-sql-views-documentation/. SQL Views are very useful while working with reports and it saves lot of time in searching the particular information if you are unsure where it resides. SQL Views provides the information help you in creating custom reports, determine which configmgr 2012 R2 SQL views contain the information you need for your reports, and identify the path between the necessary SQL views and determine what columns can be used to join them. With the release of Configmgr 2012 R2,there has been some SQL Views…
There was a question in forum list about how to get count of clients by its status (active,obsolete etc). I looked at it if there is any way to get it without report but No. In Configuration Manager 2007,to know the count of Computers from collection,You right click on collection,click show Count will give us the information but in Configmgr 2012,this is not possible until you develop some custom tools to get this.By default ,You can only see the total number of clients Count and members visible but not how many active,obsolete etc . I created simple report…
Second Tuesday of every month called Microsoft patch Day 🙂 Patches get released and configmgr* guys busy in testing ,moving them to production. As usual, I have Downloaded the patches,added to the package,deployed to Distribution Points ,all returned success (Decompressed the PCK successfully).Until here Good. While testing the patches on one of the server,it just stands at downloading /Preparing for installation for quite long but nothing happens.Huh ? (login with mstsc /admin) ok,start with basic troubleshooting by looking at contentTransfermanager.log and datatransferservice.log because these two logs plays the role whether the client attempts to download content or not ContentTransferManager.log--> logs…
We have been seeing many hotfixes and Cumulative updates for configmgr 2012 product .For each hotfix /CU level,the client version will get change. As you test and deploy these hotfixes /CU's in your environment ,you are also required to maintain the environment both clients and server client to the same level as your site running. Being configmgr admin,you are responsible to maintain clients levels same as that of your site server.i created SSRS Report and linked report to list down all the client versions, Description of Version name and its count. Use this below SQL query to count the Client…