Go to All Forums

SQL Log File size

Hi, SQL Log file size can be queried using API? If yes, is there an example.

From this link: www.site24x7.com/help/server-metrics/sql-server-monitor.html

It has this details, can query those logs via API?

Log File Size (GB) The cumulative size of all the log files in the database
Log File Used Size (GB) The cumulative used size of all the log files in the database

Thanks for any ideas and help.

Like (2) Reply
Replies (1)

Re: SQL Log File size

Hi,

Yes, you can get the metrics 'log file size' and 'log file used size' using the below APIs:

Log File Size (GB)

   https://www.site24x7.com/api/reports/performance/{{monitorid}}?child_id=0&granularity=3&period=5&report_attribute=LOGFILESIZE

Log File Used Size (GB)

   https://www.site24x7.com/api/reports/performance/{{monitorid}}?child_id=0&granularity=3&period=5&report_attribute=LOGFILEUSEDSIZE

Note: To get monitor ID of that respective monitor, please refer our API documentation.

Thanks!

 

 

 

Like (0) Reply

Was this post helpful?