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
Author: Eswar Koneti
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/
Full Details http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/7b4d3810-a262-4c63-8dd6-7cc906b85941 This collection is created using sub selected queries http://eskonr.com/2011/12/sccm-collection-sub-selected-quiries/ select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID not in (select SMS_R_SYSTEM.ResourceID from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceId = SMS_R_System.ResourceId where (SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%project reader%" or SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "%project reader%") and (SMS_G_System_ADD_REMOVE_PROGRAMS.Version > "4%" or SMS_G_System_ADD_REMOVE_PROGRAMS_64.Version > "4%"))
Project Description The tool is designed for IT Professionals to troubleshoot SCCM/CM12 Client related Issues. The Client Center for Configuration Manager provides a quick and easy overview of client settings, including running services and Agent settings in a good easy to use, user interface. This Tool is currently an alpha Version. For testing purposes only... ! Requirements Windows Remote Management (WinRM) must be enabled and configured on all target computers. (Run "winrm quickconfig" in a command prompt.) Microsoft .NET Framework 4 (on the computer running the Tool) Configuration Manager 2012 Agent on the target computer (some features will also work…
In System Center 2012 Configuration Manager, you can no longer deploy a secondary site server using Setup (wizard or scripted). Instead, you must use the Configuration Manager console to create a new secondary site. This is less than ideal if you want to deploy several secondary sites or want to automate the process for any other reason. This project provides a script that will allow you to install a new System Center 2012 Configuration Manager secondary site server without using the Configuration Manager console. The script essentially performs the same actions as the Configuration Manager console, writing changes to the…