Skip to content
Permalink
Branch: master
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
21 lines (21 sloc) 593 Bytes
SELECT [TaskID]
,CONVERT
(
VARCHAR(MAX),
CAST('' AS XML).value('xs:base64Binary(sql:column("ClientNotificationMessage"))', 'VARBINARY(MAX)')
) 'ClientNotificationMessage'
,[ScriptGuid]
,[ScriptName]
,[ScriptVersion]
,[Feature]
,[ClientOperationId]
,[CollectionId]
,[TotalClients]
,[LastUpdateTime]
,[OverallScriptExecutionState]
,[OfflineClients]
,[UnknownClients]
,[NotApplicableClients]
,[FailedClients]
,[CompletedClients]
FROM [CM_PS1].[dbo].[vSMS_ScriptsExecutionTask]
You can’t perform that action at this time.