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**
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)
thanks for your help.


Asked by Eduardo Pivaral
(139 rep)
Sep 28, 2017, 05:21 PM
Last activity: May 13, 2020, 05:21 PM
Last activity: May 13, 2020, 05:21 PM