want to get the pc's listed out - with their ad information, os, group membership then get the user information (ad location, department, job role, plus group membership)
You think this would work better in SSRS? I think the group membership info is a bit odd when you look at it in sql.. which is why i used to use that wql. ________________________________ From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Dzikowski, Michael Sent: Monday, February 03, 2014 12:56 PM To: mssms@lists.myitforum.com Subject: [mssms] RE: Querry no longer works in sccm 2007 r2? Why not do something in SQL or SSRS? Whats the goal of the WQL? What information do you need? Michael Dzikowski Senior Systems Engineer | Ally Technical Infrastructure - Windows Hosting [cid:image002.gif@01CDF887.776259A0] From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Burke, John Sent: Monday, February 03, 2014 11:44 AM To: mssms@lists.myitforum.com Subject: [mssms] Querry no longer works in sccm 2007 r2? 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
<<inline: image001.png>>