Skip to main content

Posts

Showing posts with the label DCM

SQL Reporting Services SCCM DCM

This article is dedicated to providing working examples for DCM (Desired Configuration Managment) reports, using reporting services 2008. 1. This report displays three statenames for the baseline called BL - WK DCM.  A count of Conpliance state populates the third column. SELECT     CIProp.DisplayName AS 'DCM Baseline Name', SNames.StateName, COUNT(CCS.ComplianceState) AS 'Compliance State Count' FROM         dbo.v_BaselineTargetedComputers AS BTC INNER JOIN                       dbo.v_ConfigurationItems AS CI ON CI.CI_ID = BTC.CI_ID INNER JOIN                       dbo.v_CICurrentComplianceStatus AS CCS ON CCS.CI_ID = CI.CI_ID AND CCS.ResourceID = BTC.ResourceID INNER JOIN        ...

SQL Reporting Services SCCM DCM

This article is dedicated to providing working examples for DCM (Desired Configuration Managment) reports, using reporting services 2008. 1. This report displays three statenames for the baseline called BL - WK DCM.  A count of Conpliance state populates the third column. SELECT     CIProp.DisplayName AS 'DCM Baseline Name', SNames.StateName, COUNT(CCS.ComplianceState) AS 'Compliance State Count' FROM         dbo.v_BaselineTargetedComputers AS BTC INNER JOIN                       dbo.v_ConfigurationItems AS CI ON CI.CI_ID = BTC.CI_ID INNER JOIN                       dbo.v_CICurrentComplianceStatus AS CCS ON CCS.CI_ID = CI.CI_ID AND CCS.ResourceID = BTC.ResourceID INNER JOIN       ...

DCM Script Detect SQL Edition SKUNAME

The script below will check if you have a version of SQLServer insalled and Echo the Edition Skuname and process Architecture.  This is particulary useful if you deem SQL Server on workstations to be a non-compliant trigger.  Now you can validate whether the echoed line is not allowed i.e SQL Server Enterprise On Error Resume Next ' First try SQL Server 2008/2008 R2: Set objWMIService = GetObject("WINMGMTS:\\.\root\Microsoft\SqlServer\ComputerManagement10") If Err.Number <> 0 Then     ' Next, try SQL Server 2005:     Set objWMIService = GetObject("WINMGMTS:\\.\root\Microsoft\SqlServer\ComputerManagement")     If Err.Number <> 0 Then         ' Next, try SQL Server 2012:         Set objWMIService = GetObject("WINMGMTS:\\.\root\Microsoft\SqlServer\ComputerManagement11")     End If End If Set colItems = objWMIService.ExecQuery( _ ...

DCM Script Detect SQL Edition SKUNAME

The script below will check if you have a version of SQLServer insalled and Echo the Edition Skuname and process Architecture.  This is particulary useful if you deem SQL Server on workstations to be a non-compliant trigger.  Now you can validate whether the echoed line is not allowed i.e SQL Server Enterprise On Error Resume Next ' First try SQL Server 2008/2008 R2: Set objWMIService = GetObject("WINMGMTS:\\.\root\Microsoft\SqlServer\ComputerManagement10") If Err.Number <> 0 Then     ' Next, try SQL Server 2005:     Set objWMIService = GetObject("WINMGMTS:\\.\root\Microsoft\SqlServer\ComputerManagement")     If Err.Number <> 0 Then         ' Next, try SQL Server 2012:         Set objWMIService = GetObject("WINMGMTS:\\.\root\Microsoft\SqlServer\ComputerManagement11")     End If End If Set colItems = objWMIService.ExecQuery...

SCCM DCM Symantec Backup Exec.Cloud

The intention this article is to provide an overview of DCM within SCCM and more importantly for some, the ability to create a baseline for Symantec Backup Exec.Cloud and generate a KPI. The DCM node within SCCM is made up of two parts Configuration Baselines and Configuration Items.  Right click on Configuration Items > New > Application configuration Item Identification: Provide a name and categor Detection Method: Select Use custom script (VBScript) Option Explicit                 If(IsNWMInstalled()) Then                 WScript.Echo("SymantexCloudBackup")                 End If                 Function IsNWMInstalled()          ...

SCCM DCM Symantec Backup Exec.Cloud

The intention this article is to provide an overview of DCM within SCCM and more importantly for some, the ability to create a baseline for Symantec Backup Exec.Cloud and generate a KPI. The DCM node within SCCM is made up of two parts Configuration Baselines and Configuration Items.  Right click on Configuration Items > New > Application configuration Item Identification: Provide a name and categor Detection Method: Select Use custom script (VBScript) Option Explicit                 If(IsNWMInstalled()) Then                 WScript.Echo("SymantexCloudBackup")                 End If                 Function IsNWMInstalled()       ...

SCCM DCM What is it?

What is Desired Configuration Management (DCM)? DCM is a feature in SCCM that will provide a framework for assisting organizations in both defining and enforcing corporate policies and standards for system configurations, whether related to the operating system or an application installed on the system. Feature include authoring and scheduling, model-based design leveraging Service Modeling Language (SML) (a component of Microsoft's Dynamic Systems Initiative) which makes the features we're about to discuss possible. Some of the key scenarios that drove the features Microsoft delivered in the final release of DCM include: Regulatory Compliance - demonstrating regulatory compliance in system configurations. Not only deploying a compliant standard system configuration, but being able to periodically prove adherence to these policies. Pre and post change configuration - Verify that no unplanned changes took place during the implementation of a planned change. Monitoring for "...

SCCM DCM What is it?

What is Desired Configuration Management (DCM)? DCM is a feature in SCCM that will provide a framework for assisting organizations in both defining and enforcing corporate policies and standards for system configurations, whether related to the operating system or an application installed on the system. Feature include authoring and scheduling, model-based design leveraging Service Modeling Language (SML) (a component of Microsoft's Dynamic Systems Initiative) which makes the features we're about to discuss possible. Some of the key scenarios that drove the features Microsoft delivered in the final release of DCM include: Regulatory Compliance - demonstrating regulatory compliance in system configurations. Not only deploying a compliant standard system configuration, but being able to periodically prove adherence to these policies. Pre and post change configuration - Verify that no unplanned changes took place during the implementation of a planned change. Monitoring for "...