Archives

SCCM Query: Windows 10 Buildnummern

Weil die meisten SCCM Reports nur bis zur dritten Buildnummer (10.0.n) gehen und die letzte Nummer fast nirgends zu bekommen ist: select v_GS_OPERATING_SYSTEM.Caption0, vSMS_R_System.BuildExt as Build, count(*) as Anzahl from vSMS_R_System inner join v_GS_OPERATING_SYSTEM on v_GS_OPERATING_SYSTEM.ResourceID = vSMS_R_System.ItemKey where v_GS_OPERATING_SYSTEM.Caption0 like ‘%Windows 10%’ group by v_GS_OPERATING_SYSTEM.Caption0,vSMS_R_System.BuildExt order by v_GS_OPERATING_SYSTEM.Caption0,vSMS_R_System.BuildExt

SCCM Query: Failed Deployment

Namen der Rechner auf denen ein Deployment fehlgeschlagen ist: select sys.Name0 from vSMS_R_System as sys inner join vSMS_ClientAdvertisementStatus as offer on sys.ItemKey=offer.ResourceID WHERE AdvertisementID = ‘XXXnnnnnn’ and LastStateName = ‘Failed’