SCCM查询：如何获取最新的用户登录注册（如果有）并显示PC，IP，用户，登录时间戳

I'm trying to create a SQL 2005 query to retrieve and combine records from 3 SCCM Data Views. The first view contains records of valid PC's; the second contains logon-information containing: PC-id, username, timestamp, etc; the third contains PC-id, IP-address.I'm trying to create a SQL 2005 query to retrie