Change Capacity0/1048576 AS 'Capacity (MB)', to Capacity0 AS 'Capacity (MB)',
From: [email protected] [mailto:[email protected]] On Behalf Of Radu Bogdan Sent: Tuesday, March 10, 2015 5:58 AM To: [email protected] Subject: Re: [mssms] Report RAM information of your systems with SCCM Okay so I figure it out. I change “v_GS_PHYSICAL_MEMORY_LOCATION” to “v_GS_PHYSICAL_MEMORY” and now it works but...the Capacity MB column is 0 ( zero ). Any ideas ? From: Radu Bogdan<mailto:[email protected]> Sent: Tuesday, March 10, 2015 12:12 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] Report RAM information of your systems with SCCM Hello, I`m trying to build a custom report from SCCM 2012 R2, with information about physical memory for desktops and laptops. First I add this to the configuration.MOF file: //* Physical memory location inventory. [ SMS_Report(TRUE), SMS_Group_Name("Physical Memory Location"), SMS_Class_ID("Microsoft|PHYSICAL_MEMORY_LOCATION|1.0") ] Class Win32_PhysicalMemory: SMS_Class_Template { [key, SMS_Report(TRUE)] uint64 Capacity; [key, SMS_Report(TRUE)] string Description; [key, SMS_Report(TRUE)] string DeviceLocator; [key, SMS_Report(TRUE)] string Manufacturer; [key, SMS_Report(TRUE)] uint16 MemoryType; [key, SMS_Report(TRUE)] string PartNumber; [key, SMS_Report(TRUE)] string SerialNumber; [key, SMS_Report(TRUE)] uint32 PositionInRow; [key, SMS_Report(TRUE)] uint32 Speed; }; Then I try to build the following report using this query: SELECT v_GS_SYSTEM.Name0 AS 'Computer Name', Capacity0/1048576 AS 'Capacity (MB)', Description0 AS 'Description', DeviceLocator0 AS 'Device Locator', Manufacturer0 AS 'Manufacturer', PartNumber0 AS 'Part Number', SerialNumber0 AS 'Serial Number', MemoryType0 AS 'Memory Type', PositionInRow0 AS 'Position In Row', Speed0 AS 'Speed (ns)' FROM v_GS_PHYSICAL_MEMORY_LOCATION JOIN v_GS_SYSTEM ON v_GS_SYSTEM.ResourceID = v_GS_PHYSICAL_MEMORY_LOCATION.ResourceID ORDER BY v_GS_SYSTEM.Name0 Unfortunately after I run it, I receive this error: [image] Any idea what am I doing wrong here ? Thank you.
