Report installed RAM on all systems

[Kevin79]

I am creating a report that shows the video card, processor, memory and hard drive size of all of my computers. I got everything working but the memory. How do I add installed memory into a SQL query?

[GarthMJ]

can you post the query that you have now?

[Kevin79]

Nevermind. I ran the query that I had then ran the SCCM report that shows installed memory and did some excel magic to combine the two.