markmagnus

<div>
I looked in a lot of places thinking someone else might want have wanted to know where each database was. &nbsp;Although I could get the data from a powershell command by itself it is nice to be able to include this in a bigger script. &nbsp;Especially with 45 databases.
</div>


I looked in a lot of places thinking someone else might want have wanted to know where each database was.  Although I could get the data from a powershell command by itself it is nice to be able to include this in a bigger script.  Especially with 45 databases.

<div>
<div class="content wysiwyg-content">
I run the following powershell to get information about the exchange databases and the last piece about the edbfilepath shows the header but not the actual path. &nbsp;All the other items for the database work. &nbsp;No errors are generated.<br />
<br />
get-mailboxdatabase -server generic &nbsp;-status | ft identity,@{label=&quot;WS (MB)&quot;;expression={$_.Avail<wbr />ableNewMai<wbr />lboxSpace.<wbr />ToMB()}},@<wbr />{label=&quot;Si<wbr />ze (GB)&quot;;expression={$_.datab<wbr />asesize.To<wbr />GB()}},@{l<wbr />abel=&quot;Path<wbr />&quot;;expressi<wbr />on={select<wbr /> edbfilepath}}<br />
<br />
If I run get-mailboxdatabase -status | select edbfilepath it works correctly.
</div>
</div>


I run the following powershell to get information about the exchange databases and the last piece about the edbfilepath shows the header but not the actual path.  All the other items for the database work.  No errors are generated.

get-mailboxdatabase -server generic  -status | ft identity,@{label="WS (MB)";expression={$_.AvailableNewMailboxSpace.ToMB()}},@{label="Size (GB)";expression={$_.databasesize.ToGB()}},@{label="Path";expression={select edbfilepath}}

If I run get-mailboxdatabase -status | select edbfilepath it works correctly.

Powershell for exchange select edbfilepath exchange 2013

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.