SDT Report
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>
pmeyer
Posted 9 years ago·Last reply 3 years ago
11 comments
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>
Barb Ramirez
·3 years agoAs a followup on this thread. The script was nearly perfect except i wasnt able to get the instance sdt quiet right. In the end i use postman visualize. You end up with a nice table.
this is the script in tests
var template = `
<style type="text/css">
.tftable {font-size:14px;color:#333333;width:100%;border-width: 1px;border-color: #87ceeb;border-collapse: collapse;}
.tftable th {font-size:18px;background-color:#87ceeb;border-width: 1px;padding: 8px;border-style: solid;border-color: #87ceeb;text-align:left;}
.tftable tr {background-color:#ffffff;}
.tftable td {font-size:14px;border-width: 1px;padding: 8px;border-style: solid;border-color: #87ceeb;}
.tftable tr:hover {background-color:#e0ffff;}
</style>
<table class="tftable" border="1">
<tr>
<th>DisplayName</th>
<th>GroupPath</th>
<th>Type</th>
<th>InstanceName</th>
<th>Admin</th>
<th>Timezone</th>
<th>StartDate</th>
<th>EndDate</th>
<th>Comment</th>
</tr>
{{#each response.data.items}}
<tr id=row_{{@key}} onClick="handleClick(this.id)">
<td id={{@key}}>{{deviceDisplayName}}</td>
<td>{{deviceGroupFullPath}}</td>
<td>{{type}}</td>
<td>{{dataSourceInstanceName}}</td>
<td>{{admin}}</td>
<td>{{timezone}}</td>
<td>{{startDateTimeOnLocal}}</td>
<td>{{endDateTimeOnLocal}}</td>
<td>{{comment}}</td>
</tr>
{{/each}}
</table>
`;
pm.visualizer.set(template, {
response: pm.response.json()
});
This is what the table looks like
LM User
·4 years agoYou can use the LM API to modify a text widget on a dashboard to display the output of the above script.
Cole McDonald
·4 years agoI'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.
Barb Ramirez
·4 years agoConfirmed this is almost there and is formatted much nicer to work with.
Thank you so much.
Barb Ramirez
·4 years agoThank you very much, i will give this a try as soon as i can :)/emoticons/smile@2x.png 2x" title=":)" width="20" />
LM User
·4 years agoLM Wrapper is here:
/topic/7713-lm-wrapper-for-the-python-sdk/LM User
·4 years agoThis script gets pretty close, I think:
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:
Hopefully I'll have some time today to repost my lmwrapper module (i had to pull it off github).
Barb Ramirez
·4 years agothat 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.
Barb Ramirez
·4 years agoWe would also like this feature request
krutaw
·7 years agoDo 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/
chendricks
·7 years agosame here