Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

What table contains company/database name - MS Dynamics GP

Posted on 2009-05-14
2
1,613 Views
Last Modified: 2012-05-07
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
Comment
Question by:Bob Hoffman
2 Comments
 
LVL 25

Accepted Solution

by:
reb73 earned 500 total points
ID: 24385874
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
 
LVL 8

Author Closing Comment

by:Bob Hoffman
ID: 31581462
perfect, thanks!
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This collection of functions covers all the normal rounding methods of just about any numeric value.
Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question