I used to be able to run this wql querry which woudl return all the pc info and all the user info (based on last logged on user) including group memberships. (it seems to be difficult to get that information out of the web reports.
It no longer works. Any ideas? It's being run against a collection with 120 pc's in it. select SMS_R_System.*, SMS_R_User.* from SMS_R_System inner join SMS_R_User on SMS_R_User.UserName = SMS_R_System.LastLogonUserName