Summary
This article provides information about steps to resolve issue with missing server CPU and RAM Usage information in Health Report.
Below error may possibly show up in "Remote_date" file under "Logs" folder in the installation directory.
May-15-2024 04:26:52 PM: Error in
GetServerCPUInfoJson An error occurred when loading the system Windows
PowerShell snap-ins. Please contact Microsoft Support Services.
Applies To
MachPanel v7.2.30 & above.
Pre-Requisites
Make sure the MachPanel Provisioning Service is running with updated configuration to use .Net Framework 4.x
Stop the "MachPanel Provisioning Service" on affected server.
Copy "MachSol.MachPanel.Provisioning-Svc.exe.config"
file from one of your "Remote Servers", like Exchange Server, over to affected control panel
server under directory ""C:\Program Files\MachSol\MachPanel Control
Server\bin".
Restart the "MachPanel Provisioning Service" on primary control server and check issue again.
Procedure
If CPU / RAM statistics are not being loaded for any secondary control server, you can fix this issue by following below steps on affected secondary server.
Open WMIMGMT.MSC.
Right click on "WMI Control (Local)" and click on Properties.
Click on "CIMV2 " and click "Security" button.
Add Group "Performance Monitor Users" and give "Enable Account" and "Remote Enable" permissions.
Lastly, go to Computer Management >> Groups and add "MachPanel_Web" in "Performance Monitor Users" group.
Additional Information
If you need to clear existing data of last 2 days from MachPanel Database, use below script. Open MachPanel_Db in SQL Server Management Studio (SSMS) as MachPanel_Db user.
delete from Hb_tbl_Metrics_CSWebAppSettings WHERE ParentRecordId IN (select RecordId from Hb_tblMetrics_ControlServers where DateStampUtc > dateadd(dd, -2,getutcdate()))
delete from Hb_tblMetrics_CSDisks WHERE ParentRecordId IN (select RecordId from Hb_tblMetrics_ControlServers where DateStampUtc > dateadd(dd, -2,getutcdate()))
delete from Hb_tbl_Metrics_CSLicenses WHERE ParentRecordId IN (select RecordId from Hb_tblMetrics_ControlServers where DateStampUtc > dateadd(dd, -2,getutcdate()))
delete from Hb_tblMetrics_CSServices WHERE ParentRecordId IN (select RecordId from Hb_tblMetrics_ControlServers where DateStampUtc > dateadd(dd, -2,getutcdate()))
delete from Hb_tblMetrics_CSConfigurationReport WHERE ParentRecordId IN (select RecordId from Hb_tblMetrics_ControlServers where DateStampUtc > dateadd(dd, -2,getutcdate()))
delete from Hb_tblMetrics_ControlServers where DateStampUtc > dateadd(dd, -2,getutcdate())