Serial Posted March 5, 2013 Report post Posted March 5, 2013 I am trying to query the computer name and user's department info using one query. If possible, let me know. Thanks Quote Share this post Link to post Share on other sites More sharing options...
0 kvineets Posted March 5, 2013 Report post Posted March 5, 2013 Select Distinct CS.Name0 ‘Machine Name’, CS.UserName0 ‘User Name’, RU.Full_User_Name0 ‘Full Name’, UOU.User_OU_Name0 ‘Users OU’, RA.IP_Subnets0 ‘Subnet’ From v_Gs_Computer_System CS Join v_RA_System_IPSubnets RA on RA.ResourceID = CS.ResourceID Join v_R_User RU on RU.Unique_User_Name0 = CS.UserName0 Join v_RA_User_UserOUName UOU on UOU.ResourceID = RU.ResourceID Where UOU.User_OU_Name0 = ‘DomainName.COM/OuName’ Order by CS.Name0, CS.Username0, RU.Full_User_Name0, RA.IP_Subnets0 IP subnet part is an additional info here Quote Share this post Link to post Share on other sites More sharing options...
0 Serial Posted March 5, 2013 Report post Posted March 5, 2013 Thanks Much! Quote Share this post Link to post Share on other sites More sharing options...
I am trying to query the computer name and user's department info using one query. If possible, let me know. Thanks
Share this post
Link to post
Share on other sites