Depends on which username you’re wanting. If you’re wanting the logged on user at hardware inventory runtime, you can just add the column “User_Name0”. If you’re properly capturing logon duration information from the security event logs for user device affinity purposes, you can join v_GS_System_Console_Usage_Maxgroup.TopConsoleUser0 to include the top console user. ex:
SELECT v_GS_SYSTEM.Name0 AS 'Computer Name', Capacity0 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)', TopConsoleUser0 AS 'Username' FROM v_GS_PHYSICAL_MEMORY JOIN v_GS_SYSTEM ON v_GS_SYSTEM.ResourceID = v_GS_PHYSICAL_MEMORY.ResourceID JOIN v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP on v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP.ResourceID = v_GS_System.ResourceID ORDER BY v_GS_SYSTEM.Name0 From: [email protected] [mailto:[email protected]] On Behalf Of Radu Bogdan Sent: Tuesday, March 10, 2015 9:28 AM To: [email protected] Subject: Re: [mssms] Report RAM information of your systems with SCCM Hello Russ, Yes ! you are correct, I`ve missed that, thank you. And if I want to also add the user name into this report ? Cheers. From: Russ Rimmerman<mailto:[email protected]> Sent: Tuesday, March 10, 2015 3:55 PM To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] Report RAM information of your systems with SCCM Change Capacity0/1048576 AS 'Capacity (MB)', to Capacity0 AS 'Capacity (MB)', From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Radu Bogdan Sent: Tuesday, March 10, 2015 5:58 AM To: [email protected]<mailto:[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.
