• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1643
  • 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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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