Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Proposition: Add cmdlets to reset the MR DataMart #514

Open
valerymoskalenko opened this issue Feb 24, 2021 · 1 comment
Open

Proposition: Add cmdlets to reset the MR DataMart #514

valerymoskalenko opened this issue Feb 24, 2021 · 1 comment

Comments

@valerymoskalenko
Copy link

It would be nice to have a couple of cmdlets to reset Financial Reports DataMart and to see the current status of integration.

Invoke-D365DataMartReset

I prefer using SQL scripts provided here https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/reset-financial-reporting-datamart-after-restore#reset-the-financial-reporting-data-mart-for-dynamics-365-finance--operations-on-premises-through-sql-server-management-studio

Get-D365DataMartIntegration

select ReaderObjectName, WriterObjectName, LastRunTime, StateType from Connector.MapsWithDetail with (nolock)
@Splaxi
Copy link
Collaborator

Splaxi commented Feb 24, 2021

That is a great idea and thanks for the pointers!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@Splaxi @valerymoskalenko