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],
MAX(dbo.v_GS_X86_PC_MEMORY.TotalPhysicalMemory0) AS [Physical Memory (KBytes)],
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,
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.
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.