SOLVEDSQL Query for windows 10 consumer edition
- Thread starterJyven
- Start date
Solution
- 321
- 55
- 28
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
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
cmendao
New Member
- 2
- 0
- 1
If help you
select sys.name0 [Computer Name]
from v_updateinfo ui
inner join v_UpdateComplianceStatus ucs on ucs.ci_id=ui.ci_id
join v_CICategories_All catall2 on catall2.CI_ID=UCS.CI_ID
join v_CategoryInfo catinfo2 on catall2.CategoryInstance_UniqueID = catinfo2.CategoryInstance_UniqueID and catinfo2.CategoryTypeName='UpdateClassification'
join v_R_System sys on sys.resourceid=ucs.resourceid
and ucs.status='2' -- required
--AND (ui.articleid='3012973')
AND (ui.Title like 'Feature update to Windows 10 (consumer editions), version 21H2%')
GROUP BY sys.name0
order by sys.name0
select sys.name0 [Computer Name]
from v_updateinfo ui
inner join v_UpdateComplianceStatus ucs on ucs.ci_id=ui.ci_id
join v_CICategories_All catall2 on catall2.CI_ID=UCS.CI_ID
join v_CategoryInfo catinfo2 on catall2.CategoryInstance_UniqueID = catinfo2.CategoryInstance_UniqueID and catinfo2.CategoryTypeName='UpdateClassification'
join v_R_System sys on sys.resourceid=ucs.resourceid
and ucs.status='2' -- required
--AND (ui.articleid='3012973')
AND (ui.Title like 'Feature update to Windows 10 (consumer editions), version 21H2%')
GROUP BY sys.name0
order by sys.name0
- Status
