System Center Blog

    by Mikael Perhult (SCCMx)

    Sometimes when using HTA screens in a SCCM TS there is a need for hide the TS UI. (Or there might be another need for it). This has been solved by developing an exe file that has the possibility to run with two set of switches, /disable and /enable respectively so that the script or […]

    When there is a need for retrieve dhcp server info this cmd line can be used. The method will collect Last logon date and OS version so it can be used for dhcp server migration. Get-DhcpServerInDC | % { Get-ADComputer -Identity ($_.dnsname).Substring(0, ($_.dnsname).IndexOf(‘.’)-0) -Properties LastLogonDate,OperatingSystem | Select-Object Name,LastLogonDate,OperatingSystem }

    A best practice is to remove legacy groove from Office 365 or 2016 msi package. For msi use /admin and deselect Groove when creating a msp file For Office 365 use config file and add: <ExcludeApp ID=”Groove” />

    For support of Windows 10 against a Wsus 3.0 SP2 Server 2008 R2 these patches and cmd lines is needed: WSUS-KB2734608-x64 WSUS-KB2828185-x64 WSUS-KB2720211-x64 WSUS-KB2938066-x64 %windir%\system32\inetsrv\appcmd.exe set config -section:system.webServer/httpCompression /-[name=’xpress’]  

    When moving SQL Files within same server but different disks/volumes the SQL Task Detach/Attach can be used. However must DB owner be verified to be set to ‘sa’ and the following command must be run. ALTER DATABASE CM_PS1 SET TRUSTWORTHY ON Otherwise is there errors in SMS Provider Log and SMS Policy Provider log.  

    By creating a separate query with the Deployment ID it is simpler to follow status of a running OSD Task Sequence:   (select stat.*, ins.*, att1.*, att1.AttributeTime from SMS_StatusMessage as stat left join SMS_StatMsgInsStrings as ins on stat.RecordID = ins.RecordID left join SMS_StatMsgAttributes as att1 on stat.RecordID = att1.RecordID inner join SMS_StatMsgAttributes as att2 on […]

    Actions that can be triggered via a script:   on error resume next dim oCPAppletMgr 'Control Applet manager object. dim oClientAction 'Individual client action. dim oClientActions 'A collection of client actions. set oCPAppletMgr=CreateObject("CPApplet.CPAppletMgr") if err.number <> 0 then Wscript.echo "Could not find Configuration Manager object" WScript.Quit end if set oClientActions=oCPAppletMgr.GetClientActions if err.number<>0 then wscript.echo "Could […]

    For new installed systems can this collection query be used: 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_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId   WHERE dateDiff(dd, SMS_G_System_OPERATING_SYSTEM.InstallDate, GetDate()) < 1 and DATEDIFF(HH, SMS_R_System.SMSUUIDChangeDate, GETDATE()) <= 24  

    By running this query can source path, Inastall and Uninstall command being showed from a SQL query:   SELECT [CI_ID] ,[CI_UniqueID] ,[SDMPackageDigest] ,SDMPackageDigest.value(‘declare namespace p1=”http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest”; (p1:AppMgmtDigest/p1:DeploymentType/p1:Title)[1]’,‘nvarchar(max)’)AS DTTitle ,SDMPackageDigest.value(‘declare namespace p1=”http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest”; (p1:AppMgmtDigest/p1:DeploymentType/p1:Installer/@Technology)[1]’,‘nvarchar(max)’)AS DTTechnology ,SDMPackageDigest.value(‘declare namespace p1=”http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest”; (p1:AppMgmtDigest/p1:DeploymentType/p1:Installer/p1:Contents/p1:Content/p1:Location)[1]’,‘nvarchar(max)’)AS DTContentLocation ,SDMPackageDigest.value(‘declare namespace p1=”http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest”; (p1:AppMgmtDigest/p1:DeploymentType/p1:Installer/p1:InstallAction/p1:Args/p1:Arg)[1]’,‘nvarchar(MAX)’)AS Install, SDMPackageDigest.value(‘declare namespace p1=”http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest”; (p1:AppMgmtDigest/p1:DeploymentType/p1:Installer/p1:UninstallAction/p1:Args/p1:Arg)[1]’,‘nvarchar(MAX)’)AS Uninstall FROM[v_ConfigurationItems] WHERE CIType_ID = 21  

    Add these to the exclusion list of patches with multiple reboot. 2920189 2966034 2919355 2871690 ************* KB2891804 KB2533552 *** September *** KB2676562 *** October *** KB2984976 Visual c++ sp1 redist KB2565063 *** * *** * *** KB3001554 – September 2014 update for DVD playback in Windows 7 SP1 KB2952664 – Compatibility update for upgrading Windows […]