Forum Discussion

ewwwl's avatar
2 years ago

Any way to pull historical SDT report?

Hi all Guru here. 

Is there any report that can pull all historical SDT with Notes in report?
I am able to pull alerts that with SDT but I can’t preview all historical SDT for all my resource device at once. 

  • I don’t think there is a report, but there are some “historysdts” API calls like /device/groups/{id}/historysdts you can pull that data from. I haven’t used them myself before, but it is what the portal itself uses to report that.

  • Unfortunately, it doesn’t seem that there is sufficient information on the various “historysdts” to determine which DataSource(s) it applied to, so there is no way of knowing for sure whether a device etc. had an SDT in place for a given DataSource in the past.

    There is a missing GET endpoint:

    • /historysdts/{id}

    Although there is a GET endpoint:

    • /sdt/sdts/{id}

    ...it refused to accept a historic SDT ID (which is in a different form to the SDT id)

  • Hey Guru, in the portal SDTs are only indicated and included in Alert reporting while the SDT is still active. Mike and Stuart have given some excellent recommendations here where you may find historical SDT data via API, but if you’re interested in seeing such a report built-in to the product then I would recommend submitting Feedback to our product team directly to request this.

    You can find the option to submit Feedback within the support menu in your LogicMonitor portal along with the options to open a support ticket or chat- https://www.logicmonitor.com/support/about-logicmonitor/customer-support/get-support-resources#contacting

  • Anonymous's avatar
    Anonymous

    Best bet would be one/some/all of these endpoints in the API:

    • /device/devices/{id}/historysdts
    • /device/devices/{deviceId}/devicedatasources/{hdsId}/instances/{id}/historysdts
    • /device/groups/{id}/historysdts
    • /device/devices/{deviceId}/devicedatasources/{id}/historysdts
    • /website/websites/{id}/historysdts

    There’s no way that I know of to get this in a report without resorting to the API.

  • I don’t think there is a report, but there are some “historysdts” API calls like /device/groups/{id}/historysdts you can pull that data from. I haven’t used them myself before, but it is what the portal itself uses to report that.