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