SQL Report For Collect Specific Product With MAC And Ip address

Select distinct SYS.Netbios_Name0, SYS.User_Name0, SP.ProductName, SP.CompanyName, SP.ProductVersion ,V.MAC_Addresses0,I.ipaddress0
FROM fn_rbac_GS_SoftwareProduct(@UserSIDs)  SP
JOIN fn_rbac_R_System(@UserSIDs)  SYS on SP.ResourceID = SYS.ResourceID
INNER Join v_RA_System_MACAddresses V ON V.ResourceID=SYS.ResourceID
INNER Join dbo.v_GS_NETWORK_ADAPTER_CONFIGUR I ON I.ResourceID=SYS.ResourceID
WHERE SP.ProductName = @variable
Order by SP.ProductName, SP.ProductVersion



if any one need more Information ,kindly contact with me