Author: Eswar Koneti

This post is going to be a something new today to publish Custom Office templates made available to all users when they open PowerPoint or Word or Excel Office applications. This can be done several ways like AD group policy management or Scripting or other ways But I would prefer to do it using Configuration Manager. After end of the session,You should create and deploy these Office 2010 templates for users with Microsoft Word 2010, PowerPoint 2010, and Excel 2010. Here is what the requirement is and available to all end users when the user go for New file. The…

Creating collection to get computers that starts and end with particular string is used mostly using % .If this percentile used at the end of the variable name, you get all computer names that starts from particular string and if you use this in the beginning, gets all computers that ends with particular string. Examples : To get all computer names that starts with ESKONR, use ESKONR% , to get all computer name that ends with ESKONR ,use %ESKONR. But what if  need all computer name that has letters like ESK in the middle of the computer name. Let says…

Previous report list the packages which are successfully distributed to Distribution Points http://eskonr.com/2012/06/sccm-report-total-number-of-packages-targeted-to-dp/ This post gives you more information about package status for selected distribution Point. Report for packages which are Pending: select s.sitecode,s.packageid,p.name,s.sourceversion as "dpversion",p.storedpkgversion as latesteversion from v_PackageStatusDistPointsSumm s join smspackages p on s.packageid = p.pkgid where s.installstatus !='Package Installation complete' and s.servernalpath like '%DPserverName%' order by s.packageid Report for packages which are Installed : select s.sitecode,s.packageid,p.name,s.sourceversion as "dpversion",p.storedpkgversion as latestversion from v_PackageStatusDistPointsSumm s join smspackages p on s.packageid = p.pkgid where s.installstatus ='Package Installation complete' and s.servernalpath like '%DPSERVERNAME%' order by s.packageid Report for packages which are…

  Full Detials : http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/cdfc6114-09d8-4e85-a51a-ca279a36454a SELECT v_Package.PackageID, Name,    v_DistributionPoint.LastRefreshTime     FROM v_Package INNER JOIN v_DistributionPoint ON v_Package.PackageID = v_DistributionPoint.PackageID WHERE v_DistributionPoint.ServerNALPath LIKE '%DPNAME%' Where DPNAME is Distribution point server name

If you have referred to my previous report linked report http://eskonr.com/2012/05/sccm-linked-report-count-of-computers-assigned-to-specific-ad-site/ this would be easier for you to go. You need to create 2 reports 1)Count of MS Office Versions with Service Pack 2) list the computers with MS Office and Service pack installed Create new report from reports node for 2) list the computers with MS Office and Service pack installed using the below SQL query(quotes posted in this blog are converted to fancy,please replace them with correct ones in your report)  : select sys.name0,sys.AD_Site_Name0,FCM.SiteCode,ARP.DisplayName0,ARP.Version0 from V_R_system sys inner join v_Add_Remove_Programs ARP on arp.resourceID=sys.ResourceID inner join v_FullCollectionMembership FCM on…

I tried using some third party tools to download TechNet library pages for sccm 2012 sometime ago to read them offline(no internet) but i couldnt grab all the pages :(  But now MS has released the technet library pages into .DOCX,PDF and CHM files. The downloadable files listed on this page contain the product documentation for System Center 2012 Configuration Manager. The available file types include: CHM (as part of the Help Update Wizard msi) DOCX PDF Via  http://www.microsoft.com/en-us/download/details.aspx?id=29901 More info System Center 2012 Configuration Manager Help Update Wizard (v2.0) Use the help update wizard to install a local copy…

  Question from Community : When client downloaded a package into the cache and is removed from the collection with the advertisement will the content stay in the cache? Then if you put the client back into the collection later will it download the package or will is run from the cache if the content stays? Configuration manager will not clean up the content from the cache, files will be available and usable. Content is not specific to any advertisements OR collection memberships. Clients simply require the content and a version of that content; if it's already in the client…

  Full Details :http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/7b4d3810-a262-4c63-8dd6-7cc906b85941 select sys.name0,sys.AD_Site_Name0,FCM.SiteCode,ARP.DisplayName0,ARP.Version0,ARP.InstallDate0 from V_R_system sys inner join v_Add_Remove_Programs ARP on arp.resourceID=sys.ResourceID inner join v_FullCollectionMembership FCM on FCM.ResourceID=sys.ResourceID and arp.DisplayName0 like '%project reader%' and ARP.Version0 < '4%' For collection ,follow the post here on http://eskonr.com/2012/05/sccm-collection-computers-with-lower-version-application/