get-wmiobject sql join in powershell - trying to find physical memory vs. virtual memory of remote s

Posted by Willy on Stack Overflow See other posts from Stack Overflow or by Willy
Published on 2010-05-12T04:26:31Z Indexed on 2010/05/12 7:14 UTC
Read the original article Hit count: 205

Filed under:

powershell

|

wmi

|

wmi-query

|

sql

get-wmiobject -query "Select TotalPhysicalMemory from Win32_LogicalMemoryConfiguration" -computer COMPUTERNAME >>output.csv

get-wmiobject -query "Select TotalPageFileSpace from Win32_LogicalMemoryConfiguration" -computer COMPUTERNAME >>output.csv

I am trying to complete this script with an output as such:

Computer        Physical Memory      Virtual Memory
server1         4096mb               8000mb
server2         2048mb               4000mb

© Stack Overflow or respective owner

Related posts about powershell

In Powershell on Windows7, how do I automatically set aliases (or run scripts) when powershell loads

as seen on Super User - Search for 'Super User'
I have created a powershell cmdlet and assigned it to an Alias. How do I do this automatically every time powershell launches? (i.e. so I don't have to re-assign the alias every time) >>> More
How to Load commands into your powershell profile to run on starting powershell

as seen on Server Fault - Search for 'Server Fault'
Hi, I have found a way to load exchange 2010 powershell into powershell running on a windows xp workstation, however there are a few commands that need to run. I was wondering how I could load them into a profile somehow. These are the commands that I need to run before I can do any of the exchange… >>> More
C#, Powershell - Microsoft.Exchange.Management.PowerShell.Admin

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm having troubles using the Microsoft.Exchange.Management.PowerShell.Admin on a server. The server is not the one running Exchange 2007, it's a remote server (in the same zone). I can't figure out how to add the Snapin for Powershell - Microsoft.Exchange.Management.PowerShell.Admin. Is it possible… >>> More
PowerShell Script to Create PowerShell Profile

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Utilizing a PowerShell profile can help any PowerShell user save time getting up and running with their work. For those unfamiliar a PowerShell profile is a file you can store any PowerShell commands that you want to run when you fire up a PowerShell console (or ISE.) In my typical profiles (example… >>> More
Download Free PowerShell Quick Reference Guides from Microsoft

as seen on How to geek - Search for 'How to geek'
Are you just getting started with learning PowerShell or tired of looking up less frequently used commands? Then this terrific set of PowerShell quick reference guides from Microsoft is just what you need! The first guide focuses on commonly-used Windows PowerShell commands and is available in a single… >>> More

Related posts about wmi

XP machines on Domain not reporting WMI Data in a 2003 Server Environment

as seen on Server Fault - Search for 'Server Fault'
I am running into a very quirky issue and I hope someone out there can help. We use a monitoring program for several networks we oversee that is WMI data dependent for a great deal of it's functionality. The Windows 2000 Professional workstations, as well as the 2003 servers in our network report… >>> More
Setting WMI permissions remotely

as seen on Server Fault - Search for 'Server Fault'
I've developed a tool that does a simple retrieval of registered services and installed applications from remote Windows Server 2003 servers via WMI. My problem is, the tool needs to be run on an ad hoc basis by a user who is not an administrator of those servers. I've created a domain user (which… >>> More
WMI Security error TF255437 when installing TFS 2010 RC

as seen on Stack Overflow - Search for 'Stack Overflow'
Does anyone know the resolution to the following error. In this scenario, TFS will be using a local report server instance which points uses a separate SQL Server database engine instance. An error occurred while querying the Windows Management Instrumentation (WMI) interface on the following … >>> More
Associate mount points with local disks in VBscript / WMI

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a VBscript that outputs various config items about a system. Both hardware and software. I can output disks and their associated partitions. I can output mount points. I do not seem to be able to associate a mount point with a local disk (where it actually is a local disk). I need to be able… >>> More
WMI Windows 7 vs Server 2003 R2 Problem

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the below procedures running one after the Other. It seems to work fine in Windows 7 but fails on Windows Server 2003 R2. Any Ideas Why? Am i suppose to be disposing For Cpu ManagementObjectSearcher cpuSearcher = new ManagementObjectSearcher("root\\CIMv2", "SELECT * FROM Win32_Processor"); foreach… >>> More