Avamar Excel Definitions

Field

Value

Project ID

An Integer specifying the Project ID

Project Name

The Project Name

Date

The Date the Project was created in MM/DD/YYYY HH:MM:SS Time format

Owner

The name of the project Owner, Email of the Project Owner.

Collector

The build version of the collector that generated the first Collector Run in this project.

Field

Value

Hostname

Client resources added to that Avamar server. In case of Guest clients, name is added as FQDN. In case of Virtual Machines , the name is added as : <VM_NAME>_<UNIQUE_ID><TIMESTAMP>.

Also Avamar server checkpoints are added in that report where the hostname is (Avamar-HFScreateTime).

Save Set

The name of the backup created for each client. If the workorder is scheduled, it is reported with the full path of the group that ran the backup. if the workorder is taken ondemand from the server, it is reported as MOD-<Workorder_number>. If the workorder is client initiated, it is reported as COD-<Workorder_number>. Finally, Avamar server checkpoint corresponding to avamar-hfscreateTime with saveset set as /AvamarPartition_n/cp.gsan.

Application

Workload.The type of the plugin/Application on the client protected by Avamar backups. This can be Windows File System, Linux File System, SQl VSS, Windows VSS, Exchange VSS, Sharepoint VSS, Oracle, Linux VMware Image, Windows VMware Image..etc and for the cp.gsan, plugin type is set as No Plug-in.

Max Peak GB

An integer showing the Front End Terabyte capacity which is the maximum backup target capacity as reported by the client OS.

Date Of Max

The date on which the Max Peak GB is captured by the client OS in terms of  MM/DD/YYYY HH:MM:SS.

Field

Value

Server

Client resources added to that Avamar server. In case of Guest clients, name is added as FQDN. In case of Virtual Machines , the name is added as : <VM_NAME>_<UNIQUE_ID><TIMESTAMP>. Also Avamar server checkpoints are added in that report where the hostname is Avamar-HFScreateTime

Job ID

The ID of the backup workorder initiated on the avamar server for a client.

Policy Type

The Plugin type of the Backup taken for a client.

Duration Hr

The time taken for a backup in Hours expressing the longest time taken for each client.

Capacity GiB

An integer showing the size of the backup taken in Gegabytes.

Throughput MB/sec

Measuring the backup performance in terms of Throughput of the Backup taken in Mega Bytes per Second.

Field

Value

Policy Type

The Plugin type backed up by Avamar.

30

An integer defining Total amount of GiBs with 30 days retention. Retention is the amount of days before backup expires and gets deleted from the avamar server

60

An integer defining Total amount of GiBs with 60 days retention

180

An integer defining Total amount of GiBs with 180 days retention

360

An integer defining Total amount of GiBs with 360 days retention

<7yr

Total amount of GiBs with less than 7 years retention

>7yr

Total amount of GiBs with greater than 7 years retention

Field

Value

Server

The Avamar Server Name

Media Server

The target media server for saving the backup data.

Host

The Avamar Client Name

Operating System

The Operating System of the client protected by Avamar.

Policy Type

The type of Avamar Backup plugin taken for that client: Windows FS, Windows VSS, SQL VSS,windows Image, Linux Image.

Group Name

The Name of the Group created on Avamar to backup the clients. This can be a custom name chosen by the backup admin to name the group or COD which means Client-Ondemand Initiated backup, Admin-Ondemand means on demand backup initiated from the Avamar server side. GC means Garbage Collection job initiated on the server.

Schedule

The Schedule assigned for each client corresponding to the group that the client is a member of. Its is set either as a custom name for the schedule chosen by backup admin or GC for the Garbage Collection or Admin On-Demand for On-demand started backups or Client On-Demand for COD initiated backups

Job Type

Type of the process running on the Avamar in terms of a Scheduled job or On-demand job or Garbage Collection.

Job Level

The level of the process running on the Avamar in terms of a Full- Incremental – differential.

Job Name

