To obtain a report from LM of datasources and how many devices are using those datasources.

Do we have a way to obtain a report from LM of datasources and how many devices are using those datasources, like datasources and AppliedTo Combined

Arjuna

Posted 4 years ago·Last reply 4 years ago

9 comments

LM User

·4 years ago

On 12/22/2021 at 7:43 AM, asims@cspire.com said:

used add_device_group_with_http_info() then I could access the headers

AFAIK, this is the most graceful way.

Adam_sims

·4 years ago

On 12/17/2021 at 10:53 AM, Stuart Weenig said:

This would need logic to handle portals with more than 1000 devices in it since the first api call only gets the first 1000 devices. The subsequent calls would also need to take into consideration rate limiting and probably introduce some throttling.

@Arjuna You might be able to use the module mentioned in this thread

/topic/1581-datasources_list-propertysource/

Then you could run an inventory report and add that property to the report.

Hijacking the thread a bit...
@Stuart WeenigDo you have an example on how to access the return headers when using the SDK? I've been tinkering with it and have hit the rate limit a few times but couldn't figure out how to get the headers using the base functions. I ended up calling the subfunctions in each class that returns the tuple object instead of the actual object class, but I feel like there's a better way. For instance, instead of using add_device_group() I used add_device_group_with_http_info() then I could access the headers.

mnagel

·4 years ago

1 hour ago, Stuart Weenig said:

This would need logic to handle portals with more than 1000 devices in it since the first api call only gets the first 1000 devices. The subsequent calls would also need to take into consideration rate limiting and probably introduce some throttling.

I never really think about that since we built in paging support in our module from the beginning. I have seen some of the LM modules also use hardcoded page sizes and it makes me sad. Still waiting for library support within the module system...

LM User

·4 years ago

/topic/1964-accessing-the-logicmonitor-rest-api-with-postman-and-lmv1-api-token-authentication/

https://www.logicmonitor.com/swagger-ui-master/dist/

https://www.logicmonitor.com/support/rest-api-developers-guide/overview/using-logicmonitors-rest-api

There's also a course in the training portal about the API: https://logicmonitor.skilljar.com/api-course. (You need to already have an active session in Skilljar for this link to take you directly there. To get an active session, log into your portal and click the "Training" link in the top right corner. Then the link will work.)

Arjuna

OP4 years ago

1 hour ago, mnagel said:

I would use the API to walk the list of devices, then scan devicedatasources for each device and tabulate the results. AFAIK there is no builtin report for this.

Can you please direct me to helpful API document and Articles!

LM User

·4 years ago

This would need logic to handle portals with more than 1000 devices in it since the first api call only gets the first 1000 devices. The subsequent calls would also need to take into consideration rate limiting and probably introduce some throttling.

LM User

·4 years ago

Just realized i left an errant print statement in there. Fixed.

LM User

·4 years ago

Same. Although I used the SDK (references my custom lm library)

<span class="kwd">from</span><span class="pln"> lm </span><span class="kwd">import</span><span class="pln"> lm
</span><span class="kwd">from</span><span class="pln"> pprint </span><span class="kwd">import</span><span class="pln"> pprint
devices </span><span class="pun">=</span><span class="pln"> lm</span><span class="pun">.</span><span class="pln">get_device_list</span><span class="pun">(</span><span class="pln">size</span><span class="pun">=</span><span class="lit">1000</span><span class="pun">).</span><span class="pln">to_dict</span><span class="pun">()[</span><span class="str">'items'</span><span class="pun">]</span><span class="pln">
result </span><span class="pun">=</span><span class="pln"> </span><span class="pun">{}</span><span class="pln">
</span><span class="kwd">for</span><span class="pln"> d </span><span class="kwd">in</span><span class="pln"> devices</span><span class="pun">:</span><span class="pln">
    datasources </span><span class="pun">=</span><span class="pln"> lm</span><span class="pun">.</span><span class="pln">get_device_datasource_list</span><span class="pun">(</span><span class="pln">d</span><span class="pun">[</span><span class="str">'id'</span><span class="pun">]).</span><span class="pln">to_dict</span><span class="pun">()[</span><span class="str">'items'</span><span class="pun">]</span><span class="pln">
    </span><span class="kwd">for</span><span class="pln"> ds </span><span class="kwd">in</span><span class="pln"> datasources</span><span class="pun">:</span><span class="pln">
        </span><span class="com"># print(f"{d['display_name']}: {ds['data_source_display_name']} ({ds['instance_number']})")</span><span class="pln">
        </span><span class="kwd">if</span><span class="pln"> d</span><span class="pun">[</span><span class="str">'display_name'</span><span class="pun">]</span><span class="pln"> </span><span class="kwd">in</span><span class="pln"> result</span><span class="pun">:</span><span class="pln">
            result</span><span class="pun">[</span><span class="pln">d</span><span class="pun">[</span><span class="str">'display_name'</span><span class="pun">]]</span><span class="pln"> </span><span class="pun">+=</span><span class="pln"> ds</span><span class="pun">[</span><span class="str">'instance_number'</span><span class="pun">]</span><span class="pln">
        </span><span class="kwd">else</span><span class="pun">:</span><span class="pln">
            result</span><span class="pun">[</span><span class="pln">d</span><span class="pun">[</span><span class="str">'display_name'</span><span class="pun">]]</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> ds</span><span class="pun">[</span><span class="str">'instance_number'</span><span class="pun">]</span><span class="pln">
</span><span class="kwd">for</span><span class="pln"> k</span><span class="pun">,</span><span class="pln">v </span><span class="kwd">in</span><span class="pln"> result</span><span class="pun">.</span><span class="pln">items</span><span class="pun">():</span><span class="pln">
    </span><span class="kwd">print</span><span class="pun">(</span><span class="pln">f</span><span class="str">"{k}: {v}"</span><span class="pun">)</span>

mnagel

·4 years ago

I would use the API to walk the list of devices, then scan devicedatasources for each device and tabulate the results. AFAIK there is no builtin report for this.

1	SUYASH GAIKWAD
2	NA Nazmeen Ali
3	DK Deepak Kumar
4	PG Phillip Green
5	SS Sean Staats
6	AH Arno haverlach