SCCM Configuration Baseline


Dear Team,

I have created a Configuration Item to read the value from a registry using script method and I assigned the configuration Item to a Baseline and deployed to a workstations successfully.

Now i have to understand what is the SQL table contains the value that returned by the Configuration Baseline.

solved 0
manikanta tunuguntla 4 months 6 Answers 92 views Beginner 0

Answers ( 6 )

  1. Hi,

    You requirement is to capture the information which is available on path ComputerHKEY_CURRENT_USERSoftwareMicrosoftInternet ExplorerMain
    key value as Start Page -eq “what”

    for this you can directly using sccm baseline registrykey method. that will capture the information on client side.

    Use user context to run on client side. because you are capture HKCU value.


    Best answer
    • Hi,

      Could you please share the more information on how to create and also where the values will resides in SCCM.
      Because in my environment we have different homepages for different users.

      Thanks in advance.

  2. Sorry team, if my question was not clear,

    I have created a DCM like below

    cd hkcu:
    $compliant = $false
    $Startpage = Get-ItemProperty -Path “HKCU:SoftwareMicrosoftInternet ExplorerMain” -ErrorAction ‘Stop’ | Select-Object -ExpandProperty ‘Start Page’ -ErrorAction ‘SilentlyContinue’
    if($Startpage -ne $null)
    Write-Host $Startpage
    Write-Host “Compliant”

    Here i need that $startpage information, could you please help to get that value what is written

  3. Hi,

    SCCM Baseline value deployments information will be available on this below table and views.

    v_ConfigurationItems – View name

    for SQL query to find the baseline deployment status for specific compliant settings use below query
    Vrs.Name0 as ‘MachineName’,
    Case cs.ComplianceState
    when 1 then ‘Compliant’
    when 2 then ‘Non Compliant’
    when 4 then ‘Error’
    Else ‘Unknown’ End as ‘ComplianceStatus’,
    cs.LastComplianceMessageTime as ‘LastUpdateTime’,
    Vrs.User_Name0 as ‘UserName’,
    OP.Caption0 as ‘Operating System’,
    Lci.DisplayName as ‘ComplianceSettingsName’
    FROM v_R_System Vrs
    Left JOIN v_BaselineTargetedComputers Btc ON Vrs.ResourceID = Btc.ResourceID
    Left JOIN v_ConfigurationItems Ci ON Btc.CI_ID = CI.CI_ID
    Left JOIN v_CICurrentComplianceStatus Cs ON cs.CI_ID = Ci.CI_ID and cs.ResourceID = Btc.ResourceID
    Left JOIN v_LocalizedCIProperties_SiteLoc Lci ON Lci.CI_ID = Ci.CI_ID
    Left JOIN v_CH_ClientSummary SUMMARY ON Vrs.ResourceID = SUMMARY.ResourceID
    WHERE Lci.DisplayName in (‘Baseline_Name’) — Change the baseline name
    ORDER BY cs.ComplianceState

  4. Hi Team,

    Is there any log and which folder this DCM content will process to see the result in workstation.

Leave an answer

Sorry, you do not have a permission to answer to this question .