Soldato
- Joined
- 30 Sep 2005
- Posts
- 16,553
Hi Everyone,
I have set myself a side project for this year, which is to create an automated asset register.
Basically I want to know the physical locations of all my client devices, in a completely automated way. My thinking is something along the lines of this:
(I already know every outlet in each office and where it cables back to, and in which switch port)
1. Use Solarwinds to interegate the switches to see which MAC address is connected to which switch port
2. Write the above into an SQL database (or if present, simply read it out from the original SW DB)
3. Write some code to read the data out of the database, run some logic to understand (based on the switch port) which physical location the machine is in
4. Search the manageengine servicedesk SQL database for the MAC address (we use this for assets)
5. Write data from 3. into the manageengine servicedeck SQL database
Does anyone in here use solarwinds? and is this something it could potential do?
Unless there is a product on the market which already does this, if so, let me know and I'll buy it
Thanks!!
I have set myself a side project for this year, which is to create an automated asset register.
Basically I want to know the physical locations of all my client devices, in a completely automated way. My thinking is something along the lines of this:
(I already know every outlet in each office and where it cables back to, and in which switch port)
1. Use Solarwinds to interegate the switches to see which MAC address is connected to which switch port
2. Write the above into an SQL database (or if present, simply read it out from the original SW DB)
3. Write some code to read the data out of the database, run some logic to understand (based on the switch port) which physical location the machine is in
4. Search the manageengine servicedesk SQL database for the MAC address (we use this for assets)
5. Write data from 3. into the manageengine servicedeck SQL database
Does anyone in here use solarwinds? and is this something it could potential do?
Unless there is a product on the market which already does this, if so, let me know and I'll buy it
Thanks!!
Last edited:
