Solved

Output Powershell to Text File problem

Posted on 2011-09-09
10
910 Views
Last Modified: 2012-05-12
I need to output the following to a text file so that we can review it:


get-recipient -OrganizationalUnit "domain.com/users" | get-Logonstatistics | fl username, name, clientname, clientmode

I've tried >> c:\text.txt, and a couple of other things but it's failing.

I'm just trying to find out who is this location is using cached mode and who isn't.

So, how do I output, and why isn't >> working?
0
Comment
Question by:ddotson
[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
  • 4
  • 2
  • 2
  • +2
10 Comments
 
LVL 2

Expert Comment

by:gazm81
ID: 36514417
you can try export csv with a select object
get-recipient -OrganizationalUnit "domain.com/users" |
  get-Logonstatistics |
  select-object username, name, clientname, clientmode |
  export-csv c:\file.csv

Open in new window

0
 

Author Comment

by:ddotson
ID: 36514425
I tried that and got this error:

Get-LogonStatistics : Cannot bind argument to parameter 'Database' because it is null.
0
 
LVL 8

Expert Comment

by:nwtechdesk
ID: 36514528
Modern OS systems do not like anything writing to the root of the C: drive.  Did you try sending the file to a subdirectory?
0
Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 

Author Comment

by:ddotson
ID: 36514531
no, but I've never had a problem sending output to the root with powershell in the past.
0
 
LVL 2

Expert Comment

by:gazm81
ID: 36514619
Sorry I thought the question was in relation to exporting the data to file.
I hadn't actually analysed the get-logon...
Has that command worked previously?
0
 

Author Comment

by:ddotson
ID: 36514625
The command works great until I try to save the output to a file.
0
 
LVL 49

Expert Comment

by:Akhater
ID: 36515831
get-recipient -OrganizationalUnit "domain.com/users" | get-Logonstatistics | select-object username, name, clientname, clientmode | Export-csv c:\file.txt
0
 
LVL 71

Expert Comment

by:Chris Dent
ID: 36518648
This error:

Get-LogonStatistics : Cannot bind argument to parameter 'Database' because it is null.

Is not caused by your attempts to get it to go out to a file. Is that the only error you ever get?

Chris
0
 
LVL 49

Accepted Solution

by:
Akhater earned 250 total points
ID: 36518713
A correction to my last post

get-mailbox -OrganizationalUnit "domain.com/users" | get-Logonstatistics | select-object username, name, clientname, clientmode | Export-csv c:\file.txt
0
 

Author Comment

by:ddotson
ID: 36523833
This last one worked!  Thanks for the help!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article explains how to install and use the NTBackup utility that comes with Windows Server.
In previous parts of this Nano Server deployment series, we learned how to create, deploy and configure Nano Server as a Hyper-V host. In this part, we will look for a clustering option. We will create a Hyper-V cluster of 3 Nano Server host nodes w…
In this video we show how to create a Distribution Group 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 Recipients >>…
In this video we show how to create an Address List 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 Organization >> Ad…

733 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