- Community Home
- >
- Networking
- >
- IMC
- >
- Getting all switches name and their Vlan from Data...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-29-2019 02:54 AM
тАО07-29-2019 02:54 AM
Hello !
I am developping a software for a company, and i might need some help to exploit the IMC database.
Am loocking to list every switches with their Vlan and some other info. The database is enourmous and i don't know where to begin my research.
So if anyone know where is located the names, IP maybe, and which Vlan they are using it would be very nice.
Thank you !
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-29-2019 03:13 AM - edited тАО07-29-2019 03:17 AM
тАО07-29-2019 03:13 AM - edited тАО07-29-2019 03:17 AM
Re: Getting all switches name and their Vlan from Database
i think i've got it :
is it vlan.tbl_vlan_name : to get every Vlan that exists
and then check the dev_id with imc_inventory.tbl_inventory_dev to get the name of the device (switch).
Is that right ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-29-2019 04:20 AM
тАО07-29-2019 04:20 AM
SolutionHello,
Generally speaking, we don't support using the database as a direct source for third-party application integration. Though I'm sure you could do it, and you seem to be looking at the right tables there, keep in mind that DB tables in IMC are not guaranteed to remain the same across updates. These probably will work - but in general it's a reason why DB should not be accessed directly. There's also the other caveat that using your own script to change things in the IMC DB is not supported (it will be really risky at best, and break the DB at worst).
To integrate third-party applications, the eAPI should be used. It supports JSON and XML and can be used to read and write information in a safe and supported way from/to IMC. There is plenty of documentation and tutorials:
Official Guide: https://support.hpe.com/hpsc/doc/public/display?docId=emr_na-c03382045
Tutorials:
Becoming a Guru with eAPIs: https://blogs.arubanetworks.com/industries/become-a-guru-with-imc-eapis/
Sample Python Project for IMC: https://pypi.org/project/pyhpeimc/
Deploying CLI Commands: https://abouthpnetworking.com/2014/04/28/hp-imc-eapi-deploying-cli-commands-part-1/
Video Tutorials:
Getting Started with eAPI: https://www.youtube.com/watch?v=gShXT4-2sSM
Working with Operators: https://www.youtube.com/watch?v=81Ivad5Hizw
Hope that helps.
Justin
Working @ HPE
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-29-2019 04:51 AM
тАО07-29-2019 04:51 AM
Re: Getting all switches name and their Vlan from Database
Thank you for the reply HPE Employee.
The only things that i need is to read data that is in the database, I do not modify them.
I'll use the database directly for the moment, then i'll search about the API and learn how to use it in the future.
Thanks about for the advice and the information !