• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1658
  • Last Modified:

What table contains company/database name - MS Dynamics GP

I have a customer that uses multiple production GP databases. I'm writing an SSRS report that needs to run over any of the databases. I would like to have the "Company" as a report paramater. I would like the selection to be the same as on the login screen (see attached).
Question: Does anyone know what table or tables contain this information?
login.JPG
0
Bob Hoffman
Asked:
Bob Hoffman
1 Solution
 
reb73Commented:
Not 100% sure, but I think the column [interid] in the table [sy01500] gives you a list of company/db names -

SELECT interid FROM dynamics..sy01500

0
 
Bob HoffmanDeveloperAuthor Commented:
perfect, thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now