Few Days ago,Microsoft released Cumulative Update 3 (supersedes Cumulative update 2 ) for Configuration Manager 2012 SP1 which has around 18 fixes related OSD,Powershell,Software Distribution etc. More about the hotfix and download refer http://support.microsoft.com/kb/2882125 Installation of Cumulative Update 3 on Configurations manager SP1 is straight forward.you would need to follow the steps,next,next ,done. This Cumulative Update contains updates for CAS,Primary site(both Stand alone,Hierarchy),Secondary Site,SMS Provider,Configmgr Console and Configmgr Client. I have updated my Lab with Cumulative Update 3 today,saw couple of packages gets created with this update. Note:Close the Configuration Manager Administrator Console before you install this update. After the…
Author: Eswar Koneti
With the default report,you can get Count or list of PC’s from domain Eg: Computers in a specific workgroup or domain. If you want to know the count of PC’s with specific role like standalone workstation a.k.a Workgroup computers,member workstation,member server,standalone server etc,use the below report . I use property called DomainRole0 from V_GS_Computer_system view with case statement. select "Role"= case domainrole0 when 0 then 'Standalone Workstation' when 1 then 'Member Workstation' when 2 then 'Standalone Server' when 3 then 'Member Server' when 4 then 'Backup Domain Controller' when 5 then 'Primary Domain Controller' else 'No' end, Count(*) [Total] from…
Microsoft just released Cumulative Update 3 for System Center 2012 Configuration Manager (Configmgr) SP1.This update fixes issues on OSD,Powershell,Software Distribution,Windows In tune,Endpoint Protection,Site Systems,Reporting,Software Updates. Supported Platforms: This update adds support for Windows 8.1-based client computers in Microsoft System Center 2012 Configuration Manager Service Pack 1. Windows 8.1 is added to the supported platform list for the following features: Software distribution Software update management Compliance Settings To download the Update and know more about issues that are fixed,Please refer http://support.microsoft.com/kb/2882125. Note: This update do not require Restart.
Inventory report for laptops who have webcam feature ? You can use this report both on SCCM 2007 and Configmgr 2012 Environment. select cs.name0 [Computer name], cs.username0 [Last loggedin User], os.Caption0 [OS],os.InstallDate0 [OS Installed Date], cs.Manufacturer0,cs.Model0 , WS.LastHWScan [Reported Date to SCCM] from v_GS_COMPUTER_SYSTEM cs,v_GS_SYSTEM_ENCLOSURE se,v_GS_OPERATING_SYSTEM OS, v_GS_WORKSTATION_STATUS WS where cs.ResourceID=se.ResourceID and cs.ResourceID=OS.ResourceID and cs.ResourceID=WS.ResourceID and se.ResourceID in (select ResourceID from v_GS_SYSTEM_DEVICES where Name0 like '%camera%' or Name0 like '%webcam%') and SE.ChassisTypes0 in ( '8','9','10','11','12','14','18','21') group by cs.Name0,cs.UserName0,cs.Manufacturer0,cs.Model0,OS.Caption0,OS.InstallDate0,WS.LastHWScan Note: There reports are created for for Dell and Lenovo models only.Webcam name differs from manufacture to manufacture,so if you have other…
By Default,during the installation of reporting services role ,Configuration Manager 2012 will create and publish the reports to Configmgr_SiteCode (Ex:Configmgr_P01) Folder in Report Manager if you have not changed the default path name while installing Configuration Manager. while the default reports always do not meet our needs in real time,it is required to create custom reports using tools like report builder or visual studio etc .while using these tools to create custom reports (.rdl file) ,we cannot always take the .RDL file from tool that we created and upload to your Configmgr reports folder,if at all you do this,then…
In my Previous blog,I posted script On How to Refresh/Redistribute One package on List of Distribution Points http://eskonr.com/2013/09/sccm-configmgr-powershell-script-refresh-package-on-multiple-distribution-points/ This post talks about how to Refresh / Redistribute list of packages to Single distribution Point. import-module F:\sccm\AdminConsole\bin\ConfigurationManager.psd1 #Change the site Code $SiteCode = "P01" #provide the path list of packages to be Refreshed $packages =GC "C:\scripts\pkglist.txt" foreach ($package in $packages) { #Provide the DP server Name to be refreshed ON $Server = "CM12DP01" #host name is enough,no FQDN is required $pkgs = Get-WmiObject -Namespace "root\SMS\Site_$($SiteCode)" -Query "Select * From SMS_DistributionPoint WHERE PackageID='$Package' and serverNALPath like '%$Server%'" foreach ($pkg in $pkgs) {…
Running SQL queries directly from SQL server management studio is not safe method until you know what you are doing but it is always Good to use reporting services in Configmgr 2012. when you are running SQL code using SQL management studio,you get error something like below due to insufficient privileges on the selected Database: The SELECT permission was denied on the object ‘v_PackageStatusRootSummarizer’, database ‘CM_P01′, schema ‘dbo’. Permission was denied because you do not have enough read permissions to execute the query against the database. Get the read permissions on the selected Database from your Configmgr admin team. How…
Simple and useful report for troubleshooting package issues: Package compliance Status report to know what is the success rate of the Applications/Packages/Driver/SUP on the Distribution Points: select UPPER(SUBSTRING(PSD.ServerNALPath,13,CHARINDEX('.', PSd.ServerNALPath) -13)) AS [DP Name],count(*) [Targeted] , count(CASE when PSD.State='0' then '*' END) AS 'Installed', count(CASE when PSD.State not in ('0') then '*' END) AS 'Not Installed', round((CAST(SUM (CASE WHEN PSD.State='0' THEN 1 ELSE 0 END) as float)/COUNT(psd.PackageID ) )*100,2) as 'Success%', psd.SiteCode [Reporting Site] From v_PackageStatusDistPointsSumm psd,SMSPackages P where p.PackageType!=4 and (p.PkgID=psd.PackageID) group by PSd.ServerNALPath,psd.SiteCode order by 5 SSRS report looks like: To know list of failed packages on the…