Unsolved
This post is more than 5 years old
5 Posts
0
992
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.
rpervan
266 Posts
0
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