Building Custom Report


Userlevel 2
Badge +9

Hi Fellas,

We have a BI server that we use in our own environment. Here we want to make a report on the BI server. This report will show the following information. It will show information such as Client Name, hostname, type of agent installed on it, content, last backup date according to Agent, whether there is Aux Copy, next backup date. Which tables should we read on CommServ DB for this information? Or is there a SQL Query you know about it?

 

Best Regards.


13 replies

Userlevel 7
Badge +23

@0ber0n , good question.  I absolutely love PowerBI!

Some of that data is in client table, some in licusage, though some of that will require joining multiple tables, or doing it through custom measures/import edits in Power BI itself.

I have reached put to some folks I’m curious to see if anyone else in the community has anything to add.

Userlevel 2
Badge +9

Hi Mike, I think we need more than one table, we plan to export this information regularly and import it into the BI application.

Userlevel 7
Badge +23

Right, you’re likely better off creating a custom view and importing that into PowerBI.  I’ll follow up with some internal folks on this one.

Userlevel 2
Badge +9

Right, you’re likely better off creating a custom view and importing that into PowerBI.  I’ll follow up with some internal folks on this one.

Hi Mike, is it possible to help to me on this ? I also wrote you via private message :see_no_evil: :)))

Userlevel 7
Badge +23

I’m on it :nerd:

Was out of the office a bit, and following up now!

Userlevel 7
Badge +23

I got something for you:

https://cloud.commvault.com/webconsole/downloadcenter/packageDetails.do?packageId=20106&status=0&type=details

This is a list of EVERY table and what is there.

You should be able to figure out which tables you’ll need to pull your data out of for PowerBI (there’s a LOT to go through, but a lot of it is self explanatory).

Luckily, PowerBI will make most of the connections for you, so the data itself should be good enough without needing to create any views.

Userlevel 2
Badge +9

Hi Mike,

 

Unfortunately, when I open the link, the following homepage comes up. I can't see any list :(

 

 

Userlevel 7
Badge +23

Might be a permissions issue…..let me follow up with the developers.

Userlevel 3
Badge +4

Sorry everyone, apparently the database document is locked down right now. We are looking at expanding access again, but for now we recommend that customers use REST API data sets with the Commvault API library to create reports.

BOL instructions for creating a REST API data set: https://documentation.commvault.com/11.24/essential/44582_creating_http_data_sets.html

BOL REST API library: https://documentation.commvault.com/11.24/essential/45619_rest_api_api_library.html

Commvault REST API website: https://api.commvault.com/

Userlevel 2
Badge +9

Hi Amanda,

Thank you for your answer. I checked here but couldn't find any APIs that meet our requests.

Userlevel 7
Badge +23

@0ber0n , you might want to reach out to your Account Rep who can discuss building a custom view or report.

Hit me up via pm if you don’t know who that person is.

Badge +1

Is there any documentation available to integrate reports with Power BI? the one shared earlier is not much useful.

Userlevel 7
Badge +23

@SGMak , not directly.  You should be able to connect to the SQL database and go from there, though note that from a documentation perspective, the database info is pretty locked down.  You could also connect Power BI via the APIs that @Amanda Tesla mentioned.

We do have a bunch of SQL Views that present the data much better, though:

https://documentation.commvault.com/2022e/expert/39461_commcell_views_01.html

We don’t have any direct guides, per se, but there’s enough info between everything here to get started.

Reply