Create Collection by Service
This should do the trick:
select * from SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SERVICE.DisplayName = "Microsoft Exchange Service Host"Scott Gill
SCCM Consultant
July 30th, 2010 1:39am