📑
Joe's Notes and Links
  • About this site
  • About me
    • Links
    • Awards & Certifications
      • Veeam
      • Kasten
      • AWS
      • Other
      • Planned Certifications
  • Backup Theory
    • Basics Articles
      • I - Why Snapshots Are Not Backups: Understanding the Crucial Differences
      • II - Why Replication is not Backup: Understanding the Differences
      • III - Backup Best Practices: Building a Robust Data Protection Solution
      • IV - Understanding Backup Strategies: Full, Incremental, and Differential Backups
      • V - Understanding RPO and RTO
      • VI - Versioning and Retention Policies: The Backbone of Data Protection Solutions
      • VII - Implementing Backup Scheduling for Optimal Data Protection
      • VIII - Data Classification: A Crucial Pillar in Effective Backup and Recovery Strategies
      • IX - Extending Backup Measurements - Understanding RTO and RTA
    • Terminology
  • Backup Products
    • Veeam
      • Veeam Legends VBR Pocketbook V1
      • PostgreSQL
      • Powershell Scripting (Veeam specific)
        • How to automate Veeam Backup and Replication Global Exclusion Lists
        • Get Result of Backups for one VM for a Year
        • Multitag Jobs
      • Backup & Replication
        • Error "Failed to upgrade host components. Error: 'Minimum supported OS version for Veeam VSS..."
        • [Changed in V11] - Handling of exported and orphaned backups
        • [New in V12] - 2FA Login is not available with expired license
        • Quick Backup of a VM associated to multiple Backup jobs
        • Backup of Windows 10 PC with server managed agent
        • VBR Console – users and roles and job notifications
      • Agents
        • USB Disk as Veeam Repository in a private Environment
      • Veeam and Tape
        • Veeam and Tape I - Moving a tape library with data from one VBR server to another
        • Veeam and Tape II - Moving a tape library with data from one VBR server to another
        • Veeam and Tape III - Restore of Backup Job Files from Tape which were backed up with a File-to-Tape
        • Veeam and Tape IV - Cataloging a tape with a huge number of files
        • Veeam and Tape V - Usage of a S3 compatible Object Storage Gateway
      • Plugins for Enterprise Applications
        • Plugin for Oracle RMAN
          • Veeam RMAN Plugin – Update of Backup Meta Data
          • Veeam RMAN Plugin - ORA-01012 Error
          • Parameter "set-force-delete"
          • Parameter "logsDir"
      • Certification & Accreditation
        • Veeam Certified Architect (VMCA) 2022 - course and exam experience
        • New VMSP and VMTSP 2023 Accreditations available in ProPartner Portal
      • Service Provider Console
        • Deactivate Admins Group
      • Links
      • Miscellaneous
    • Spectrum Protect
      • Links
      • Backup/Archive Client
        • log4j Vulnerability - BA Client Fix and Workaround
  • Storage
    • Storage
      • Links
      • Brocade
        • Useful FOS Commands
  • Virtualization
    • VMware
      • Links
      • PowerCLI
        • How to install VMware PowerCLI offline
        • Prepare the connection to the vCenter
  • Automation and Scripting
    • Powershell scripting
      • Word-wrap PowerShell commands
      • Get Information about Networking
      • Check signature of a DLL
      • Query all VMs with mounted ISO files
      • Dismount all mounted ISO files on a cluster
      • List all Networks of all VMs on a Cluster
      • List all networks on all reachable cluster
  • OS
    • Windows
      • NTP
      • How to install VMware PowerCLI offline
      • Configure MTU Size
    • Linux
      • Routen setzen
  • Cloud
    • AWS
      • Links
  • Databases
    • Links
  • Tools
    • useful Tools and Websites
  • Community
    • Other great blogs/communities
Powered by GitBook
On this page
  • Get Enterprise Manager Information from VBR Database
  1. Backup Products
  2. Veeam

Powershell Scripting (Veeam specific)

Get Enterprise Manager Information from VBR Database

#Query the SQL database to retrieve Enterprise Manager connection info (if any)
$info = Invoke-Sqlcmd -ServerInstance <YOUR_VBR_SQL_INSTANCE_HERE> `
   -query "select value from [Veeambackup].[dbo].[Options] where name = 'EnterpriseServerInfo'"

#Parse and display the info (XML attributes / child nodes) obtained from the database
$([xml]$info.value).ChildNodes

PreviousPostgreSQLNextHow to automate Veeam Backup and Replication Global Exclusion Lists

Last updated 2 years ago