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.
Applies To HP Client Manager Report Pack 6.2.1007
Logged in Littlebuggy (Altiris - Lindon, Plymouth) database