Data Collector Devices down list export

[Uchira Amarasinghe]

Hi,

What is the possibility to export the device list by filtering devices up down status? does anyone have an idea on this



Thanks,
Uchira.

[Issac08]

You can get the device down details from on-demand report using reachability kind of metrics

[Jeffrey Pinard]

In addition to a Reachability report, you could make a rest call to DA (depending on how many are down and/or mgmt loss - adjust the following depending on needs).

POST http://DA:8581/rest/devices/filtered
Body:
<FilterSelect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="filter.xsd">
<Filter>
 <Or>
   <Device.ContactStatus type="EQUAL">MANAGEMENT_LOST</Device.ContactStatus>
   <Device.ContactStatus type="EQUAL">DOWN</Device.ContactStatus>
 </Or>
</Filter>
<Select use="exclude" isa="exclude">
  <Item use="exclude">
    <Name use="include"/>
  </Item>
  <Device use="exclude">
   <PrimaryIPAddress use="include"/>
   <ContactStatus use="include"/>
   </Device>
</Select>
</FilterSelect>

[David DuPre]

Hi, I was testing this solution and got this error in response.

<WebServiceException>

    <LocalizedMessage>The web service request failed because the XML provided in the request's body did not conform to the defined schema (see the documentation at 'devices/documentation' for access to the schema definitions).The specific error was: "Error on line 1: cvc-elt.1.a: Cannot find the declaration of element 'FilterSelect'.".</LocalizedMessage>

</WebServiceException>

Any thoughts?

[David DuPre]

Found it... the message viewed in email (MS Outlook Web) hides the "http://" on the first line.

It works now.

[Issac08]

Hi Jeffrey,

It is POST or GET , when i tried i am not getting any results

[Jeffrey Pinard]

I mentioned POST in my example previously.

[Issac08]

But when i tried with the URL and with the BODY i am not returning any output although i have some alerts

[Jeffrey Pinard]

Does it just return?

<DeviceList />

You can try replacing the filter part with:

<Filter>
  <Or>
    <Device.CalculatedContactStatus type="EQUAL">MANAGEMENT_LOST</Device.CalculatedContactStatus>
    <Device.CalculatedContactStatus type="EQUAL">DOWN</Device.CalculatedContactStatus>
  </Or>
</Filter>