I ran into this issue at my last place. You need to add more columns in cm12. The is a thread in MS forum about, I will try to find it. On Feb 3, 2014 8:45 AM, "Burke, John" <[email protected]> wrote:
> 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 > >
