Sample Header Ad - 728x90

Disk Usage Report SSMS - query to obtain same info

1 vote
1 answer
512 views
I would like to have a query that obtains the same info as in the **Disk Usage** report, section **data/Log files autogrowth/autoshrink events** enter image description here I would like to build a custom monitoring report but i could not find where this report comes. the only thing I could find is that this info comes from: sys.fn_trace_gettable but i don't know what field or joins I must do to have the same functionality as the report above. EDIT: i need these fields, also the size of the growth (for analytical purposes) enter image description here thanks for your help.
Asked by Eduardo Pivaral (139 rep)
Sep 28, 2017, 05:21 PM
Last activity: May 13, 2020, 05:21 PM