How can i collect the Serial number of Network devices those are monitor on Fortimonitor via POWERBI

Hello rohitkr,

Thank you for using the Community Forum. I will seek to get you an answer or help. We will reply to this thread with an update as soon as possible.

Kind regards,

Hello rohitkr,

We are still looking for an answer to your question.

We will come back to you ASAP.

Thanks,

Hello Rohit, 

For instances where we are able to detect a serial number the value is stored as an attribute of the instance. You can leverage API calls to FortiMonitor to pull server attribute values for instances. Information on how to setup an API key for FortiMonitor can be found here.

Once you've setup an API key you can make a query against the following endpoint using the server ID to pull the attribute values for a specific server.

GET /server/{server_id}/server_attribute

From within the results returned by that API call the serial number for SNMP instances will be the 'value' returned for the attribute with the following text key value. 

 "textkey": "snmp.serial_num"

Please let us know if you have any further questions. 

Thanks, 

Mike