The name and the full path of the dataset running the backup. Dataset is created on Avamar to define the job and customer options of each job to be taken from the avamar clients. Also this lists the Garbage Collection process runs.

Stream #

Number of Streams set on each job.

Keyword

Specific Keyword set/added on the started Avamar job.

Capacity (GiB)

The size of the target data for backup as reported by the OS of the Avamar Client.

# Files

The number of Files to be backed up in the Avamar backup.

Start Date

The start time of the job taken in terms of MM/DD/YYYY HH:MM:SS in Local Time zone.

Time Queued (GMT)

The time the job entered the queue before it started running. This time is entered in GMT time zone.

Time Started (GMT)

The start time of the job in GMT time zone.

Time Ended (GMT)

The time the job ended in GMT time zone.

Expiration

Date the taken backup expires in terms of MM/DD/YYYY HH:MM:SS

Retention (Days)

Retention period set for each backup in terms of days.

Total Hours (Queued+Running)

Total Number of Hours taken since the job entered the queue and then started running till ended.

MB/Sec

Throughput of the backup in terms of amount of Mega Bytes sent to the server per second.

Pool

This datapoint is invalid for Avamar, only applies for Networker

SLP

Service discovery Protocol. This is invalid for Avamar Backups.

Storage Unit

Avamar or Datadomain where the data finally resides as a target.

#Files Not Backed Up

Number of Files scanned during the backup however not backed up due to deduplication (non-unique data already residing on Avamar).

Capacity Scanned (MiB)

Amount of MiB per client scanned during the backup before deciding which data to be finally transferred to Avamar.

# Files Scanned

The number of Files scanned per client during the backup before deciding which data to be finally transferred to Avamar.

Capacity Modified

Amount of Megabytes that changed on the client and would be sent to Avamar as new unique data.

Encrypted

Boolean flag showing if the backup has been set for encryption before being sent or not.

Compressed

Boolean flag showing if backup is being set for compression before being sent to Avamar or not.

Is Multiplexed

Boolean flag with values True and False showing if multiplexing is configured on the backup source or not.

Network MB/sec

Network Throughput in terms of MegaBytes per Second.

Compression (%)

Percentage of the compression done on the backup data.

Data Tx Duration (Sec)

Number of Seconds taken for the data to be transferred from the client to the Backup Destination.

# Archive Files Deleted

The number of Archive files deleted on an Oracle Database backup.

# Files Expired

The number of Files expired.

Running Duration (Hours)

Number of Hours taken for running the backup till finished                                              

Acct Flags

Set of custom added flags on the backup either on the dataset or on the backup options

Base Job ID

The workorder ID of the started job for each client

Result Code

if set to 0 means Backup successful or if number, this represents the error code by which the job failed.

Field

Value

Server

Avamar Server Name.

Host

The Avamar Client Name.

Start Value

UNIX start time of the activity. The UNIX start time is in the local time of the Avamar server.

OS

The Operating System of the Avamar Client being backed up or restored.

Start Date

The Date the avamar job either backup or restore started in the format: MM/DD/YYYY HH:MM:SS

Root

The full Path of the dataset on the group to which the client is a member to start the Avamar backup job.

Seconds

The full duration taken by the Avamar job to get started and completed including queued time.

# Files

Number of Files to be scanned on the Avamar Client before being sent on the network for backup minus the files that were excluded through exclusion rules.

# Mod Files

The number of files modified on the client during the backup.

Bytes Mod Not Sent

The number of Bytes modified on the client during the backup and not sent to the Avamar for backup. (non-unique data)

Bytes Mod And Sent

The number of Bytes modified on the client during the backup and sent to the avamar for backup.

Bytes Processed

Total number of Bytes on the client scanned during the backup for deciding to either send to Avamar for backup or skip.

(Bytes Mod Not Sent+ Bytes Mod And Sent)

% Common

Percentage of the data already residing on the avamar server from previous backups to the total amount of data scanned on the client during the backup.

Overhead

