SOLVEDSQL Query for windows 10 consumer edition

Status
Not open for further replies.
Jyven

Jyven

Member
5
0
1
Hello All,

I need to get list of machines with Windows 10 Consumer edition. can you provide SQL Query
Solution
cmendao
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
Gokul

Gokul

Well-Known Member
Staff member
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
cmendao

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
Solution
Status
Not open for further replies.

Forum statistics

Threads
5,051
Messages
19,713
Members
10,475
Latest member
therook711