Hi all, we’ve set up a few reports across different tenants, but honestly, running them manually every time is starting to get annoying 😅. Is there a better way to handle this across multiple Hexnode portals without logging into each one again and again?
How are you automating reports across multiple Hexnode tenants?Solved
Replies (10)
Yeah, that gets painful pretty quickly once the number of tenants grows. We ran into the same thing. What worked for us was switching to scheduled reports, but also slightly changing how we approached it. Instead of trying to pull everything from one place, we let each tenant handle its own reporting and just push the data out.
What helped in our case was leaning into how the platform is structured. Each tenant already has strong reporting capabilities, so we focused on configuring them individually in a consistent way. Once every tenant is set up with the same kind of report and schedule, the overall visibility comes together quite nicely at the MSP level.
Oh okay, so it’s not like a centralized dashboard kind of setup?
Not really. It works more like a push model. What we did was, for each tenant, we first built the exact custom report we needed, like outdated OS or inactive devices. Then we went into scheduled the reports and set it up to send automatically on a fixed schedule. We usually go with daily or weekly depending on how often we want updates.
Got it. So, everything just lands in email? Doesn’t that get messy after a point?
It definitely can if you don’t structure it properly. That part matters more than people expect. We send everything to a single central inbox, or you could even route it into a ticketing system if that fits your workflow better. Also make sure the format is CSV, not PDF, since the idea is to actually use the data later.
Another thing that really helped us was naming. If every report clearly includes the tenant name, it makes life much easier when you start dealing with multiple files.
Yeah that makes sense. But even then, you’ll still end up with a lot of CSV files piling up, right?
True, and that’s where the last piece comes in, aggregation. Instead of opening each file one by one, we route all the attachments into a single folder, could be local or even SharePoint. Then in Excel, we use Power Query and choose the “Get Data from Folder” option. It automatically reads all the CSV files in that folder and combines them into one dataset.
Since the reports all follow the same structure and naming, you can still clearly see which device belongs to which tenant after everything is merged. It ends up being pretty clean.
Yeah this sounds way more manageable than what we’re doing now. Thanks for explaining it so clearly! 🙌