Event 1221 in the Application log will tell you the amount of free space in
the db at the time of online defrag.  Can you use that plus filesystem info.
about disk space and the size of the database files to get what you're
looking for?  You could write a Powershell script using the Get-Eventlog
cmdlet to obtain the white space value, and the rest of it should be pretty
straightforward.

HTH,

RS

On Fri, Jul 23, 2010 at 5:01 AM, Ellis, John P. <[email protected]>wrote:

> Is it possible to obtain free disc space, EDB size, and white space from
> the command line and export it to a file?
>
> Thanks
> John
> -------------------------------------------------------------------
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
>
> This footnote also confirms that this email message has been swept by
> MIMEsweeper for the presence of computer viruses.
>
> www.clearswift.com
> **********************************************************************
>
>
>
>
>

Reply via email to