SELECT     dbo.v_R_System.Name0 AS [Computer Name], A.System_OU_Name0
FROM         dbo.v_RA_System_SystemOUName AS A INNER JOIN
                          (SELECT     ResourceID, MAX(LEN(System_OU_Name0)) AS len
                            FROM          dbo.v_RA_System_SystemOUName
                            GROUP BY ResourceID) AS B ON A.ResourceID = B.ResourceID AND LEN(A.System_OU_Name0) = B.len INNER JOIN
                      dbo.v_R_System ON B.ResourceID = dbo.v_R_System.ResourceID         If you want just for one computer then…   SELECT     dbo.v_R_System.Name0 AS [Computer Name], A.System_OU_Name0
FROM         dbo.v_RA_System_SystemOUName AS A INNER JOIN
                          (SELECT     ResourceID, MAX(LEN(System_OU_Name0)) AS len
                            FROM          dbo.v_RA_System_SystemOUName
                            GROUP BY ResourceID) AS B ON A.ResourceID = B.ResourceID AND LEN(A.System_OU_Name0) = B.len INNER JOIN
                      dbo.v_R_System ON B.ResourceID = dbo.v_R_System.ResourceID
WHERE     (dbo.v_R_System.Name0 = ‘Computer Name’)

 

Leave a Reply

Your email address will not be published. Required fields are marked *