SCCM Configuration Baseline

Question

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 2020-06-09T19:23:39+05:30 6 Answers 472 views Beginner
0

Answers ( 6 )

  2. karthikeyan
    1
    2020-06-11T05:27:41+05:30
    Reply

    Hi,

    You requirement is to capture the information which is available on path Computer\HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Main
    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.

    Thanks
    Karthikeyan

    Best answer
    • manikanta tunuguntla
      0
      2020-06-11T07:04:15+05:30
      Reply

      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.

  4. manikanta tunuguntla
    1
    2020-06-10T17:56:30+05:30
    Reply

    Sorry team, if my question was not clear,

    I have created a DCM like below

    cd hkcu:
    $compliant = $false
    $Startpage = Get-ItemProperty -Path “HKCU:\Software\Microsoft\Internet Explorer\Main” -ErrorAction ‘Stop’ | Select-Object -ExpandProperty ‘Start Page’ -ErrorAction ‘SilentlyContinue’
    if($Startpage -ne $null)
    {
    Write-Host $Startpage
    }
    else
    {
    Write-Host “Compliant”
    }

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

  6. karthikeyan
    1
    2020-06-10T17:20:23+05:30
    Reply

    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
    ———————————————————————
    Select
    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
    LEFT JOIN v_GS_OPERATING_SYSTEM OP ON Vrs.ResourceID = OP.ResourceID
    WHERE Lci.DisplayName in (‘Baseline_Name’) — Change the baseline name
    ORDER BY cs.ComplianceState
    ————————————————————————
    Thanks
    Karthikeyan

  8. manikanta tunuguntla
    0
    2020-06-10T16:35:35+05:30
    Reply

    Hi Team,

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

  10. Anoop C Nair
    1
    2020-06-09T20:03:46+05:30
    Reply

Leave an answer

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