Try this, i am not sure this will work
Select do.Name as HostName, mo.Caption0 as OperatingSystemName,mo.CSDVersion0 as ServicePack,mo.Version0 as Version--, do.siteCode as SiteCode
from v_GS_OPERATING_SYSTEM as mo
inner join v_FullCollectionMembership as do
on mo.ResourceID = do.ResourceID
inner join dbo.v_R_System as VRS on VRS.ResourceID = do.ResourceID
where CollectionID = 'PMS00001' and vrs.Operating_System_Name_and0 like '%Workstation%'
order by OperatingSystemName