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:
Any idea what am I doing wrong here ?
Thank you.
