<div>
techdrive, I'm happy to hear I was able to assist. &nbsp;If you found my contribution to this post valuable, please select the 'Accept Solution' link under my answer. &nbsp;Thank you.
</div>


techdrive, I'm happy to hear I was able to assist.  If you found my contribution to this post valuable, please select the 'Accept Solution' link under my answer.  Thank you.

<div>
<div class="content wysiwyg-content">
Greetings I am using Logparser which I believe is in SQL. I have the command in SQL that runs but I was needing help either directing this back to exchange powershell &nbsp;or should I get the info I need in powershell first.<br />
<br />
logparser.exe &quot;SELECT User-email,client-software<wbr />,client-so<wbr />ftware-ver<wbr />sion as Version,client-mode,client<wbr />-ip,protoc<wbr />ol from &quot;D:\logs\RCA*.LOG&quot; &nbsp;WHERE (operation='Connect') OR Client-Mode LIKE '%mode' GROUP BY User-email,client-software<wbr />,Version,c<wbr />lient-mode<wbr />,client-ip<wbr />,protocol ORDER BY User-email&quot; -i:CSV -nSkipLines:4 -o:CSV &gt;&nbsp;c:\path<br />
<br />
The info I need in powershell is foreach {get-mailbox $_ } | select primarysmtpaddress, organizationalunit <br />
<br />
Please help we are running exchange 2013 and I am sing logparser 2.2
</div>
</div>


Greetings I am using Logparser which I believe is in SQL. I have the command in SQL that runs but I was needing help either directing this back to exchange powershell  or should I get the info I need in powershell first.

logparser.exe "SELECT User-email,client-software,client-software-version as Version,client-mode,client-ip,protocol from "D:\logs\RCA*.LOG"  WHERE (operation='Connect') OR Client-Mode LIKE '%mode' GROUP BY User-email,client-software,Version,client-mode,client-ip,protocol ORDER BY User-email" -i:CSV -nSkipLines:4 -o:CSV > c:\path

The info I need in powershell is foreach {get-mailbox $_ } | select primarysmtpaddress, organizationalunit 

Please help we are running exchange 2013 and I am sing logparser 2.2

Sql into powershell

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.

Programming

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

Exchange is the server side of a collaborative application product that is part of the Microsoft Server infrastructure. Exchange's major features include email, calendaring, contacts and tasks, support for mobile and web-based access to information, and support for data storage.