SCCM Report ile WMI Memory Slot Query

Memory bilgilerini SCCM Report ile almak isteyenler için bir kaç örnek:

 

1.Query Toplam bilgi

select sys.netbios_name0, mem.banklabel0 [Bank Label], mem.capacity0 [Capacity in MB],
MEM.FormFactor0 [Form Factor],
MEM.memorytype0 [Memory Type],
MEM.tag0 [TAG],HDR.Manufacturer0 [manufacturer],
HDR.Model0 [MODEL Label] from v_gs_physical_memory as MEM
inner join v_r_system as SYS on SYS.resourceid=MEM.resourceid
inner join v_gs_computer_system as HDR on SYS.resourceid=HDR.resourceid order by sys.netbios_name0

 

2. Query kaç Slot ve PC ID’si var

select sys.netbios_name0, MEMA.MemoryDevices0 [Total Number of Memory Slots], SYS.resourceid from
v_gs_physical_memory_array as MEMA
inner join v_r_system as SYS on SYS.resourceid=MEMA.resourceid

 

3. Query kaç boş slot var

select sys.netbios_name0, mema.memoryDevices0 - Count(mem.tag0) [Number of Free Slots available] from
v_gs_physical_memory as MEM
inner join v_r_system as SYS on SYS.resourceid=MEM.resourceid
inner join v_gs_physical_memory_array as MEMA on sys.resourceid=mema.resourceid
group by mema.memorydevices0, sys.netbios_name0

 

4. Query ne kadar slot ve ne kadar boş slot var

select sys.netbios_name0 as Hostname, MEMA.MemoryDevices0 [Total Number of Memory Slots],
mema.memoryDevices0 - Count(mem.tag0) [Number of Free Slots available] from
v_gs_physical_memory as MEM
inner join v_r_system as SYS on SYS.resourceid=MEM.resourceid
inner join v_gs_physical_memory_array as MEMA on sys.resourceid=mema.resourceid
group by mema.memorydevices0, sys.netbios_name0

 

Source: https://www.mycloud-tr.com/

İsmail Şen