The number of bytes for COMPOSITEs and DIRELEMs used to store data on the server. Overhead is the amount of non-file data that the client sends to the server for the following items: Indexing information , Requests from the client to the server for the presence of specific data chunks, ACLs, Directory information and Message headers.  On any active file system, overhead is usually a small percentage of the file data that is sent to the Avamar server.

Workorder ID

A unique ID of the Avamar job started on the Avamar in format of Schedule-Avamar Group Name – unique ID:

-        For scheduled backups, the format of a workorder ID is schedule_name-group_name-time. where schedule_name is the name of the Avamar schedule, group_name is the name of the Avamar group, and time is the UNIX time in milliseconds.

-         For on-demand backups initiated from the Policy window Back Up Group Now command, the format of the workorder ID is group_name-time where group_name is the name of the Avamar group and time is the UNIX time in milliseconds.

-        For on-demand backups or restores that you start from the Backup, Restore and Manage window, the format of the workorder ID is MOD-time where time is the UNIX time in milliseconds.

-        For on-demand backups that you start from the system tray icon on a Windows client, the format of the workorder ID: COD-time where time is the UNIX time in milliseconds.

-        For command line backups or restores, the format of the workorder ID is NAH-time where time is the UNIX time in milliseconds.

-        For replication activities, the format of the workorder ID: CODNAH-time where time is the UNIX time in milliseconds

Client Ver

The Avamar plugin version installed on the Avamar client.

Operation

The type of Avamar job started on the Avamar for that client: OnDemand Backup, scheduled backup, restore,  replication or validation.

Status

The final status of the Avamar job running on the client.

Session ID

same as the Base Job ID on Job List Detailed tab which gives the ID of the Avamar job started on the server.

Reduced

The number of bytes reduced by Total Compression.

Field

Value

Status

The Final status of the Avamar job either completed or failed with an error or exception.

Total

The number of jobs reported per each status.

Field

Value

Total

The total number of jobs running on the Avamar server

Successful

The total number of jobs that are successful

Exception

The total number of jobs ending with Exception.

Failed

The total number of jobs that failed.

Field

Value

Plugin Name

The type of client Application protected on Avamar Clients

Count

Total number of Clients per each Plugin Name on the Avamar server

Field

Value

<=15mins

The total number of jobs that completed in less than or equal 15 mins

>15-30 mins

The total number of jobs that completed in the range of 15 to 30 mins

>30-60 mins

The total number of jobs that completed in the range of 30 to 60 mins

>1-2 hours

The total number of jobs that completed in the range of 1 to 2 hours

>2-4 hours

The total number of jobs that completed in the range of 2 to 4 hours

>4-8 hours

The total number of jobs that completed in the range of 4 to 8 hours

>8 hours

The total number of jobs that completed in more than 8 hours.

Field

Value

Full Domain

The full path of the client with no Backups on the Avamar server together with the client’s FQDN.

Client Type

The type of client as its protected by the Avamar server,either REGULAR for Guest clients, VREGULAR for Virtual Machines with Avamar software running on top, VMACHINE for VMs backed up as image level backups and VPROXY for proxies.

Completed Time

The recent time between the time the client was added to the Avamar server or the last time a backup was taken for that client with the format MM/DD/YYYY HH:MM:SS

Field

Value

Display Full Domain

The full path of the client with no Backups on the Avamar server together with the client’s FQDN.

Completed Time

The recent time between the time the client was added to the Avamar server or the last time a backup was taken for that client with the format MM/DD/YYYY HH:MM:SS

Field

Value

Client Type

A var char showing the type of client either REGULAR for Guest clients, VREGULAR for Virtual Machines with Avamar software running on top, VMACHINE for VMs backed up as image level backups and VPROXY for proxies. All Client Types give the total number of clients added to the server.

Total

Number of Clients per each client type.

Field

Value

Full Domain Name

The FQDN of the client with the full path of that client on the Avamar.

Agent Version

The version of the Avamar Plugin installed on each client.

Client Type

