search

jbostoen / iTop-custom-extensions

Extensions for iTop . New classes (SIM cards, Monitors, IP Devices), more powerful Mail to Ticket automation, basic info on pro extensions such as geometry and ticket merge, some concepts (Check Out system), several small tweaks.
GNU General Public License v3.0
36 stars 13 forks source link

Import from SpiceWorks (one way sync) #10

Closed jbostoen closed 2 years ago

jbostoen commented 7 years ago

I wrote a script to import data from SpiceWorks API (not very well known and not that great) into iTop.

Basically the current version fetches data from SpiceWorks for all PCs and virtual machines in production. It writes all data from SpiceWorks about the workstations (hardware, selection of software - since SpiceWorks includes way too much information for my taste etc.). You could also retrieve details about your switches (which devices are connected on which port), but those are things I'd like to verify myself.

It's a very basic script right now, which I might share if I remove the sensitive details; and you'd need to adjust it a lot.

I might rewrite it at some point if I figure out how I make it user friendly enough to set up a few things and leave enough options.

jbostoen commented 6 years ago

Rewrote script, it's not in the repository yet because I need to test it properly. Also considering a few more improvements.

Learned the hard way that you shouldn't use " INSERT IGNORE ... " or " INSERT ... ON DUPLICATE KEY UPDATE ... " statements.

For the new version, I was in doubt whether to use the iTop REST API or manipulate the database directly. The last option seemed more useful.

jbostoen commented 4 years ago

Todo: rewrite this and implement natively, similar to jb-crab

jbostoen commented 2 years ago

Since SpiceWorks has not received any proper updates and I personally don't use this integration anymore with iTop, I'm closing this.