I'm using Microsoft Dynamics (Great Plains) version 10.
I seem to be having some difficulty finding the answer to my question, and hope you can help.
For auditing purposes, I need to query the GP Database in SQL to find users who have not logged into the system for x number of days, months, years, etc. I thought maybe there would be a built-in way in Microsoft SQL to do this, but there surprisingly isn't.
I read in some places about an Activity table, but I don't even have an activity table. I found a table called SY01401, but I don't think that's what I'm looking for.
On a side note, I have an ERD for version 9, but not for version 10. Does anyone know if there's a big difference?
Appreciate any guidance,
Thanks!
I seem to be having some difficulty finding the answer to my question, and hope you can help.
For auditing purposes, I need to query the GP Database in SQL to find users who have not logged into the system for x number of days, months, years, etc. I thought maybe there would be a built-in way in Microsoft SQL to do this, but there surprisingly isn't.
I read in some places about an Activity table, but I don't even have an activity table. I found a table called SY01401, but I don't think that's what I'm looking for.
On a side note, I have an ERD for version 9, but not for version 10. Does anyone know if there's a big difference?
Appreciate any guidance,
Thanks!