Month: June 2012

Posted on June 14, 2012 by | 0 Comments | 182 Views
Long Ago have posted sccm report about all advertisements that are currently assigned to specific computer http://eskonr.com/2010/12/sccm-report-to-list-all-the-advertisement-that-are-currently-assigned-to-computer/ this post gives you the advertisements targeted to specific Computer which are only MSI based. Create simple report with below SQL Query SELECT distinct adv.AdvertisementName,adv.AdvertisementID,pkg.PackageID,advinfo.PackageName,adv.ProgramName from v_Advertisement adv     inner join v_FullCollectionMembership FCM ON FCM.CollectionID=adv.CollectionID     Inner join…
Read more »
#SCCM / #Configmgr 2012 SP1 Upcoming Enhancements

Posted on June 14, 2012 by | 0 Comments | 45 Views
The Product Group have recently announced the Beta of ConfigMgr 2012 SP1 at TechNet 2012 North America. You can view the announcement at http://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/MGT309 Kent blogged about new enhancements over http://blog.coretech.dk/kea/configmgr-2012-sp1-announced-teched-2012/ Enhancements include: Platform Support: Windows 8 Windows 8 tablet (Intel SoC) support Mac OS X Linux and Unix Operating System Deployment: Windows To Go…
Read more »
Publish Custom Office Templates End users

Posted on June 5, 2012 by | 1 Comment | 4,282 Views
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…
Read more »

Posted on June 5, 2012 by | 9 Comments | 23,128 Views
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…
Read more »

Posted on June 2, 2012 by | 9 Comments | 7,232 Views
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…
Read more »

Posted on June 1, 2012 by | 0 Comments | 777 Views
  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
Read more »