Skip to main content
Question

Custom Report - Combining Multiple Reports

  • May 23, 2025
  • 1 reply
  • 62 views

Forum|alt.badge.img

Hi Team,

I am currently attempting to build a custom report that consolidates the following individual reports into a single comprehensive report:

  • Last 12 Month Backup Job Trending
  • Disk Library Growth
  • Disk Library Capacity Details
  • Cloud Library Growth
  • Cloud Library Capacity Details
  • Average Q&I Time
  • DDB Capacity

Unfortunately, I have encountered difficulties due to the lack of detailed database information. I have explored Commcell views, but none have provided the necessary insights.

In my efforts to create this report, I attempted to generate a dataset using HTTP from REST APIs. However, I encountered an error stating, “Illegal character in query at index 483: .”

Considering an alternative approach, I explored the possibility of using SQL queries. While I identified the table related to the library, “CNMMMediaInfoView,” I was unable to locate other tables containing the required information.

I have reviewed several posts that appeared promising, but they did not provide the specific details I need.

 

 

Your guidance and assistance in resolving these issues would be greatly appreciated.

Thanks in advance.

1 reply

Forum|alt.badge.img+12
  • Vaulter
  • May 24, 2025

Hi ​@Tangsten ,

Custom reports typically involve combining multiple tables and may require complex SQL queries. As such, the requirement cannot be fulfilled solely through REST APIs or basic SQL queries.

Therefore, reaching out to the Accounts team and engaging the Professional Services team would be the appropriate approach to address this requirement effectively