Skip to content

Instantly share code, notes, and snippets.

@matejskubic

matejskubic/MsDyn365FO-OnPrem-ServiceFabric-LocalAgent.sql

Created October 10, 2020 11:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save matejskubic/e7e2c209d89c4d30913c8b37187f0083 to your computer and use it in GitHub Desktop.
Save matejskubic/e7e2c209d89c4d30913c8b37187f0083 to your computer and use it in GitHub Desktop.
Download ZIP
Dynamics Finance & Operations - Local data agent diagnostics
Raw
MsDyn365FO-OnPrem-ServiceFabric-LocalAgent.sql
select top 100 *
from DeploymentInstanceArtifact
select top 100 *
from OrchestratorCommand
order by QueuedDateTime desc
select top 100 *
from OrchestratorJob
where CommandId = 'db3e9709-8a9a-4612-a67d-6363003cb1ab'
order by QueuedDateTime
select top 100 *
from RunBookTask
where JobId='prod-db3e9709-8a9a-4612-a67d-6363003cb1ab'
order by StartDateTime desc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment