It is not supported to query the tables directly, instead you should query the SQL view instead.
From: [email protected] [mailto:[email protected]] On Behalf Of Radu Bogdan Sent: Tuesday, April 26, 2016 4:28 AM To: [email protected] Subject: RE: [mssms] ConfigMgr Custom report ( add user name ) Solved it: SELECT distinct v_RA_System_ResourceNames.Resource_Names0 AS [Resource name], v_RA_System_MACAddresses.MAC_Addresses0 AS [MAC Address], v_RA_System_IPAddresses.IP_Addresses0 AS [IP Address], sy.TopConsoleUser00 FROM v_RA_System_MACAddresses INNER JOIN v_RA_System_ResourceNames ON v_RA_System_MACAddresses.ResourceID = v_RA_System_ResourceNames.ResourceID INNER JOIN v_RA_System_IPAddresses ON v_RA_System_MACAddresses.ResourceID = v_RA_System_IPAddresses.ResourceID INNER JOIN [dbo].[SYSTEM_CONSOLE_USAGE_DATA] sy on v_RA_System_MACAddresses.ResourceID= sy.MachineID Thanks. ________________________________ From: [email protected]<mailto:[email protected]> To: [email protected]<mailto:[email protected]> Subject: [mssms] ConfigMgr Custom report ( add user name ) Date: Tue, 26 Apr 2016 10:25:19 +0300 Hello, I have the following query for a report which include Computer Name, MAC Address and IP Address: SELECT v_RA_System_ResourceNames.Resource_Names0 AS [Resource name], v_RA_System_MACAddresses.MAC_Addresses0 AS [MAC Address], v_RA_System_IPAddresses.IP_Addresses0 AS [IP Address] FROM v_RA_System_MACAddresses INNER JOIN v_RA_System_ResourceNames ON v_RA_System_MACAddresses.ResourceID = v_RA_System_ResourceNames.ResourceID INNER JOIN v_RA_System_IPAddresses ON v_RA_System_MACAddresses.ResourceID = v_RA_System_IPAddresses.ResourceID It is possible to also add a user name column to this report ? Thank you. Bogdan Radu.
