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

Leave a Reply

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