Overview The downloadable files listed on this page contain the product documentation for the CTP2 release of System Center 2012 Service Pack 1. The available downloads include: App Controller in System Center 2012 Service Pack 1 - last updated June, 2012 Data Protection Manager in System Center 2012 Service Pack 1 - last updated June, 2012 Operations Manager in System Center 2012 Service Pack 1 - last updated June, 2012 Orchestrator in System Center 2012 Service Pack 1 - last updated June, 2012 Server Application Virtualization in System Center 2012 Service Pack 1 – last updated June, 2012 Service Manager…
Author: Eswar Koneti
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 v_CurrentAdvertisementAssignments CADV ON CADV.AdvertisementID=adv.AdvertisementID inner join v_Package pkg ON pkg.PackageID=adv.PackageID inner join v_AdvertisementInfo advinfo ON advinfo.AdvertisementID=adv.AdvertisementID where FCM.Name=@computer and adv.ProgramName !='[Virtual application]' and adv.ProgramName !='*' Prompt for Computer name : Select name from V_R_System Note:The above report is not limited to script…
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 support Application Delivery: Win 8 apps Deep link applications Network Cost Support PowerShell Provider PowerShell Cmdlets: Tasks exposed in the Administration Console Suitable experience for administrator (not the SDK) Align with PowerShell general contentions Bitlocker changes: TMP and PIN Used Space Bitlocker Prestaged media now…
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…