Skip to content

Files

Latest commit

HaraldPfirmannHaraldPfirmann
Renaming
Mar 19, 2024
a273c73 · Mar 19, 2024

History

History

DBSystems

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
SQLServer
SQLServer
Oct 26, 2020
Samples
Samples
Oct 26, 2020
SimplySQL
SimplySQL
Dec 11, 2019
_LIB_
_LIB_
Oct 2, 2019
_QUERY_
_QUERY_
Mar 19, 2024
_REPORTS_
_REPORTS_
Jun 30, 2020
README.md
README.md
Feb 25, 2020

README.md

Action Pack for Database management systems

LIB

  • Open SQL Connection with SimplySQL
  • Close connection with SimplySQL
  • Invoke SQL, update, scalar queries with SimplySQL
  • Get SQL instance with SQLServer
  • Get SQL database with SQLServer

Queries

  • Get all connections with SimplySQL
  • Get specified columns from the specified table with SimplySQL
  • Get ScriptRunner-Reports from the ScriptRunner database with SimplySQL
  • Get databases with SQL Server
  • Get instance roles or database roles with SQL Server
  • Get agent jobs or agent job schedules with SQL Server
  • Get Login objects with SQL Server

Samples

  • Get error statistic, runtime report, usage report, reports from ScriptRunner database with SimplySQL

SimplySQL

  • Open SQL Connection
  • Get/close connections
  • Invoke SQL, update, scalar queries

SQL Server

  • Get, start, stop SQL instance
  • Configure authentication mode of SQL instance
  • Add, get, remove SQL instance role members
  • Add, get, remove SQL login
  • Get, set, test SQL Smart Admin object
  • Get, backup, restore database
  • Backup, restore Analysis Service database
  • Add, get, remove SQL database role members
  • Read, write table data
  • Read view data
  • Invoke run a script supported by the SQL Server SQLCMD utility
  • Add, get, set, remove SQL credential
  • Add, get, remove SQL role members
  • Get backup history
  • Get, set error log
  • Get, agent, agent schedule
  • Get, agent job, agent job step, agent job schedule, agent job history
  • Add, remove firewall rule
  • Add, get, remove column master key
  • Add, get, remove column encryption key
  • Enable, disable the Always On availability groups feature
  • Encrypt, decrypt, or re-encrypt specified columns in the database
  • Generate In-Memory OLTP Migration Checklist

Reports

  • Generate report with databases, database roles, instance roles, agent jobs