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



Reply via email to