The type of client as its protected by the Avamar server,either REGULAR for Guest clients, VREGULAR for Virtual Machines with Avamar software running on top, VMACHINE for VMs backed up as image level backups and VPROXY for proxies .

OS Type

The Type of the Operating system running on the client

Field

Value

Agent Version

The versions of the Avamar Plugins installed on the Avamar Clients and protected by the server.

Total

The Total number of clients per each Agent version.

Field

Value

Domain

The full path of the datasets created on the Avamar server.

Name

The Name of each dataset created on the Avamar server.

Read Only

A Boolean flag that is true if the dataset cannot be modified.

DS ID

A unique internal ID specified for the dataset and can be viewed from the main MCS database: MCDB.

Field

Value

Domain

The full path of the group on the server

Name

The Name of the group

Read Only

Boolean Flag that is true if the group cannot be modified

Field

Value

Group Name

The name of the Group.

Group Scheduled Start Time

The schedule assigned to start each group in terms of MM/DD/YYYY HH:MM:SS

Group Start Time

The Actual time on which the group started on the last run in terms of MM/DD/YYYY HH:MM:SS

Group End Time

The Actual time on which the last group run ended in terms of MM/DD/YYYY HH:MM:SS

Duration

The amount of time taken on the last Run of that Group in terms of Y M D H M S.

Total

Total Number of Clients that are members of each group.

Successful

Total number of clients that succeeded on the last run of each Group.

Exception

Total number of clients that completed the last run with exceptions on each Group.

Failed

Total number of clients that failed for clients on each Group.

Field

Value

Hostname

The FQDN of the Avamar Server

Serial

The Serial Number of the Avamar server.

Field

Value

Client Type

The type will be set as VPROXY_REGULAR which is the same as VPROXY defining the type of a proxy client.

Total

The Total number of Proxies added to the Avamar.

Field

Value

Full Domain

The full path and FQDN of the proxies added on the server.

Field

Value

Date

The Date Range specified to collect the report for the Avamar Server.

Node

A varchar showing the number for each node on the Avamar server, either a single node Avamar so we will only have 1 node or multi-nodes grid and thus listing the utilization of each node.

Max Utilization (%)

The maximum reported percentage of the storage space used by each node.

Field

Value

Has Backups

Boolean flag set to False if no backups for these non-retired clients and True if there are backups for these Non-retired clients.

Total

A Numeric showing the full number of Non retired clients that has and don’t have backups on the server.

Field

Value

Full Domain Name

A varchar showing the full path of the clients.

Overtime Allowed

A Boolean flag showing of overtime is set to True or false on the client settings.

Overtime Option

A varchar showing the level of overtime chosen for the client: Always means Always Allow over time for the client, Next_Success means allow over time on the next run only.

Client Type

A var char showing the type of client either REGULAR for Guest clients, VREGULAR for Virtual Machines with Avamar software running on top, VMACHINE for VMs backed up as image level backups and VPROXY for proxies

Field

Value

Status

A varchar listing the possible status of a replication job: Activity Cancelled  - Successfully Completed – Completed with Exceptions – Failed with Errors – Failed To Login to a Remote Server – Partially Completed Replication.

Total

An integer showing the full number of Replication jobs corresponding to each status.

Field

Value

Domain

The path of the Retention created on the server.

Name

The Name of the Retention policy created on the server

Read Only

A Boolean flag set to True if the retention policy is not allowed for modification.

Field

Value

Has Backups

A Boolean Flag specifying if the retired client is having non-expired backups on the Avamar server

Total

An integer showing the full number of retired clients with or without backups.

Field

Value

Domain

The full path of the schedule.

Name

The Name of the schedule.

Read Only

A Boolean flag if set to true defines that that schedule cant be modified.

Field

Value

Client Type

A varchar set as VCENTER to define the type of that entity on the Avamar.

Total

An integer defining the total number of vCenters added to that Avamar server.

Field

Value

Full Domain Name

The Full path with the FQDN of the VCenter Server.

Total

An integer showing the total number of vCenters added to the server.