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: bogdan.r...@live.com
To: ms...@lists.myitforum.com
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.
