Output constant text in Format-Table column 1

[Frink]

Hallo,

I want to output the same text in every column in a format table, i.e.

Get-EventLog -LogName System -Newest 3 | Format-Table -Property @{Label="MyLabel";Expression="MyMsg"}, Message -Autosize

gives

MyLabel Message                                                                        
------- -------                                                                        
        The Multimedia Class Scheduler service entered the stopped state.              
        The WinHTTP Web Proxy Auto-Discovery Service service entered the stopped state.
        The Multimedia Class Scheduler service entered the running state.

but I want

MyLabel Message                                                                        
------- -------                                                                        
MyMsg   The Multimedia Class Scheduler service entered the stopped state.              
MyMsg   The WinHTTP Web Proxy Auto-Discovery Service service entered the stopped state.
MyMsg   The Multimedia Class Scheduler service entered the running state.

Any ideas? I've looked at FormatString but can't find a way to specifiy literal text, only "N3" etc.

TIA,

- Frink

 

[crobin1]

The item for Expression has to be surrounded by braces, even if it's just a string. Your code should read:

@{Label="MyLabel";Expression={"MyMsg"}}

 

[Frink]

Brilliant. I was stuck on that one. Can you recommend a good resource for Powershell Syntax? The websites (except Tek-Tips, of cource) all seem to have the same noddy examples. It'd be handy to have a complete language reference, with examples, to complement the Get-Help stuff.

Thanks again,

- Frink

 

[crobin1]

See if any of these help

Bruce Payette's book "PowerShell in Action"
Lee Holmes' book "Windows PowerShell Cookbook"
SAPIEN Technologies' Primal Tools free tools:

http://www.primaltools.com/downloads/communitytools/

Microsoft's resources, start at:

http://www.microsoft.com/powershell

Jonathan Medd's "One Cmdlet at a Time" series of blog posts:

http://www.jonathanmedd.net/