by Sirch019
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)
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