Question about an Odata Query

[mastercraft]

Is there a way in the Odata query builder to find only those devices where the reachability has been 0 (Not Reachable) for a certain amount of time? I have tried this, however, I am getting devices with everything above 0 as well. Here is my Odata built query:

 

http://da-hostname:8581/odata/api/devices?&resolution=RATE&period=1h&$expand=reachabilitymfs&$select=ID,HostName,PrimaryIPAddress,reachabilitymfs/im_Reachability&$filter=((reachabilitymfs/im_Reachability eq 0))

[Michael Poller]

Hi Mitch,

 

I was able to get a query like this to work in an r3.2 lab we have in support.

 

 

Changing the targeted reachability values, and time ranges, did change the data sets returned and it appeared at first glance they were only those that met the criteria.

 

 

Mike

[Rajani Bayapati]

Can we export list of Threshold profiles created , i can only view in table format, no option to export. Do we have Query to export it .

I tried rest documentation and tried executing in postman client, however there is no list coming with itemID also

http://DA:8581/rest/thresholdmonitoring/config/documentation

[Jeffrey Pinard]

Yes,

http://DA:8581/rest/eventprofilegroups the folders that profiles are under

http://DA:8581/rest/eventprofiles the profiles themselves, with itemids of the rules that make up each

http://DA:8581/rest/eventrules the rules that make up the profiles

[mastercraft]

Sorry, I should of specified PM 3.5. I too was able to get this to work about a year ago on 3.2. I think I just got it to work in 3.5. But I had to use the Aggregate filter function.

[Anon Anon]

HI Mitch, so just want to double check, sounds like you are all set then?  let us know if more help is needed.