Start a Conversation

Unsolved

This post is more than 5 years old

992

September 15th, 2011 12:00

A query to get the equivalent of "Activity Monitor" in SQL?

We are using version 6 of Avamar. I have the SQL connectivity setup and have looked through all the tables and the admin documentation.

I’m looking for a way to query “current status” like you see in Avamar Administrator.  The main things I’m looking for is a query of PC names where status = ‘Running’

The reason I’m doing this is I want to automate the staged deployment of laptop clients (about 2,000 clients in about 60 offices worldwide).  I have fully scripted the installation, activation, group assignment, and initial backup.  What I can’t have is 30 laptops doing their initial backup at the same time out of an office with a slower WAN (<3.0mbps).  The goal is to run a query so when the number of backups “running” is less than “x”, I kick off another install and initial backup.

Right now, I feel we are limited to a technician monitoring the activity console and visually seeing there are only 2 machines backing up in an office and manually running another deployment.  This means babysitting and potential large gaps of time when a backup is finished and a technician does not start another backup for half a day.

266 Posts

September 19th, 2011 13:00

Greg,

you could give a try with this one as root user :

  # mccli activity show | egrep "Running|Status|-------"

and more output with verbose option ...

  # mccli activity show --verbose | egrep "Running|Status|-------"

.r

No Events found!

Top