Backup Management Console column codes for API

When using certain JSON-RPC API methods, you may be given or asked for column vectors or column codes and data source codes.

Please note, the old legacy shortnames will still work for the time being, but we would strongly recommend you change the API methods to use the below notations as soon as possible.

Example

If you want to output the information from the creation date, computer name, used storage and active data sources columns for a list of devices. Use the Enumerating Account Statistics method.

Using the "Columns" parameter in the old notation, this would be written as:

"Columns": ["CD", "MN", "US", "AP"],

Using the new notation, you are simply replacing "CD", "MN", "US" and "AP" with "I4", "I18", "I14" and "I78". This would mean the parameter in your JSON call now looks as below:

"Columns": ["I4", "I18", "I14", "I78"],

The response showing this information will be displayed as:

"Settings": [
    {
	"I4": "1536906195"
    },
    {
	"I18": "ComputerName1"
    },
    {
	"I14": "188702358870"
    },
    {
	"I78": "D01"
    }
]

Column Codes

See the list of SolarWinds Backup column codes below:

Primary device properties

Column Title New ID Legacy Shortname Type of data
Device ID I0 AU String
Device name I1 AN String
Device name alias I2 AL String
Password I3 QW String
Creation date I4 CD Time
Expiration date I5 ED Time
Status Code I7 ST String
Customer I8 AR String
Product ID I9 PD Int
Product I10 PN String
Email I15 EM String
Retention units I39 RU String
Profile ID I54 OI Int

Installation details

Column Title New ID Legacy Shortname Type of data
OS version ? I16 OS String
Client version I17 VN String
Computer name I18 MN String
Internal IPs I19 IP String
MAC address I21 MA String
Time offset I24 TZ Number
OS type ? I32 OT
  • 1 – workstation
  • 2 – server
  • 0 – undefined
Computer manufacturer I44 MF String
Computer model I45 MO String
Installation ID I46 II String
Installation Mode I47 IM Int
Unattended Installation account ID I74 AI String
First Installation Flag I75 IF Int

Storage info

Column Title New ID Legacy Shortname Type of data
Storage location ? I11 LN String
Used storage I14 US Size
Cabinet Storage Efficiency I26 SE Int
Total Cabinets Count I27 CC Int
Efficient Cabinet Count 0-25 I28 E0 Int
Efficient Cabinet Count 26-50 I29 E1 Int
Efficient Cabinet Count 50-75 I30 E2 Int
Used Virtual Storage I31 UV Size
Storage status I36 YS
  • -2 – Offline
  • -1 – Failed
  • 0 – Undefined
  • 50 – Running
  • 100 – Synchronized

Feature usage

Column Title New ID Legacy Shortname Type of data
Active data sources I25 AP String (Only use old notation for data sources)
Active data sources (NEW!) I78 -- String (Only use new notation for data sources)
Seeding mode I33 IS
  • 0 – Undefined
  • 1 – Normal
  • 2 – Seeding
  • 3 – PreSeeding
  • 4 – PostSeeding
LSV ? I35 VE
  • 0 – Disabled
  • 1 – Enabled
LSV status I37 YV
  • -2 – Offline
  • -1 – Failed
  • 0 – Undefined
  • 50 – Running
  • 100 – Synchronized
SBI ? I51 IE
  • 0 – Disabled
  • 1 – Enabled
SBI status I52 IT
  • 1 – In process
  • 2 – Failed
  • 3 – Aborted
  • 5 – Completed
  • 6 – Interrupted
  • 7 – NotStarted
  • 8 – CompletedWithErrors
  • 9 – InProgressWithFaults
  • 10 – OverQuota
  • 11 – NoSelection
  • 12 – Restarted

Data source statistics fields

Column title NeW ID Legacy Shortname Type of data
Last Session Status F00 0
  • 1 – In process
  • 2 – Failed
  • 3 – Aborted
  • 5 – Completed
  • 6 – Interrupted
  • 7 – NotStarted
  • 8 – CompletedWithErrors
  • 9 – InProgressWithFaults
  • 10 – OverQuota
  • 11 – NoSelection
  • 12 – Restarted
Last Session Selected Count F01 1 Int
Last Session Processed Count F02 2 Int
Last Session Selected Size F03 3 Size
Last Session Processed Size F04 4 Size
Last Session Sent Size F05 5 Size
Last Session Errors Count F06 7 Int
Protected size F07 6 Size
Color bar – last 28 days F08 B ColourBar
Last successful session Timestamp F09 L Time
Pre Recent Session Selected Count F10 8 Int
Pre Recent Session Selected Size F11 9 Size
Session duration F12 A Int
Last Session License Items count ? F13 I Int
Retention F14 R Int
Last Session Timestamp F15 G Time
Last Successful Session Status F16 Q Status
Last Completed Session Status F17 J Status
Last Completed Session Timestamp F18 O Time
Last Session Verification Data F19 K String
Last Session User Mailboxes Count F20 M Int
Last Session Shared Mailboxes Count ? F21 @ Int

Company Information

Column Title New ID Legacy Shortname Type of data
Company Name I63 NC String
Address I64 AD String
Zip Code I65 ZP String
Country I66 CY String
City I67 CT String
Phone Number I68 PH String
Fax Number I69 FX String
Contract Name I70 CP String
Group Name I71 GN String
Demo I72 DE Int
Edu I73 EU Int
Maximum Allowed Version I76 MV String

Miscellaneous

Column Title New ID Legacy Shortname Type of data
Timestamp I6 TS Unix time
Device group name I12 AG String
Own user name I13 OU String
External IPs I20 EI String
Dashboard frequency I22 DF Bitmask
Dashboard language I23 DL String
Anti Crypto enabled I34 AC Int
Archived size I38 AS String
Activity description I40 DS String
Number of Hyper-V virtual machines I41 HN String
Number of ESX virtual machines I42 EN String
Encryption status I43 ES String
Restore email I48 REM String
Restore dashboard frequency I49 RDF Bitmask
Restore dashboards language I50 RDL String
Statistics Type I53 SK Int
Profile version I55 OV String
Profile I56 OP String
Stock Keeping Unit I57 KU String
Stock Keeping Unit of the previous month I58 PU String
Account type I59 AT String
Proxy Type I60 PT Int
Effective Bandwidth I61 B2 Int
Most Recent Restore Plugin I62 RP String
Customer reference I77 PF String

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

Expressions for active data sources

Full Name New ID Legacy Shortname
Files and Folders D01 F
System State D02 S
MsSql D03 Q
VssExchange D04 X
Microsoft 365 SharePoint D05 --
NetworkShares D06 N
VssSystemState D07 S
VMware Virtual Machines D08 W
Total D09 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
Linux System State D18 K
Microsoft 365 Exchange D19 G
Microsoft 365 OneDrive D20 J
Removable Media -- R