Emerson Exchange 365

• Not Answered

AMS Data Export

Hi all,

Does anyone know of a way to pull specific product information (i.e. serial numbers) from the AMS database? Looking at an AMS backup file and it does really have any meaning to it. It would be advantageous if a person was able to pull bulk data from your devices when looking at site critical sparing or just getting a handle of what the site installation looks like. I've just never come across a way to pull that information out of AMS other than a manual one by one process. 

Even if I could get the information in a certain format then we could write some script to pull specific data out.

Let me know you thoughts, thanks!

• AMS

Eric_Brousseau

• 25 May 2023 1:38 PM
• Cancel

4 Replies

• Tinh Phan

  

  • 25 May 2023 3:18 PM

  Open the device dashboard in AMS Device Manager and go to "File" drop down and chose "Export All". Use excel and open the file. All device data are there.

  • Cancel
• MPHymel

  

  • 25 May 2023 3:22 PM

  In reply to Tinh Phan:

  There is also an external tool that can be used if you have thousands of devices on your system, the tool gates exports to smaller chunks of data and spreads it out over time.

  • Cancel
• Marlen Osmanov

  

  • 25 May 2023 6:08 PM

  4f4f4f4

  
  

  Marlen.

  Tel:+79855203476

  
  

  
  

  • Cancel
• Tushar Gohad

  

  • 26 May 2023 6:10 AM

  Hi,
  Device Information can be extracted from Generic Export File for multiple devices at time.
  to extract information follow these steps - Launch AMS Device Manager --> in Device Explorer View Click on AMS Device Manager --> Export --> Select Generic Export File --> Select device/s for which information extraction --> Select Date & Time Range --> file will save on default path.
  
  Once export done, open excel file & drag/drop exported .xml file & follow prompt. Search parameter/s looking for.

  • Cancel