System Center Blog

    by Mikael Perhult (SCCMx)

    Browsing Posts published by mikaelp

    This script will search AD from a search root with attribute filter and export the output to a csv file. On Error Resume Next Const ADS_SCOPE_SUBTREE = 2 Set objFileSystem = CreateObject("Scripting.FileSystemObject") Set objFile = objFileSystem.OpenTextFile("results_" & date & ".csv", 2, True, 0) Set objConnection = CreateObject("ADODB.Connection") objConnection.Provider = "ADsDSOObject" objConnection.Open "Active Directory Provider" Set […]

    When creating a Build and Capture Task using OS Install Files from full media only use one partition. Otherwise will the Setup and Configure fail during install. Example: Use 1 partition – Windows Primary 100% variable “OSDisk” Use variable when applying OS.

    Good link for removing a DP from SCCM database:  

    SELECT* FROM v_UpdateInfo INNERJOIN v_UpdateContents ON v_UpdateInfo.CI_ID = v_UpdateContents.CI_ID INNERJOIN v_UpdatePrograms ON v_UpdateContents.ContentCI_ID = v_UpdatePrograms.UpdateID INNERJOIN v_Package ON v_UpdatePrograms.PackageID = v_Package.PackageID where v_Package.PackageID =‘XXX000YY’and v_UpdateInfo.ModelName =‘Site_FEECBF49-05EA-435B-9EC7-3356BB4B2837/SUM_e71ef51d-c577-4e59-9b87-31967547f41c’ ORDERBY v_UpdateInfo.ArticleID

    SELECTDISTINCT v_ClientAdvertisementStatus.AdvertisementID, v_Advertisement.AdvertisementName, dbo.v_Package.PkgSourcePath FROM dbo.v_Package INNERJOIN dbo.v_Advertisement ON dbo.v_Package.PackageID = dbo.v_Advertisement.PackageID RIGHTOUTERJOIN dbo.v_ClientAdvertisementStatus ON v_Advertisement.AdvertisementID = v_ClientAdvertisementStatus.AdvertisementID WHERE (v_ClientAdvertisementStatus.LastStateName =‘succeeded’)AND(v_ClientAdvertisementStatus.LastStatusTime >DATEADD(day,– 90,GETDATE())) ORDERBY dbo.v_Advertisement.AdvertisementName  

    SELECTCOUNT(*)ASCount, v_ClientAdvertisementStatus.AdvertisementID, v_Advertisement.AdvertisementName FROM v_ClientAdvertisementStatus LEFTOUTERJOIN v_Advertisement ON v_Advertisement.AdvertisementID = v_ClientAdvertisementStatus.AdvertisementID WHERE (v_ClientAdvertisementStatus.LastStateName =‘succeeded’)AND(v_ClientAdvertisementStatus.LastStatusTime >DATEADD(day,– 30,GETDATE())) GROUPBY v_ClientAdvertisementStatus.AdvertisementID, v_Advertisement.AdvertisementName ORDERBYCountDESC  

    You install several Updates. After the successful installation, you notice you cannot add or remove features/roles in the Server Manager After receiving this error i first installed the System Update Readiness Tool for Windows Server 2008 R2 x64 Edition (KB947821) [February 2011] which i hoped would give me an indication of the issue. After installing […]

    These Software Updates should not be included in a Task sequence Software Update deployment since they have multiple reboots in it’s setup. Task sequence fails in Configuration Manager if software updates require multiple restarts  

    This setting in SUSDB makes patch download go much faster. It also solves the issue with build and capture if the software update deployment contains to many updates. From Solution 3 The current number of roundtrips allowed by WSUS is 200 per client session. The default maximum size of XML data that WSUS allows […]

    In order to create a break in Task sequence for testing purposes can this line be added:   “%deployroot%\tools\%architecture%\serviceUI.exe” -process:tsprogressui.exe c:\windows\system32\cmd.exe