Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Henrik Jensen]

Does anybody do this….

I have 50 companies, and I need to get daily status of the “Update currency Exchange rates” has status “Succes” or not.

Can this be done with powershell ?

——————————
Henrik Jensen
IT Chief
Ocean Prawns A/S
——————————

[Saurav Dhyani]

Hi,

I doubt that it can be done via PowerShell but if you are using NAV 2017 or higher you can use task scheduler to achieve similar results.

You can create a task via code in NAV/BC and then you can decide the output method in code. It can be an e-mail, a file or any other way you can think of.

How to use task scheduler – https://docs.microsoft.com/en-us/dynamics-nav/task-scheduler

——————————
Saurav Dhyani
ArcherPoint Inc.
Duluth
Blog – https://saurav-nav.blogspot.com
——————————
——————————————-

[Henrik Jensen]

Thanks.

I build a report, that get status from all companies, the last 7 days.

/Henrik

——————————
Henrik Jensen
IT Chief
Ocean Prawns A/S
——————————
——————————————-

[Mathew Ealy]

You could do this with powershell if you call sql from shell. Then feed the data to a simple html page to show green or red per company. I could see something like that being useful to manage 50 companies status for a number of different statuses.

——————————
Mathew Ealy
Nav Support Specialist
Rentokil N. America
Reading PA
——————————
——————————————-