Expressions for advanced filter in Management Console

You can find devices in the dashboard matching certain conditions using the advanced filter. To access it, click the arrow next to the filter field and select the Advanced search option.

Please note, the old legacy notations (found here) will still work for the time being, but we would strongly recommend you change to use the below notations as soon as possible.

Statistic field types

In this notation, there are three types of statistic fields:

  • Common - All begin with the letter "I" (upper i) and be followed by a number

    Example: I24 is used to request Time Zone

  • Backup Plugin Statistic - This is a 'per-datasource' field

    Example: D01F03 is used to request the selected size for the last backup session for the Files and Folders data source

  • Restore Plugin Statistic - This is a 'per-datasource' field

    Example: D01F03R is used to request the selected size for the last restore session for the Files and Folders data source

When making requests for multiple data sources or fields per data source, these must be either line or comma separated. E.g. D01F03, D02F03, D03F05

Expressions for column titles

Primary device properties

Column title Short name Type of data
Device name AN String
Installation key QW String
Device ID AU String
Device group name AG String
Device name alias AL String
Customer AR String
Creation date CD Time
Expiration date ED Time
Product PN String
Retention units RU String
Email EM String

Installation details

Column title Short name Type of data
Client version VN String
Computer name MN String
Computer manufacturer MF String
Computer model MO String
OS version ? OS String
OS type ? OT
  • 1 – workstation
  • 2 – server
  • 0 – undefined
MAC address MA String
Internal IPs IP String
Time offset TZ Number

Storage info

Column title Short name Type of data
Storage location ? LN String
Used storage US Size
Storage status YS
  • -2 – Offline
  • -1 – Failed
  • 0 – Undefined
  • 50 – Running
  • 100 – Synchronized

Feature usage

Column title Short name Type of data
Active data sources AP String
LSV ? VE
  • 0 – Disabled
  • 1 – Enabled
LSV status YV
  • -2 – Offline
  • -1 – Failed
  • 0 – Undefined
  • 50 – Running
  • 100 – Synchronized
SBI ? IE
  • 0 – Disabled
  • 1 – Enabled
SBI status IT
  • 1 – In process
  • 2 – Failed
  • 3 – Aborted
  • 5 – Completed
  • 6 – Interrupted
  • 7 – NotStarted
  • 8 – CompletedWithErrors
  • 9 – InProgressWithFaults
  • 10 – OverQuota
  • 11 – NoSelection
  • 12 – Restarted
Seeding mode IS
  • 0 – Undefined
  • 1 – Normal
  • 2 – Seeding
  • 3 – PreSeeding
  • 4 – PostSeeding

Miscellaneous

Column title Short name Type of data
Archived size AS String
Account type AT String
Dashboard frequency DF Bitmask
Dashboard language DL String
Activity description DS String
External IPs EI String
Number of ESX virtual machines EN String
Encryption status ES String
Number of Hyper-V virtual machines HN String
SKU KU String
Profile OP String
Own user name OU String
Profile version OV String
Customer reference PF String
SKU of the previous month PU String
Restore email REM String
Restore dashboard frequency RDF Bitmask
Restore dashboards language RDL String
Timestamp TS Unix time
Proxy type PT String

Backup statistics per data source (continued)

Column title System State Files and Folders MySQL Network Shares VSS MS SQL Exchange Stores
Status S0 F0 L0 N0 Z0 X0
Number of files in selection S1 F1 L1 N1 Z1 X1
Number of changed files S2 F2 L2 N2 Z2 X2
Selected size S3 F3 L3 N3 Z3 X3
Processed size S4 F4 L4 N4 Z4 X4
Sent size S5 F5 L5 N5 Z5 X5
Protected size S6 F6 L6 N6 Z6 X6
Number of errors S7 F7 L7 N7 Z7 X7
Session duration SA FA LA NA ZA XA
Last successful session SL FL LL NL ZL XL
Status of the last successful session SQ FQ LQ NQ ZQ XQ
Status of the last completed session SJ FJ LJ NJ ZJ XJ
Timestamp of the last completed session SO FO LO NO ZO XO
Retention SR FR LR NR ZR XR
Color bar – last 28 days SB FB LB NB ZB XB
Session verification details SK FK LK NK ZK XK
License items count - - - NI - -

