SDT Report

On 4/20/2017 at 1:58 PM, pmeyer said:

I want to have a report that will give me all devices that are currently under an SDT, that will show the device name, SDT Start Date, SDT End Date, and the comments of the SDT>

Do you mean within the web GUI?  This functionality exists in the API: https://www.logicmonitor.com/support/rest-api-developers-guide/v1/sdts/get-sdts/

same here

We would also like this feature request 

On 4/14/2022 at 3:43 PM, Barb said:

We would also like this feature request 

that will show the device name, SDT Start Date, SDT End Date, and the comments of the SDT also the customer. A report that can be shown to customers. The one that comes from the api is not easily manipulated into excel from STD Output. Any suggestions on how to make this report easier to read.

This script gets pretty close, I think:

from lm import lm

devices = lm.get_device_list(size=1000).items
sdts = lm.get_sdt_list(size=1000).items

r = {}

for device in devices:
    r[device.id] = {"display_name": device.display_name, "name": device.name}
    r[device.id]["device_sdt"] = [s.to_dict() for s in [sdt for sdt in sdts if sdt.type=="DeviceSDT"] if device.id == s.device_id]
    r[device.id]["group_sdt"] = [s.to_dict() for s in [sdt for sdt in sdts if sdt.type=="DeviceGroupSDT"] if s.device_group_id in [int(i) for i in device.host_group_ids.split(',')]]

print("device_id,display_name,name,sdt_type,sdt_start_time,sdt_end_time,sdt_timezone")
for k,v in r.items():
    for ds in v['device_sdt'] + v['group_sdt']:
        print(f"{k},{v['display_name']},{v['name']},{ds['type']},{ds['start_date_time_on_local']},{ds['end_date_time_on_local']},{ds['timezone']}")

Uses my own personal library to build the Python SDK object called lm. Doesn't do pagination on the device, list, but that wouldn't be too hard to build. This also may output multiple lines for a single device, if multiple SDTs apply to the same device. Wouldn't be too complicated to flatten the list.

This is what the output looks like on mine:

device_id,display_name,name,sdt_type,sdt_start_time,sdt_end_time,sdt_timezone
58,LogicMonitor,lmstuartweenig.logicmonitor.com,DeviceGroupSDT,2022-05-02 10:25:00 CDT,2022-05-02 11:25:00 CDT,America/Chicago
62,Zoom,logicmonitor.zoom.us,DeviceGroupSDT,2022-05-02 10:25:00 CDT,2022-05-02 11:25:00 CDT,America/Chicago
78,Skilljar,status.skilljar.com,DeviceGroupSDT,2022-05-02 10:25:00 CDT,2022-05-02 11:25:00 CDT,America/Chicago
103,ConnectWise,staging.connectwisedev.com,DeviceSDT,2022-04-12 12:57:00 CDT,3022-04-12 14:57:00 CDT,America/Chicago
140,api.exchangeratesapi.io,api.exchangeratesapi.io,DeviceSDT,2022-05-06 20:00:00 CDT,2022-05-07 19:45:00 CDT,America/Chicago
140,api.exchangeratesapi.io,api.exchangeratesapi.io,DeviceSDT,2022-05-07 19:45:00 CDT,2022-05-08 19:30:00 CDT,America/Chicago
197,buttonmusic.local,buttonmusic.local,DeviceSDT,2022-03-23 10:23:00 CDT,3022-03-23 12:23:00 CDT,America/Chicago
239,boxxy.local,boxxy.local,DeviceSDT,2022-04-04 14:47:00 CDT,3022-04-04 16:47:00 CDT,America/Chicago

Hopefully I'll have some time today to repost my lmwrapper module (i had to pull it off github). 

LM Wrapper is here: 

On 5/3/2022 at 2:26 AM, Guest Stuart Weenig said:

LM Wrapper is here: 

/topic/7713-lm-wrapper-for-the-python-sdk/

 

Thank you very much, i will give this a try as soon as i can :)/emoticons/smile@2x.png 2x" title=":)" width="20" />

Confirmed this is almost there and is formatted much nicer to work with.

Thank you so much.

I'd like to be able to have something like a NOC widget on a dashboard that shows devices in SDT... not just for a specific DataSource, but at the device level and down.  NOC widget currently requires me to select the DS to match against.  Reports aren't as dynamic as we're looking for.  Use case is support seems a machine out of load balancing, needs to check quickly to see if it's supposed to be out of load balancing.  SDT workflow is part of our procedure and would allow the service desk to quickly determine whether or not they need to perform an action that can potentially break a client environment.

You can use the LM API to modify a text widget on a dashboard to display the output of the above script.