OWSUG.ca

Query to fetch the machines from a specific OU with the Specific Machine Model

Select

R

.Name0

From

dbo

.v_R_System R join dbo.v_GS_COMPUTER_SYSTEM CS on R.ResourceID = CS.ResourceID join dbo.v_RA_System_SystemOUName OU on R.ResourceID = OU.ResourceID

Where

CS

.Model0 = 'Virtual Machine'

Group

by

R

.Name0,

CS

.Model0

Having

max(OU.System_OU_Name0) = 'GARTEK.TST/WORKSTATIONS'