search

redbuttegarden / filewave_snipe-it_api

Scripts and tools to interact with both Filewave and Snipe IT APIs.
0 stars 0 forks source link

Filewave SnipeIT sync Project #1

Open abel408 opened 3 years ago

abel408 commented 3 years ago

Hello,

I'm looking for a project that would be able to sync our FileWave inventory to SnipeIT. I'm unsure if that was this project is able to do. Would you mind providing a little bit of documentation about the project and maybe a quick how to?

Thanks!

auslaner commented 3 years ago

Hi! That is what I was doing when I wrote this. It's a bit hacky since it's made for our specific environment but it might offer a jumping off point if you're looking to do something similar and you're comfortable editing the code.

I haven't touched the project for a while so I need refresh myself on how it works as well but here is a quick overview of how things work:

transfer_filewave_to_snipe(filewave_connection, snipe_connection) in main.py is the function that actually pulls info from Filewave to put into snipe. It's looking for a Filewave query called "All OS X" so you'd want to change that to the name of a query that exists in your Filewave. That query should contain the "Client Name" in the first column and "Device Project Name" in the fourth column. This will be used to match machines/clients to models in Snipe IT (that I manually added in Snipe beforehand).

As add_to_snipe(snipe_connection, machine_list, label_id) loops over the information pulled from the Filewave query, it will prompt you to ask what asset tag number to use in Snipe for that particular Filewave client.

Once you have those initial assets in Snipe, add_purchase_date_existing_assets(snipe_connection) would be an example of how you can provide an excel document that where each rows contains an asset tag number and some additional information that you want added to that asset in Snipe. For our code, it happens to be the purchase date for that asset.