SCCM Report Identify machines with Lessthan 512MB RAM with the some customizations

Are you looking to identify the machines which are having lessthan 512 MB running with Office 2007 or OFfice 2003 with the operating System Installed.If so you can use the below simple SQL query into your reports.

Create a New Report and name it as ' Machines with Lessthan 512 MB RAM' as you like.In the SQL statement,click on Edit SQL statement and paste the below query.Click ok and run the report.

SELECT     dbo.v_GS_COMPUTER_SYSTEM.Name0 AS [Computer Name],
           dbo.v_GS_OPERATING_SYSTEM.Caption0 AS [Operating System],
           dbo.v_GS_OPERATING_SYSTEM.CSDVersion0 AS [Service Pack],
           dbo.v_GS_COMPUTER_SYSTEM.Model0, dbo.v_GS_PC_BIOS.Manufacturer0,
           MAX(dbo.v_GS_X86_PC_MEMORY.TotalPhysicalMemory0) AS [Physical Memory (KBytes)],
           a.DisplayName0 ,a.version0
FROM dbo.v_GS_LOGICAL_DISK INNER JOIN
     dbo.v_GS_COMPUTER_SYSTEM INNER JOIN
     dbo.v_GS_PC_BIOS ON dbo.v_GS_COMPUTER_SYSTEM.ResourceID = dbo.v_GS_PC_BIOS.ResourceID INNER JOIN
     dbo.v_GS_PROCESSOR ON dbo.v_GS_PC_BIOS.ResourceID = dbo.v_GS_PROCESSOR.ResourceID INNER JOIN
     dbo.v_GS_X86_PC_MEMORY ON dbo.v_GS_PROCESSOR.ResourceID = dbo.v_GS_X86_PC_MEMORY.ResourceID ON
     dbo.v_GS_LOGICAL_DISK.ResourceID = dbo.v_GS_X86_PC_MEMORY.ResourceID INNER JOIN
     dbo.v_GS_OPERATING_SYSTEM INNER JOIN
     dbo.v_R_System ON dbo.v_GS_OPERATING_SYSTEM.ResourceID = dbo.v_R_System.ResourceID ON
     dbo.v_GS_LOGICAL_DISK.ResourceID = dbo.v_R_System.ResourceID
INNER JOIN  v_Add_Remove_Programs a ON  dbo.v_GS_COMPUTER_SYSTEM.ResourceID=a.ResourceID
where DisplayName0 like 'Microsoft Office standard%' and
dbo.v_GS_X86_PC_MEMORY.TotalPhysicalMemory0 <= '512000'
GROUP BY dbo.v_GS_COMPUTER_SYSTEM.Name0,
dbo.v_GS_OPERATING_SYSTEM.CSDVersion0, dbo.v_GS_PC_BIOS.Manufacturer0,
dbo.v_GS_OPERATING_SYSTEM.Caption0, dbo.v_GS_COMPUTER_SYSTEM.Model0,
a.DisplayName0,
a.version0   

If there are any errors while copy & paste in the query ,you can download the attached file, remove .txt extesion and try inpoting the MOF file into the reporting node 

if you want to get more fields in report.You will see the output of the report as looks like below.

 

 

One Response to "SCCM Report Identify machines with Lessthan 512MB RAM with the some customizations"

  1. Thanks for your article. I also think laptop computers have gotten more and more popular these days, and now in many cases are the only form of computer utilized in a household. The reason being at the same time actually becoming more and more cost-effective, their working power is growing to the point where they're as highly effective as pc's through just a few in years past.

    Reply

Leave a Reply