Tag: OU

List of PCs by OU

select R .Name0 as ‘PC’, right(OU.System_OU_Name0, CHARINDEX(‘/’,reverse(Max(OU.System_OU_Name0)))-1) as ‘OU’ from dbo .v_R_System R left outer join dbo.v_RA_System_SystemOUName OU on R.ResourceID = OU.ResourceID Group by R .Name0, OU .System_OU_Name0 Order by R .Name0