Backup statistics per data source (continued)

Column title Total backup SharePoint data Oracle VMware virtual machines Hyper-V data
Status T0 P0 Y0 W0 H0
Selected count T1 P1 Y1 W1 H1
Number of files in selection T P2 Y2 W2 H2
Changed count T2 P3 Y3 W3 H3
Number of changed files - P4 Y4 W4 H4
Selected size T3 P5 Y5 W5 H5
Processed size T4 P6 Y6 W6 H6
Sent size T5 P7 Y7 W7 H7
Protected size T6 PA YA WA HA
Errors T7 PL YL WL HL
Number of errors - PQ YQ WQ HQ
Session Duration - PJ YJ WJ HJ
Last successful session TL PO YO WO HO
Last successful session status - PR YR WR HR
Status of the last successful session TQ PB YB WB HB
Last session status TJ PK YK WK HK
Status of the last completed session - - - WI HI
Timestamp of the last completed session TO - - - -
Session verification details TK - - - -
Protected user mailboxes TM - - - -

Backup Statistics per Microsoft 365 Service

Column title Microsoft 365 Exchange Microsoft 365 SharePoint Microsoft 365 OneDrive Microsoft Teams
Status G0 D5F0 J0 D23F0
Number of files in selection G1 D5F1 J1 D23F1
Number of changed files G2 D5F2 J2 D23F2
Selected size G3 D5F3 J3 D23F3
Processed size G4 D5F4 J4 D23F4
Sent size G5 D5F5 J5 D23F5
Protected size G6 D5F7 J6 D23F7
Number of errors G7 D5F6 J7 D23F6
Session Duration GA D5F12 JA D23F12
Color bar – last 28 days GB D5F8 JB D23F8
Status of the last completed session GJ D5F17 JJ D23F17
Session verification details GK D5F19 JK D23F19
Last successful session GL D5F9 JL D23F9
Protected user mailboxes GM D5F20 JM -
Timestamp of the last completed session GO D5F18 JO D23F18
Status of the last successful session GQ D5F16 JQ D23F16
Retention GR D5F14 JR D23F14
Protected shared mailboxes G@ - - -
Protected sites - D5F22 - -
Protected owners - - - D23F20
Protected teams - - - D23F23
Protected channels - - - D23F24
Protected messages - - - D23F25
Auto add new entities D19F26 D5F26 D20F26 D23F26

Status outputs are displayed as one of the following numeric values:

Value Meaning
[1] InProcess
[2] Failed
[3] Aborted
[5] Completed
[6] Interrupted
[7] NotStarted
[8] CompletedWithErrors
[9] InProgressWithFaults
[10] OverQuota
[11] NoSelection
[12] Restarted

Restore statistics per data source

Column title System State Files and Folders Bare Metal Recovery data Virtual Disaster Recovery data MySQL Network Shares VSS MS SQL Exchange stores
Status (restore) RS0 RF0 RB0 RV0 RL0 RN0 RZ0 RX0
Number of files in selection (restore) RS1 RF1 RB1 RV1 RL1 RN1 RZ1 RX1
Number of changed files (restore) RS2 RF2 RB2 RV2 RL2 RN2 RZ2 RX2
Selected size (restore) RS3 RF3 RB3 RV3 RL3 RN3 RZ3 RX3
Processed size (restore) RS4 RF4 RB4 RV4 RL4 RN4 RZ4 RX4
Sent size (restore) RS5 RF5 RB5 RV5 RL5 RN5 RZ5 RX5
Number of errors (restore) RS7 RF7 RB7 RV7 RL7 RN7 RZ7 RX7
Session duration (restore) RSA RFA RBA RVA RLA RNA RZA RXA
Last successful session (restore) RSL RFL RBL RVL RLL RNL RZL RXL
Status of the last successful session (restore) RSQ RFQ RBQ RVQ RLQ RNQ RZQ RXQ
Status of the last completed session (restore) RSJ RFJ - RVJ RLJ RNJ RZJ RXJ
Timestamp of the last completed session (restore) RSO RFO RBO RVO RLO RNO RZO RXO
Color bar – last 28 days (restore) RSB RFB RBB RVB RLB RNB RZB RXB
Session verification details (restore) RSK RFK RBK RVK RLK RNK RZK RXK

