SolarWinds Backup Help

Expressions for advanced filter in Backup Management Console

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

Below is the list of expressions for column titles and the names of active data sources.

Expressions for column titles

Primary device properties

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

Installation details

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

Storage info

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

Feature usage

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

Miscellaneous

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

Backup statistics by the data source (continued)

Column title System State Files and Folders Linux System State Network Shares VSS MS SQL Exchange Stores SharePoint data Oracle VMware virtual machines Hyper-V data MySQL status
Status S0 F0 K0 N0 Z0 X0 P0 Y0 W0 H0 L0
Number of files in selection S1 F1 K1 N1 Z1 X1 P1 Y1 W1 H1 L1
Number of changed files S2 F2 K2 N2 Z2 X2 P2 Y2 W2 H2 L2
Selected size S3 F3 K3 N3 Z3 X3 P3 Y3 W3 H3 L3
Processed size S4 F4 K4 N4 Z4 X4 P4 Y4 W4 H4 L4
Sent size S5 F5 K5 N5 Z5 X5 P5 Y5 W5 H5 L5
Protected size S6 F6 K6 N6 Z6 X6 P6 Y6 W6 H6 L6
Number of errors S7 F7 K7 N7 Z7 X7 P7 Y7 W7 H7 L7
Session duration SA FA KA NA ZA XA PA YA WA HA LA
Last successful session SL FL KL NL ZL XL PL YL WL HL LL
Status of the last successful session SQ FQ KQ NQ ZQ XQ PQ YQ WQ HQ LQ
Status of the last completed session SJ FJ KJ NJ ZJ XJ PJ YJ WJ HJ LJ
Timestamp of the last completed session SO FO KO NO ZO XO PO YO WO HO LO
Retention SR FR KR NR ZR XR PR YR WR HR LR
Color bar – last 28 days SB FB KB NB ZB XB PB YB WB HB LB
Session verification details SK FK KK NK ZK XK PK YK WK HK LK
Licence items count - - - NI - - - - WI HI -

Backup statistics by the data source (continued)

Column title Total Office 365 Exchange Office 365 OneDrive
Status T0 G0 J0
Selected count T1 - -
Number of files in selection - G1 J1
Changed count T2 - -
Number of changed files - G2 J2
Selected size T3 G3 J3
Processed size T4 G4 J4
Sent size T5 G5 J5
Protected size T6 G6 J6
Errors T7 - -
Number of errors - G7 J7
Session Duration - GA JA
Last successful session TL GL JL
Last successful session status TQ - -
Status of the last successful session - GQ JQ
Last session status TJ - -
Status of the last completed session - GJ JJ
Last session time TO - -
Timestamp of the last completed session - GO JO
Retention - GR JR
Last 28 days TB - -
Color bar – last 28 days - GB JB
Session verification details TK GK JK
Protected user accounts TM - JM
Protected shared accounts T@ - -
Protected regular mailboxes - GM -
Protected shared mailboxes - G@ -
Protected grouped accounts - - J@

Restore statistics by the data source

Column title System State Files and Folders Linux System State Bare Metal Recovery data Virtual Disaster Recovery data MySQL
Status (restore) RS0 RF0 RK0 RB0 RV0 RL0
Number of files in selection (restore) RS1 RF1 RK1 RB1 RV1 RL1
Number of changed files (restore) RS2 RF2 RK2 RB2 RV2 RL2
Selected size (restore) RS3 RF3 RK3 RB3 RV3 RL3
Processed size (restore) RS4 RF4 RK4 RB4 RV4 RL4
Sent size (restore) RS5 RF5 RK5 RB5 RV5 RL5
Number of errors (restore) RS7 RF7 RK7 RB7 RV7 RL7
Session duration (restore) RSA RFA RKA RBA RVA RLA
Last successful session (restore) RSL RFL RKL RBL RVL RLL
Status of the last successful session (restore) RSQ RFQ RKQ RBQ RVQ RLQ
Status of the last completed session (restore) RSJ RFJ RKJ - RVJ RLJ
Timestamp of the last completed session (restore) RSO RFO RKO RBO RVO RLO
Color bar – last 28 days (restore) RSB RFB RKB RBB RVB RLB
Session verification details (restore) RSK RFK RKK RBK RVK RLK

Restore statistics by the data source (continued)

Column title Total Office 365 Exchange Office 365 OneDrive Network Shares VSS MS SQL Exchange stores SharePoint data Oracle VMware virtual machines Hyper-V data
Status (restore) RT0 RG0 RJ0 RN0 RZ0 RX0 RP0 RY0 RW0 RH0
Number of files in selection (restore) RT1 RG1 RJ1 RN1 RZ1 RX1 RP1 RY1 RW1 RH1
Number of changed files (restore) RT2 RG2 RJ2 RN2 RZ2 RX2 RP2 RY2 RW2 RH2
Selected size (restore) RT3 RG3 RJ3 RN3 RZ3 RX3 RP3 RY3 RW3 RH3
Processed size (restore) RT4 RG4 RJ4 RN4 RZ4 RX4 RP4 RY4 RW4 RH4
Sent size (restore) RT5 RG5 RJ5 RN5 RZ5 RX5 RP5 RY5 RW5 RH5
Number of errors (restore) RT7 RG7 RJ7 RN7 RZ7 RX7 RP7 RY7 RW7 RH7
Session duration (restore) - RGA RJA RNA RZA RXA RPA RYA RWA RHA
Last successful session (restore) RTL RGL RJL RNL RZL RXL RPL RYL RWL RHL
Status of the last successful session (restore) RTQ RGQ RJQ RNQ RZQ RXQ RPQ RYQ RWQ RHQ
Status of the last completed session (restore) RTJ RGJ RJJ RNJ RZJ RXJ RPJ RYJ RWJ RHJ
Timestamp of the last completed session (restore) RTO RGO RJO RNO RZO RXO RPO RYO RWO RHO
Color bar – last 28 days (restore) RTB RGB RJB RNB RZB RXB RPB RYB RWB RHB
Session verification details (restore) RTK RGK RJK RNK RZK RXK RPK RYK RWK RHK
Office 365 protected user accounts (restore) RTM - - - - - - - - -
Office 365 protected shared accounts (restore) RT@ - - - - - - - - -
Protected regular mailboxes (restore) - RGM - - - - - - - -
Protected shared mailboxes (restore) - RG@ - - - - - - - -
Protected user accounts (restore) - - RJM - - - - - - -
Protected grouped accounts (restore) - - RJ@ - - - - - - -

Expressions for active data sources

Short name Full name
"F" Files and Folders
"S" System State
"K" Linux System State
"N" Network Shares
"Q" MS SQL
"X" MS Exchange
"W" VMware
"T" Total
"Z" MS SQL (VSS)
"P" MS SharePoint
"Y" Oracle
"H" MS Hyper-V
"L" MySQL

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

AP=~"*F*" && AP=~"*S*"