Skip to content

Find-DbaDbGrowthEvent documentation unit conversion error #10170

@alevyinroc

Description

@alevyinroc

Verified issue does not already exist?

I have searched and found no existing issue

What error did you receive?

Find-DbaDbGrowthEvent states in the .OUTPUTS section of the help that Duration is reported in seconds. This is incorrect. The source data is microseconds, which is then divided by 1000 to get milliseconds.

This was added in #10072. Hat tip to Edwin Sarmiento for bringing it up on SQLSlack

Steps to Reproduce

Get-Help Find-DbaDbGrowthEvent -Full

Output:

OUTPUTS                                                                                                                 
    PSCustomObject                                                                                                      
        Returns one object per database auto-growth or auto-shrink event found in the SQL Server Default Trace. The specific events returned 
        depend on the -EventType and -FileType parameters.                                                              
                                                                                                                        
        Default display properties (via Select-DefaultView):                                                            
                                                                                                                        
        - ComputerName: The computer name where the SQL Server instance is running                                      
                                                                                                                        
        - InstanceName: The SQL Server instance name                                                                    
                                                                                                                        
        - SqlInstance: The full SQL Server instance name (computer\instance)                                            
                                                                                                                        
        - EventClass: The trace event class (92 = Data File Auto Grow, 93 = Log File Auto Grow, 94 = Data File Auto Shrink, 95 = Log File Auto 
        Shrink)                                                                                                         
                                                                                                                        
        - DatabaseName: The name of the database that experienced the growth/shrink event                               
                                                                                                                        
        - Filename: The path and name of the database file that was resized                                             
                                                                                                                        
        - Duration: The duration of the event in seconds (milliseconds converted to seconds)  

Please confirm that you are running the most recent version of dbatools

2.7.24

Other details or mentions

No response

What PowerShell host was used when producing this error

PowerShell Core (pwsh.exe)

PowerShell Host Version

Name                           Value
----                           -----
PSVersion                      7.5.4
PSEdition                      Core
GitCommitId                    7.5.4
OS                             Darwin 25.2.0 Darwin Kernel Version 25.2.0: Tue Nov 18 21:09:55 PST 2025; root:xnu-12377.61.12~1/RELEASE_ARM64_T8103
Platform                       Unix
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0…}
PSRemotingProtocolVersion      2.3
SerializationVersion           1.1.0.1
WSManStackVersion              3.0

SQL Server Edition and Build number

N/A

.NET Framework Version

N/A

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugs lifetriage requiredNew issue that has not been reviewed by maintainers

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions