no that one i listed used to be set for to prompt for collection. It would return all the pc info from sms_r_system and all the sms_r_User from the last logged on user.
It wasn't for 1 user or 1 pc but a collection of them. ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of elsalvoz Sent: Monday, February 03, 2014 2:26 PM To: [email protected] Subject: Re: [mssms] RE: Querry no longer works in sccm 2007 r2? http://www.techygeekshome.co.uk/2012/10/find-system-by-last-logged-on-user.html Is this the one you were referring to? select SMS_R_System.LastLogonUserName, SMS_R_System.Name, SMS_R_System.SMSAssignedSites, SMS_R_System.Client, SMS_R_System.IPAddresses, SMS_R_System.IPSubnets, SMS_R_System.MACAddresses, SMS_R_System.OperatingSystemNameandVersion, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.LastLogonUserDomain, SMS_R_System.AgentName, SMS_R_System.AgentSite, SMS_R_System.AgentTime, SMS_R_System.SNMPCommunityName, SMS_R_System.SystemRoles, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceId, SMS_R_System.ResourceNames, SMS_R_System.ResourceType, SMS_R_System.NetbiosName from SMS_R_System where SMS_R_System.LastLogonUserName = ##PRM:SMS_R_System.LastLogonUserName## - See more at: http://www.techygeekshome.co.uk/2012/10/find-system-by-last-logged-on-user.html#sthash.nCmnL9hn.dpuf On Mon, Feb 3, 2014 at 9:00 AM, Burke, John <[email protected]<mailto:[email protected]>> wrote: 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: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Dzikowski, Michael Sent: Monday, February 03, 2014 12:56 PM To: [email protected]<mailto:[email protected]> 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:[email protected]] From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Burke, John Sent: Monday, February 03, 2014 11:44 AM To: [email protected]<mailto:[email protected]> 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>>
