VConnectSqlDb.psm1
# Instal Pre-Req Modules Invoke-InstallOrUpdateModule 'SqlServer' function Get-VConnectDbDeployments { param($name, $dbName, [int] $top = 100) $query = "SELECT TOP ($top) [DeploymentId] ,[DeploymentName] ,[OwnerId] ,[OwnerEmailId] ,[StatusString] ,[Status] ,[Message] ,[Exception] ,[CreatedOn] ,[StartTime] ,[CompletedTime] ,[AssignedAgentId] ,[ResourceId] ,[ResourceType] ,[ResourceName] ,[DeploymentRequestId] ,[UpdatedTime] FROM [dbo].[Deployments]" Invoke-SqlDbQuery $name $query $dbName } |