Jump to content


NickPilon

Established Members
  • Posts

    9
  • Joined

  • Last visited

Everything posted by NickPilon

  1. Like Garth said, it is not necessary to enable Software Inventory to use Software Metering if you add rules manually even if it's mentioned on Technet. However, I always thought we need to enable software inventory to use the automatic rules creation.
  2. This is because Win XP is no more supported by Microsoft. Just kidding. What is the source folder of other software update package? Win XP critical is configured the same way as other packages?
  3. One primary with multiple MP is probably the way to go with your environment. For sure, you will need at least one DP by location. What is your total count of devices? You said 1000-3000 by location (30). This is between 30K to 90K? CAS replication is good but if you are able to fit in one primary. Do it! Nick System Center Dudes
  4. Hi Drakmah, What are the logs Distmgr.log and Smsdpprov.log is saying? If you are blocked in your troubleshooting, please refer to this Distribution Point Installation Guide. Make sure all the steps are OK and you should be fine. Let me know. Nick www.systemcenterdudes.com
  5. First, why do you need 2 site code for workstations and servers? If you want to install client on server with SE2, make sure your boundary group site assignment for your servers boundary is based on SE2. Maybe you are having an overlap configuration? Do you have any screenshots? Thanks Nick Pilon www.systemcenterdudes.com
  6. The computers are on the same ADUC OU? If they are not detected, did you try to run a system discovery in the Discovery Methods and check the log adsysdis.log. If they are still not detected, I will suggest to check your system discovery options and boundaries. Nick Pilon www.systemcenterdudes.com
  7. Do you still have duplicate like this? SELECT SYS.Name0 AS Computer_Name, CCS.ComplianceState AS 'Compliance_State', MAX(CCS.LastComplianceMessageTime) AS 'Last_Scan' FROM v_CICurrentComplianceStatus CCS INNER JOIN v_LocalizedCIProperties_SiteLoc CIP ON CIP.CI_ID = CCS.CI_ID INNER JOIN v_R_System SYS ON SYS.ResourceID = CCS.ResourceID WHERE CIP.DisplayName = 'U - IE Proxy (None) Baseline' AND SYS.Name0 = 'Computer2' GROUP BY SYS.Name0, CCS.ComplianceState Nick Pilon http://www.systemcenterdudes.com
  8. Your query don't give me double like you on my side. By the way I took more time to check your query and I handle it by removing v_BaselineTargetedComputers and v_ConfigurationItems. Can you try to run the query below? SELECT SYS.Name0 AS Computer_Name, MAX(CCS.LastComplianceMessageTime) AS 'Last_Scan', USR.User_Name0 AS User_Name, USR.Full_User_Name0 AS Full_Name, CASE CCS.ComplianceState WHEN 1 THEN 'Compliant' WHEN 2 THEN 'Non-Compliant' ELSE 'Error' END AS 'Compliance_State', CIP.DisplayName AS DCM_Baseline_Name FROM v_CICurrentComplianceStatus CCS INNER JOIN v_LocalizedCIProperties_SiteLoc CIP ON CIP.CI_ID = CCS.CI_ID INNER JOIN v_R_System SYS ON SYS.ResourceID = CCS.ResourceID LEFT OUTER JOIN v_R_User USR ON USR.User_Name0 = SYS.User_Name0 WHERE CIP.DisplayName = 'U - IE Proxy (None) Baseline' GROUP BY SYS.Name0, USR.User_Name0, USR.Full_User_Name0, CCS.ComplianceState, CIP.DisplayName Nick Pilon http://www.systemcenterdudes.com
  9. Your query is working on my side but I would have done it like this. SELECT SYS.Name0 AS Computer_Name, MAX(CCS.LastComplianceMessageTime) AS 'Last_Scan', USR.User_Name0 AS User_Name, USR.Full_User_Name0 AS Full_Name, CASE CCS.ComplianceState WHEN 1 THEN 'Compliant' WHEN 2 THEN 'Non-Compliant' ELSE 'Error' END AS 'Compliance_State', CIP.DisplayName AS DCM_Baseline_Name FROM v_BaselineTargetedComputers BTC INNER JOIN v_R_System SYS ON SYS.ResourceID = BTC.ResourceID INNER JOIN v_ConfigurationItems CI ON CI.CI_ID = BTC.CI_ID INNER JOIN v_CICurrentComplianceStatus CCS ON CCS.CI_ID = CI.CI_ID AND CCS.ResourceID = BTC.ResourceID INNER JOIN v_LocalizedCIProperties_SiteLoc CIP ON CIP.CI_ID = CI.CI_ID LEFT OUTER JOIN v_R_User USR ON USR.User_Name0 = SYS.User_Name0 WHERE CIP.DisplayName = 'U - IE Proxy (None) Baseline' GROUP BY SYS.Name0, USR.User_Name0, USR.Full_User_Name0, CCS.ComplianceState, CIP.DisplayName MAX beside CCS.LastComplianceMessageTime is a good thing which will show you only the last scan. Nick Pilon http://www.systemcenterdudes.com
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.