syswow64 blog

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                       dbo.v_LocalizedCIProperties_SiteLoc AS CIProp ON CIProp.CI_ID = CI.CI_ID INNER JOIN                       dbo.v_StateNames AS SNames ON CCS.ComplianceState = SNames.StateID WHERE     (CIProp.DisplayName = 'BL - WK DCM') AND (SNames.TopicType = 401) GROUP BY CIProp.Displa

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                       dbo.v_LocalizedCIProperties_SiteLoc AS CIProp ON CIProp.CI_ID = CI.CI_ID INNER JOIN                       dbo.v_StateNames AS SNames ON CCS.ComplianceState = SNames.StateID WHERE     (CIProp.DisplayName = 'BL - WK DCM') AND (SNames.TopicType = 401) GROUP BY CIProp.D

  "Error A Previous version of Nightwatchman has been detected on your machine.  You must remove Nightwatchman before continuing with the install"   The uninstaller via command line or Programs and Features would result in the above error message. It was discovered that the MST file previously used to configure the MSI had been copied from from an earlier version 5, and had included references to the previous product ID. By deleting the Transforms record the uninstallation was able to complete. [HKEY_CLASSES_ROOT\Installer\Products\E5A3EA51A6783284B9EDA9396E6A772C] "ProductName"="1E Agent" "PackageCode"="7D32A2D932D351543AA64E478D052BFD" "Version"=dword:06000064 "Transforms"=C:\WINDOWS\Installer\{15AE3A5E-876A-4823-9BDE-9A93E6A677C2}\Custom1EAgent.mst

  "Error A Previous version of Nightwatchman has been detected on your machine.  You must remove Nightwatchman before continuing with the install"   The uninstaller via command line or Programs and Features would result in the above error message. It was discovered that the MST file previously used to configure the MSI had been copied from from an earlier version 5, and had included references to the previous product ID. By deleting the Transforms record the uninstallation was able to complete. [HKEY_CLASSES_ROOT\Installer\Products\E5A3EA51A6783284B9EDA9396E6A772C] "ProductName"="1E Agent" "PackageCode"="7D32A2D932D351543AA64E478D052BFD" "Version"=dword:06000064 "Transforms"=C:\WINDOWS\Installer\{15AE3A5E-876A-4823-9BDE-9A93E6A677C2}\Custom1EAgent.mst