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.
Answers ( 6 )
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
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.
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
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
Hi Team,
Is there any log and which folder this DCM content will process to see the result in workstation.
Try this
https://docs.microsoft.com/en-us/mem/configmgr/develop/core/understand/sqlviews/compliance-settings-views-configuration-manager#compliance-settings-status-summarizer-views