Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How to see complete output of command on EMS ?

Posted on 2016-09-08
6
Medium Priority
?
57 Views
Last Modified: 2016-10-04
I issued Get-MailboxPermission userid | ft
and got truncated columns displayed on the screen as follows:

Identity                         User                                  AccessRights            IsInherited Deny
--------                             ----                                     ------------                      -----------      ----
marketresearch.co... NT AUTHORITY\SELF    {FullAccess, Sen...        False          False
marketresearch.co... MARKETRESEARCH\ja... {FullAccess}                False          False
marketresearch.co... MARKETRESEARCH\cr... {FullAccess, Del...      False          False
marketresearch.co... MARKETRESEARCH\pwang {FullAccess, Del... False         False
marketresearch.co... MARKETRESEARCH\SH... {ReadPermission}    True          False
marketresearch.co... MARKETRESEARCH\Ex... {FullAccess}                True         True
marketresearch.co... MARKETRESEARCH\Do... {FullAccess}                True        True

So I thought I can pipe the output to a file in a hope to see the complete columns. Unfortunately the piped file is in the exactly same content as on the screen. Can you tell me how to see the complete content?
0
Comment
Question by:Castlewood
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 40

Expert Comment

by:Subsun
ID: 41789852
You can try..

Get-MailboxPermission userid | FL

Or

Get-MailboxPermission userid | Export-csv c:\report.csv -nti
0
 
LVL 71

Accepted Solution

by:
Qlemo earned 1000 total points (awarded by participants)
ID: 41789857
For screen output you can (always) try ft -auto to auto-adjust column widths. That improves results, but is no complete solution where the screen width is just too low. It should work here, however.

You should never pipe ft output into a file, unless for displaying purposes. There is a lot of formatting going on in the background, making results usually useless for files. As said, it is thought to be used on screen only.

You can also use | Out-GridView to get a GUI table display.
0
 
LVL 40

Assisted Solution

by:Subsun
Subsun earned 500 total points (awarded by participants)
ID: 41790007
Also you can also export  selective properties..
Example, to export just user names and AccessRights..
Get-MailboxPermission userid | Select User,{$_.AccessRights} | Export-csv c:\report.csv -nti

Open in new window

0
Looking for the Wi-Fi vendor that's right for you?

We know how difficult it can be to evaluate Wi-Fi vendors, so we created this helpful Wi-Fi Buyer's Guide to help you find the Wi-Fi vendor that's right for your business! Download the guide and get started on our checklist today!

 
LVL 14

Assisted Solution

by:Kaffiend
Kaffiend earned 500 total points (awarded by participants)
ID: 41790257
Get-MailboxPermission userid | ft -autosize | out-string -width 250 > c:\output.csv


(As QLemo said,) ft stops the shell from truncating fields
out-string - the default shell contains only 80 columns so in case the output is over 80 characters total per line, we need to up the limit (the number 250 is arbitrary, you can use whatever value works)
0
 

Author Comment

by:Castlewood
ID: 41800455
Thank you.
0
 
LVL 40

Expert Comment

by:Subsun
ID: 41827704
All the options provided by experts will help to view data from truncated columns.
0

Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Want to know how to use Exchange Server Eseutil command? Go through this article as it gives you the know-how.
Here in this article, you will get a step by step guidance on how to restore an Exchange database to a recovery database. Get a brief on Recovery Database and how it can be used to restore Exchange database in this section!
To show how to generate a certificate request in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.:  First we need to log into the Exchange Admin Center. Navigate to the Servers >> Certificates…
This video discusses moving either the default database or any database to a new volume.
Suggested Courses

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question