Forums on Intune, SCCM, and Windows 11
Welcome to the forums. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your topics and posts, as well as connect with other members through your own private inbox!
SOLVED SQL Query for windows 10 consumer edition
- Thread starter Jyven
- Start date
- Replies 4
- Views 4K
Solution
- Messages
- 321
- Solutions
- 4
- Reaction score
- 58
- Points
- 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
- Messages
- 2
- Solutions
- 1
- Reaction score
- 0
- Points
- 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
