Executing the HP Client Manager "Managed Computers by Total Memory" and "Managed Computers by Total Memory (Count)" reports produces the following SQL Error:
Sql error in query. Error: System.Data.SqlClient.SqlError: Arithmetic overflow error converting expression to data type int.Sql CommandText: -- MAX ROWCOUNT SET ROWCOUNT 50000 -- SELECT i.[Name], SUM(CAST(mem.Capacity AS int) / 1048576) AS 'Total Memory' FROM Inv_AeX_AC_Identification i JOIN Inv_HPCMS_WMI_Win32_PhysicalMemory mem ON i.[_ResourceGuid] = mem.[_ResourceGuid] GROUP BY i.[Name] ORDER BY SUM(CAST(mem.Capacity AS int) / 1048576), i.[Name]
Both reports are not able to take into account HP hardware with 2 GB dimms.
To work around this problem, follow these steps:
Download the modified HP Client Manager reports to the right and save on the Notification Server.
In the Console, browse to Reports > By Solution > HP Client Manager > HP Client Inventory.
Right-click HP Client Inventory folder and click Import.
In the new window, browse to the modified report and click Open.
You will need to repeat step 3 and select the second report. The new reports will appear in the navigation pane as soon as the import is complete.