Data Backup and Recovery Discussions
I want to write a perl script to scrape the get-backup output to report on basic backup information. (No I don't want to use the GUI for lots of reasons).
How do you interface with the Power Shell from a DOS prompt? If I can run the commands from a DOS prompt I can run the commands with Perl.
What I'm ultimately trying to do is gather information about the backups, send an SNMP trap to our monitoring system if it fails and upload the information to a centralized reporting database.
Thanks in advance.
Answering my own question.
c:\Program Files\NetApp\SnapManager for SQL Server>C:\Windows\System32\WindowsPo
werShell\v1.0\powershell.exe -psconsolefile "c:\program files\netapp\snapmanager
for sql server\SmsqlShell.psc1" -command get-backup -server <SERVER> -INST <INSTANCE>
SnapManager 5.1 supports the new SnapManager command-line functionality called cmdlet, through SnapManager PowerShell.
This SnapManager commandline interface enables you to execute the following operations:
Also make sure to Enter the command get-executionpolicy in PowerShell.
If the policy displayed is “Allsigned” or “Restricted”, enter any of the following commands:
Add-PSSnapin NetApp.SnapManager.SQL.PS.Admin -ErrorAction silentlycontinue can be specified in the script.
This is correct.