How expressive can I get with a PowerShell Expression in Format-Table? -

-

i have following script outputs color coded folder hierarchy of user's exchange mailbox. output line in red if it's on threshold (20 mb in case) , gray if not.

#get folder size breakdown table color coding get-mailbox $username | get-mailboxfolderstatistics | ft @{         name="name"         expression=         {             $prefix=""             foreach($c in $_.folderpath.tochararray())             {                 if($c -eq '/'){$prefix+='-'}             }             if($_.foldersize -gt 20mb)             {                 $host.ui.rawui.foregroundcolor = "red"             } else             {                  $host.ui.rawui.foregroundcolor = "gray"             }             $prefix + $_.name         }     },     foldersize,     folderandsubfoldersize

there few problems script.

if last folder processed larger 20 mb, console text remains red after runs. script assumes original console text gray. if it's not gray, i've changed user's console text. both of these easy resolve if you're not in context of format-table expression, can't life of me figure out if it's possible resolve these issues in particular case. here's gist of i've tried doesn't work. (in reality i've tried 20 different variations).

get-mailbox $username | get-mailboxfolderstatistics | ft @{         name="name"         expression=         {             $prefix=""             $originalcolor = $host.ui.rawui.foregroundcolor             foreach($c in $_.folderpath.tochararray())             {                 if($c -eq '/'){$prefix+='-'}             }             if($_.foldersize -gt 20mb)             {                 $host.ui.rawui.foregroundcolor = "red"             }             $prefix + $_.name             $host.ui.rawui.foregroundcolor = $originalcolor         }     },     foldersize,     folderandsubfoldersize

note: purpose of compress down one-liner. know can store variable before start pipeline , restore color after pipeline finished, takes fun/aggravation out of it. i'm more curious whether or not can accomplish without altering basic structure of pipeline.

i don't think possible. essentially, every time format-table reads expression name foreground color change. format-table doesn't write out value expression immediately, can't reset color in expression.

i think you're going have wrap pipeline:

$originalcolor = $host.ui.rawui.foregroundcolor  get-mailbox $username | get-mailboxfolderstatistics | ft @{         name="name"         expression=         {             $prefix = " " * (($_.folderpath -split '/').length)             $host.ui.rawui.foregroundcolor = if($_.foldersize -gt 20mb) { "red" } else { $originalcolor }             $prefix + $_.name         }     },     foldersize,     folderandsubfoldersize  $host.ui.rawui.foregroundcolor = $originalcolor

another option write own formatting code finds maximum size of each column uses write-host write things out:

$stats = get-mailbox $username |     get-mailboxfolderstatistics |  $namemaxwidth = 0 $sizemaxwidth = 0 $subfoldersizemaxwidth = 0 $stats | foreach-object {      if( $_.name.length -gt $namemaxwidth )     {         $namemaxwidth = $_.name.length + (($_.folderpath -split '/').length - 1)     }      $sizewidth = $_.foldersize.tostring().length     if( $sizewidth -gt $sizemaxwidth )     {         $sizemaxwidth = $sizewidth     }      $subsizewidth = $_.folderandsubfoldersize.tostring().length     if( $subsizewidth -gt $subfoldersizemaxwidth )     {         $subfoldersizemaxwidth = $subsizewidth     } }  $stats | foreach-object {     $colorparam = @{ }     if( $_.foldersize -gt 20mb )     {         $colorparam.foregroundcolor = 'red'     }      $prefix = ' ' * (($_.folderpath -split '/').length - 1)     write-host ("{0}{1,$namemaxwidth}" -f $prefix,$_.name) -nonewline @colorparam     write-host "  " -nonewline     write-host ("{0,-$sizemaxwidth}" -f $_.foldersize) -nonewline     write-host "  " -nonewline     write-host ("{0,-$subfoldersizemaxwidth}" -f $_.folderandsubfoldersize) }

Comments

Post a Comment

Popular posts from this blog

django - How can I change user group without delete record -

-
on website user have 1 group. , user can change group. it's made user.groups.clear() and user.groups.add(new_group) but it's not efficient, because there 2 sql query: delete, insert. how can change group update query? user , group related each other using manytomanyfield . means intersection table exists relating both entities, , if don't specify model map (using through attribute) django creates 1 you. looking @ sources django.contrib.auth.models see that's case. fortunatly, can access intermediary model using through attribute of manager (in case, user.groups.through ). can use regular model. example: >>> alice = user.objects.create_user('alice', 'alice@example.com', 'alicepw') >>> employee = group.objects.create(name='employee') >>> manager = group.objects.create(name='manager') >>> alice.groups.add(employee) >>> alice.groups.all() [<group: employee...
Read more

java - Need to add SOAP security token -

-
i need set custom soap header attribute on jax-ws generated webservice client. case webservice calls must go through proxy server requiring specific token (recieved web request header) present in soap request header. e.g.: 1 carserviceservice service = null; 2 service = new carserviceservice(new url(url), new qname(qname); 3 carserviceendpoint port = service.getcarserviceport(); it seems in line 3 wsdl retrieved , call fails due missing security token. 1 point direction on how done? a detailed example has been mentioned here: creating , deploying jax-ws web service on tomcat 6 this article shows how create , use security token .
Read more

java - EclipseLink JPA Object is not a known entity type -

-
i have strange problem eclipselink , object want persist. have 1 object (keypointlistimpl) stores object keypointimpl in list. persisting keypointimpl objects works great if try persist keypointlistimpl object java.lang.illegalargumentexception says object keypointimpl isn't known entity type. here keypointimpl code: @entity @table(name="keypoints") public class keypointimpl implements keypoint { @id @generatedvalue(strategy = generationtype.identity) private int id; @enumerated(enumtype.string) private detectortype keypointtype; private float x; private float y; private float size; private float angle; private float response; private int octave; private int classid; ... } here keypointlistimpl code: @entity @table(name="keypointlists") public class keypointlistimpl implements keypointlist { @id @generatedvalue(strategy = generationtype.identity) private int id; @onetoone(cascade={ca...
Read more