I would like to be able to export or somehow run a report for all of a single Customer’s Contacts, including address. The reason for this as we have a client with several locations, and we are trying to compile a list of what users are at what location. Currently, it feels like we have to manually open each contact, which, they have 170 of them. This is something we would probably want to run quarterly.
The customer is requesting a report of all assets by location and user. I would like to be able to run a report that would be for the entire Customer for all locations, including the Contact (which I can get this with an Export All), and also the city associated with that contact/asset location.
In theory, if I could generate 1) above, then I could make a vlookup in Excel that would do what I need.
I can also run several reports by site in Assets which would then have the Contact name only, but it is at least a work around.
You can do #1 now using the Internal Report Builder. You can do this a few different ways, but I think the way I’d do it is to make a Saved Customer Search scoped to each customer location. Then you could make a Contacts list block that looks for all contacts scoped to that Saved Customer Search, and include whatever columns you want in the report as well. Secondarily, you could tag contacts with a custom field and then use that as a filter using the same report.
You could likely use the exact same Saved Customer Searches to create three list blocks on the same report and that would be your assets broken down by location, and you should be able to use the assigned contact as a the filter.
However, there is not a Internal Report Builder Templates screen that I can see. It looks like it might have been renamed to “Executive Summary Report Builder”. If so, great, please update your documentation so others don’t get frustrated and waste time looking for what the directions say to look for.
If I am in the wrong area, that would also be good know.
There are two. The Executive Summary Report builder is designed to be sent to customers, so it’s typically scoped to a single customer. The Internal Report Builder is largely the same functionality, but scoped to all customers. For the OP’s request, it would depend if their various locations falling under one customer were created as multiple customers or not.
Okay, so I go to Internal Report Builder and then click on Report Templates in order to add new templates. That was just not intuitive for me. Hopefully I’m on the right path now.
Okay, I think I have a very basic version of what I might want over two reports that I will have to cross reference. How can I export these into Excel? I only see an option for PDF. Do I have to manually highlight, copy, and paste into Excel?
Actually these ones specifically can’t be exported to Excel. You can sort by any column, but the column has to be visible in the report. So first add the City column, then you can sort by that column.
I had something similar with needing to get asset ID’s to map Acronis alerts to Syncro alerts. I created a powershell script that generated JSON data (that’s my preference), but it would take all of 5 mins to modify for contacts and to export to a CSV… Let me know if you want the script
I messaged you a version of my script. If you ever need info like this again, a quick way to do it is with API and the “Documentation” page of the API. It’s actually really easy to figure out, and you can save the responses as JSON and use a JSON viewer like Dadroit, or a JSON to CSV converter tool. Great for getting information, albeit if you have heaps of pages of data to get it’s a bit painful…
