How are you automating reports across multiple Hexnode tenants?Solved

Participant
Discussion
3 months ago Apr 13, 2026

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? 

Replies (10)

Marked SolutionPending Review
Participant
3 months ago Apr 13, 2026
Marked SolutionPending Review

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. 

Marked SolutionPending Review
Participant
3 months ago Apr 13, 2026
Marked SolutionPending Review

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. 

Marked SolutionPending Review
Participant
3 months ago Apr 13, 2026
Marked SolutionPending Review

Oh okay, so it’s not like a centralized dashboard kind of setup? 

Marked SolutionPending Review
Participant
3 months ago Apr 14, 2026
Marked SolutionPending Review

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. 

Marked SolutionPending Review
Participant
3 months ago Apr 14, 2026
Marked SolutionPending Review
One thing we found useful was aligning the schedule with how our team actually reviews data. For example, critical reports go out daily so we can keep an eye on changes, while others are weekly to match internal review cycles. That way the reports are not just automated, but also timed in a way that makes them actionable. 
Marked SolutionPending Review
Participant
3 months ago Apr 14, 2026
Marked SolutionPending Review

Got it. So, everything just lands in email? Doesn’t that get messy after a point? 

Marked SolutionPending Review
Participant
3 months ago Apr 14, 2026
Marked SolutionPending Review

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. 

Marked SolutionPending Review
Participant
3 months ago Apr 14, 2026
Marked SolutionPending Review

Yeah that makes sense. But even then, you’ll still end up with a lot of CSV files piling up, right? 

Marked SolutionPending Review
Participant
3 months ago Apr 15, 2026
Marked SolutionPending Review

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. 

Marked SolutionPending Review
Participant
3 months ago Apr 15, 2026
Marked SolutionPending Review

Yeah this sounds way more manageable than what we’re doing now. Thanks for explaining it so clearly! 🙌 

Save