_QUERY_

Queries for SimplySQL

Note: The scripts must be stored in a folder named _QUERY_ to use them as queries
The use of the scripts requires the PowerShell Module SimplySQL or SQLServer

• QRY_Get-DMSSIMConnections.ps1

  Lists all SqlConnections

• QRY_Get-DMSSIMGeneric.ps1

  Returns the specified columns from the specified table

• QRY_Get-DMSSQLAgentJobs.ps1

  Gets a SQL Agent Job objects

• QRY_Get-DMSSQLAgentJobSchedules.ps1

  Gets a job schedule objects

• QRY_Get-DMSSQLDatabaseRoles.ps1

  Gets the roles and there mmembers from the SQL database object

• QRY_Get-DMSSQLDatabases.ps1

  Gets the SQL database objects

• QRY_Get-DMSSQLInstanceRoles.ps1

  Gets the roles from the SQL Instance object

• QRY_Get-DMSSQLLogins.ps1

  Get the Login objects in an instance of SQL Server

• QRY_Get-DMSSIMSRReports.ps1

  Returns the ScriptRunner reports in the specified period