Sccm Detaylı Bilgisayar Envanter Raporu

Rapor aşağıdaki özellikleri içerir. Computer name – Ad Site- Username, OS – Service Pack  –  Marka -Model – Seri No – Bios Date – Bios Version – Kurulum Tarihi – Memory – Memory Slots –  Type(x64,86) – Pc Type – SELECT DISTINCT sys.Name0 ‘Machine’, sys.AD_Site_Name0 ‘ADSite’, CS.UserName0 ‘User Name’, CASE WHEN U.TopConsoleUser0 = ‘-1’ OR U.TopConsoleUser0 IS NULL THEN ‘N/A’ ELSE U.TopConsoleUser0 END as TopUser, REPLACE (OS.Caption0, ‘Microsoft Windows’,’Win’) OS, REPLACE (OS.CSDVersion0,’Service Pack’,’SP’) ‘Service Pack’, CS.Manufacturer0 ‘Manufacturer’, CS.Model0 Model, BIOS.SerialNumber0 ‘Serial Number’, BIOS.ReleaseDate0 as BIOSDate, BIOS.SMBIOSBIOSVersion0 as BIOSVersion, (SELECT CONVERT(DATE,sys.Creation_Date0))…

Devamını OKU