 Tom here from Warn Systems and I had a little bit of a problem. So I really like the way Unify has their dashboard and allows with the Unify controller software me to manage many different client sites and many of these are all different managed clients that we have in one controller and just switch between the different instances. The downside is if I wanted a list, a list of all the devices across all my clients so I could do some analysis or just you know get account of how many access points or switch we manage, that's not as easy to do. I can look at them on a per site basis and interact with them but seeing them all globally a little bit tricky. This is where I reached out to Riley Chase from Hostify. I've reviewed Hostify before, they well manage more host of controllers than anyone I know and have quite a few devices on there. So they are really clever at writing different Python scripts to help automate things including being able to get that list. So that's what this video is to show you how to easily on your controller instance pull a list and have all the devices you have across all of your clients especially useful for people as I said like myself or in the MSP or manage service provider space and you manage a lot of different client sites. First phase we're going to start is the Hostify GitHub page really easy links down below and the instructions are as simple as it sounds. W get and you grab the file that you need here then you have Python three unified devices to CSV.py and then you grab the file devices that CSV that it creates. Now I'm doing this on my Unify system. So we go Python three unified devices to CSV.py and redacting all the customer data that was just dumped on the screen because it dumps on the screen and also creates a CSV file at the same time. Now from there I took the CSV file through it in Google Docs prettied it up a little bit to make it easy to present on the screen also redacted all of our customer sites on there and left our test site and lab sites in here and my house in here so I don't care if you see what devices we have within my home and lab. So we have the site name the name of the device which apparently we don't name things much in our lab or I have a couple devices here not named MAC address firmware whether it's in long term support end to life whether it's adopted so it'll actually show in the list things that the controller can see that may not have been adopted yet and then the link at the end is the management controller because for each site you have a different name it's kind of clever because it can throw those links right in there so you can click and jump right to the different sites and different controller sections if you want to and that's all you need to do now it's written in Python and there's nothing really too complicated about it if you know some basic Python where you couldn't modify this maybe there's a few extra fields you'd like to pull in pull some other statistics maybe even create a regular running script that does this and outputs it to somewhere else kind of the sky's the limit it also doesn't require any special usernames or passwords or anything to be put into it because it's running locally on your Unify server and talking to the local MongoDB instance so it is able to connect without you having to do anything special I've only tested this on my controllers things that we have access to I have not tested this to see if this would work on for example a cloud key or one of the dream machines I'm not sure how good their Python support is it's not something I really have taken the time to test but I imagine if you pull the Python libraries over there it should work perfectly fine on those as well but hopefully this is helpful easy way to get a list out of there if you're interested in signing up for hostify I do have an offer code and affiliate link down below there are great service if you don't want to deal with hosting to control yourself I've reviewed them on a channel before if you're curious but hey thanks again to Riley and the team over at hostify for putting this together relatively quick for me because we had a couple issues we needed to solve and trying to get an inventory from a couple projects that we had in there going just how many of these devices do we have across these four different sites for a customer and it was an easy way to answer that question without having to manually go through it hopefully it's helpful to you links are down below for everything I talked about thanks and thank you for making it all the way to the end of this video if you've enjoyed the content please give us a thumbs up if you would like to see more content from this channel hit the subscribe button and the bell icon if you like to hire a short project head over to laurancesystems.com and click the hires button right at the top to help this channel out in other ways there's a join button here for youtube and a patreon page where your support is greatly appreciated for deals discounts and offers check out our affiliate links in the description of all our videos including a link to our shirt store where we have a wide variety of shirts that we sell and designs come out well randomly so check back frequently and finally our forums forums dot laurancesystems.com is where you can have a more in-depth discussion about this video and other tech topics covered on this channel thanks again for watching and look forward to hearing from you