topic SM SQL Command line power shell - how to integrate with Perl? in Data Protection

SM SQL Command line power shell - how to integrate with Perl?

GEEKEGIRL — Thu, 05 Jun 2025 06:49:30 GMT

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.

SM SQL Command line power shell - how to integrate with Perl?

GEEKEGIRL — Tue, 26 Jul 2011 20:32:19 GMT

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>

Re: SM SQL Command line power shell - how to integrate with Perl?

abhisek — Tue, 26 Jul 2011 20:36:17 GMT

Hi ,

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:

◆ new-backup

◆ verify-backup

◆ restore-backup

◆ get-backup

◆ delete-backup

◆ clone-database

◆ clone-backup

◆ delete-clone

◆ import-config

◆ export-config

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:

set-executionpolicy unrestricted

set-executionpolicy remotesigned

Add-PSSnapin NetApp.SnapManager.SQL.PS.Admin -ErrorAction silentlycontinue can be specified in the script.

Regards,

Abhishek

Re: SM SQL Command line power shell - how to integrate with Perl?

abhisek — Tue, 26 Jul 2011 20:36:53 GMT

This is correct.

-Abhishek