was looking at machine to see what advertisements /packages are targeted to sccm client though you can get this information directly from SCCM reports if you have access else wrote a simple script which gives you what packages with program name,Command line used ,ADV ID,Package ID information. ON ERROR RESUME NEXT Set fso=CreateObject("scripting.filesystemobject") 'create text file with list of computers what you need Set objinputfile=fso.OpenTextFile("computers.txt",1,True) 'pipe the results into output.txt file Set objoutputfile=fso.OpenTextFile("Output.txt",2,True) 'Read the input file until end of line Do While objinputfile.AtEndOfLine <> True strcomputer=objinputfile.ReadLine objoutputfile.WriteLine(strcomputer) Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\ccm\Policy\Machine") Set Colitems = objWMIService.ExecQuery("SELECT…
Author: Eswar Koneti
Overview : This Community Technology Preview (“CTP2”) enables System Center customers to jointly evaluate System Center 2012 and Windows Server 2012 Release Candidate. CTP2 includes updates and enhancements to the following System Center 2012 components: Virtual Machine Manager Improved Support for Network Virtualization Extend the VMM console with Add-ins Support for Windows Standards-Based Storage Management Service, thin provisioning of logical units and discovery of SAS storage Ability to convert VHD to VHDX, use VHDX as base Operating System image Configuration Manager Support for Windows 8 Support for Mac OS clients Support for Linux and Unix servers Data Protection Manager Improved…
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…
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…