Hi Siva,

I can't see any MCCLI command to get these kind of information.

But you may access the Avamar database and use the SELECT query statements to retrieve the data

Login to the Avamar database as admin user from the command prompt:

psql -p 5555 mcdb

and then run the SELECT statements.

you can find the details about the columns of MCS database views in Avamar administration guide and then create Select statements as required.

Thanks.

Thanks Sandeep, for the info.  I got an error when I tried to connect to the Avamar DB on the Avamar Server.  Is there any default username and password?  This is Avamar VE.

root@avamarServer:~/#: psql -p 5555 mcdb

psql: FATAL:  role "root" does not exist

In general it is bad practice to log into the system as root unless you have some specific task that requires root privileges.

You can access the mcdb if you are logged in as the admin user. Please be cautious. You should only run SELECT operations and only on the views (which start with v_). A better solution would be to use an ODBC connection and the "viewuser" account to review data in the MCDB. Information on how to set this up can be found in the Administration Guide.

Thanks Anderson for your reply.  Now I am able to connect to the Avamar Database using the following credentials.  Thanks to my colleague Brian P too who helped in this.

DB: mcdb

Port: 5555

U: viewuser

P: **********

Some tables are still not accessible using this user even views start with v_**** but many are accessible .  Wow!  there are lot of tables and 50/60 columns in a big bunch of tables.  Yes, as it is a complete backup system, it should be like that.  Which tables are more useful to get the information like how many backups per client machine, de-dupe ratio, new bytes, Number of backups, Number of restores, backup size, restore size, last week backups, last day backups, etc.

v_clients* and v_activities* are the views I tend to reference the most.