Restore statistics per data source (continued)

Column title Total SharePoint data Oracle VMware virtual machines Hyper-V data
Status (restore) RT0 RP0 RY0 RW0 RH0
Number of files in selection (restore) RT1 RP1 RY1 RW1 RH1
Number of changed files (restore) RT2 RP2 RY2 RW2 RH2
Selected size (restore) RT3 RP3 RY3 RW3 RH3
Processed size (restore) RT4 RP4 RY4 RW4 RH4
Sent size (restore) RT5 RP5 RY5 RW5 RH5
Number of errors (restore) RT7 RP7 RY7 RW7 RH7
Session duration (restore) - RPA RYA RWA RHA
Last successful session (restore) RTL RPL RYL RWL RHL
Status of the last successful session (restore) RTQ RPQ RYQ RWQ RHQ
Status of the last completed session (restore) RTJ RPJ RYJ RWJ RHJ
Timestamp of the last completed session (restore) RTO RPO RYO RWO RHO
Color bar – last 28 days (restore) RTB RPB RYB RWB RHB
Session verification details (restore) RTK RPK RYK RWK RHK
Protected user mailboxes (restore) RTM - - - -

Restore Statistics per Microsoft 365 Service

Column title Microsoft 365 Exchange Microsoft 365 SharePoint Microsoft 365 OneDrive Microsoft Teams
Status (restore) RG0 D5F0R RJ0 D23F0R
Number of files in selection (restore) RG1 D5F1R RJ1 D23F1R
Number of changed files (restore) RG2 D5F2R RJ2 D23F2R
Selected size (restore) RG3 D5F3R RJ3 D23F3R
Processed size (restore) RG4 D5F4R RJ4 D23F4R
Sent size (restore) RG5 D5F5R RJ5 D23F5R
Number of errors (restore) RG7 D5F6R RJ7 D23F6R
Session duration (restore) RGA D5F12R RJA D23F12R
Color bar – last 28 days (restore) RGB D5F8R RJB D23F8R
Status of the last completed session (restore) RGJ D5F17R RJJ D23F17R
Session verification details (restore) RGK D5F19R RJK D23F19R
Protected user mailboxes (restore) RGM D5F20R RJM -
Timestamp of the last completed session (restore) RGO D5F18R RJO D23F18R
Status of the last successful session (restore) RGQ D5F16R RJQ D23F16R
Last successful session (restore) RGL D5F9R RJL D23F9R
Protected shared mailboxes (restore) RG@ - - -
Protected sites (restore) - D5F22R - -
Protected teams - - - D23F23R
Protected channels - - - D23F24R
Protected messages - - - D23F25R
Auto add new entities (restore) D19F26R D5F26R D20F26R D23F26R

Expressions for active data sources

See the list of Backup data sources here, with the legacy shortnames detailed for ease:

Full Name New ID Legacy Shortname
Files and Folders D1 F
System State D2 S
MsSql D3 Q
VssExchange D4 X
Microsoft 365 SharePoint D5 --
NetworkShares D6 N
VssSystemState D7 S
VMware Virtual Machines D8 W
Total D9 T
VssMsSql D10 Z
VssSharePoint D11 P
Oracle D12 Y
Hyper-V D14 H
MySql D15 L
Virtual Disaster Recovery D16 V
Bare Metal Restore D17 B
Microsoft 365 Exchange D19 G
Microsoft 365 OneDrive D20 J
Microsoft Teams D23 --
Removable Media -- R

Example

For example, if you want to find the devices that back up "Files and Folders" and "System State" only, the advanced filter expression looks as follows:

I78 =~ 'D01D02'

Breakdown

  • I78: this is new notation meaning "Show active data sources"
  • D01: data source matching 'D01' for Files and Folders
  • D02: data source matching 'D02' for System State"

    • As you are using "I78" here, the data source ID must be in the new notation.