Pull From SQL not XML

Just going through the Data Dictionary, and viewing the data in the
tables using Excel, I found that you will need info from 2-3 tables.
We are on Progress, but I would assume the tables would still be
available to SQL.

UserFile contains data about the users. The GroupList is a delimited
multi-value field containing all group memberships for the user.

Security is a table that contains all information about securable
resources (menus, process, etc...). The field entrylist is comma
delemited, and cotains any of the security groups, or users that have
permissions to that object. I assume * means everyone has access. The
field NoEntryList contains users that are denied access.

The SecGroup table contains each of the group codes, and their
description.

I hope this helps.
Craig

--- In vantage@yahoogroups.com, "Chris" <cryhal@...> wrote:
>
> The information within the data definition is of the tables to be
> creatd with the newly populated XML file generated. I need a menu
> security report to pull everything direct from SQL. I can't see to
> find where the data is coming from. I can't seem to figure out,
how
> you link the user DCDUSERID to what menu's they have access too.
>
> --- In vantage@yahoogroups.com, "Craig Weiss" <cweiss@> wrote:
> >
> > Chris,
> > We are still running 8.03.305, so I don't have access to the
report
> > you are looking at, but generally the .xml defenition is held
under
> > System Management > Company Config > Report Data Defenition. Less
> > frequently, they will be under Executive Management > Business
> > Activity Management > General Operations > BAQ Report Designer
> > Good Luck,
> > Craig
> >
> > --- In vantage@yahoogroups.com, "Chris" <cryhal@> wrote:
> > >
> > > Dave,
> > >
> > > I appreciate your help. I actually DID try your report while
> > digging
> > > through user files :)
> > >
> > > I had to modify for a SQL 2005 connection as yours was directed
> > > towards OpenEdge, but, I think I got the same outcome as you
did.
> > >
> > > I basically need the report to look like so:
> > >
> > > UserName
> > > <Menus User Can Access>
> > >
> > > via grouping like you used in your report. I don't think your
> > > report had that exact outcome.
> > >
> > > If I could simply figure out where the XML for the default menu
> > > security report is generated from I think I could get it. I
need
> > to
> > > be able to run the report out of Vantage for other reasons.
> > >
> > > Thanks,
> > > Chris
> > >
> > >
> > > --- In vantage@yahoogroups.com, "Dave Olender" <dolender@>
wrote:
> > > >
> > > > Mr. Chris: 8.03.404 has a security report that you can run.
> > > However
> > > > I put together a crystal report that can work as an interim
> > > solution.
> > > >
> > > > It's in the files->Crystal Reports->Menu001-MenuSecurity.rpt
of
> > > this
> > > > newsgroup. It's not as nice as the Epicor 8.03.404 report,
but
> > is
> > > > better than nothing.
> > > >
> > > > The tables to use are Menu and security. The tables need to
be
> > > > loaded recursively (or as aliases at least that's the only
way
> I
> > > know
> > > > how to do it).
> > > >
> > > > Good Luck,
> > > >
> > > > Dave Olender
> > > > dolender@
> > > > Ph: 651-246-3281
> > > >
> > > >
> > > >
> > > > --- In vantage@yahoogroups.com, "Chris" <cryhal@> wrote:
> > > > >
> > > > > I am looking for a simple SQL query to pull the menu
security
> > > > details,
> > > > > IE: Who has access to what.
> > > > >
> > > > > I need to do this direct ODBC and not from the XML that is
> > > > generated
> > > > > from Vantage. Anyone have a quick solution to this?
> > > > >
> > > > > Also, is there an easy way to find out what tables in SQL
the
> > XML
> > > > is
> > > > > generated from?
> > > > >
> > > >
> > >
> >
>
I am looking for a simple SQL query to pull the menu security details,
IE: Who has access to what.

I need to do this direct ODBC and not from the XML that is generated
from Vantage. Anyone have a quick solution to this?

Also, is there an easy way to find out what tables in SQL the XML is
generated from?
FYI, I am running 8.03.403d

--- In vantage@yahoogroups.com, "Chris" <cryhal@...> wrote:
>
> I am looking for a simple SQL query to pull the menu security
details,
> IE: Who has access to what.
>
> I need to do this direct ODBC and not from the XML that is generated
> from Vantage. Anyone have a quick solution to this?
>
> Also, is there an easy way to find out what tables in SQL the XML is
> generated from?
>
Mr. Chris: 8.03.404 has a security report that you can run. However
I put together a crystal report that can work as an interim solution.

It's in the files->Crystal Reports->Menu001-MenuSecurity.rpt of this
newsgroup. It's not as nice as the Epicor 8.03.404 report, but is
better than nothing.

The tables to use are Menu and security. The tables need to be
loaded recursively (or as aliases at least that's the only way I know
how to do it).

Good Luck,

Dave Olender
dolender@...
Ph: 651-246-3281



--- In vantage@yahoogroups.com, "Chris" <cryhal@...> wrote:
>
> I am looking for a simple SQL query to pull the menu security
details,
> IE: Who has access to what.
>
> I need to do this direct ODBC and not from the XML that is
generated
> from Vantage. Anyone have a quick solution to this?
>
> Also, is there an easy way to find out what tables in SQL the XML
is
> generated from?
>
Dave,

I appreciate your help. I actually DID try your report while digging
through user files :)

I had to modify for a SQL 2005 connection as yours was directed
towards OpenEdge, but, I think I got the same outcome as you did.

I basically need the report to look like so:

UserName
<Menus User Can Access>

via grouping like you used in your report. I don't think your
report had that exact outcome.

If I could simply figure out where the XML for the default menu
security report is generated from I think I could get it. I need to
be able to run the report out of Vantage for other reasons.

Thanks,
Chris


--- In vantage@yahoogroups.com, "Dave Olender" <dolender@...> wrote:
>
> Mr. Chris: 8.03.404 has a security report that you can run.
However
> I put together a crystal report that can work as an interim
solution.
>
> It's in the files->Crystal Reports->Menu001-MenuSecurity.rpt of
this
> newsgroup. It's not as nice as the Epicor 8.03.404 report, but is
> better than nothing.
>
> The tables to use are Menu and security. The tables need to be
> loaded recursively (or as aliases at least that's the only way I
know
> how to do it).
>
> Good Luck,
>
> Dave Olender
> dolender@...
> Ph: 651-246-3281
>
>
>
> --- In vantage@yahoogroups.com, "Chris" <cryhal@> wrote:
> >
> > I am looking for a simple SQL query to pull the menu security
> details,
> > IE: Who has access to what.
> >
> > I need to do this direct ODBC and not from the XML that is
> generated
> > from Vantage. Anyone have a quick solution to this?
> >
> > Also, is there an easy way to find out what tables in SQL the XML
> is
> > generated from?
> >
>
Chris,
We are still running 8.03.305, so I don't have access to the report
you are looking at, but generally the .xml defenition is held under
System Management > Company Config > Report Data Defenition. Less
frequently, they will be under Executive Management > Business
Activity Management > General Operations > BAQ Report Designer
Good Luck,
Craig

--- In vantage@yahoogroups.com, "Chris" <cryhal@...> wrote:
>
> Dave,
>
> I appreciate your help. I actually DID try your report while
digging
> through user files :)
>
> I had to modify for a SQL 2005 connection as yours was directed
> towards OpenEdge, but, I think I got the same outcome as you did.
>
> I basically need the report to look like so:
>
> UserName
> <Menus User Can Access>
>
> via grouping like you used in your report. I don't think your
> report had that exact outcome.
>
> If I could simply figure out where the XML for the default menu
> security report is generated from I think I could get it. I need
to
> be able to run the report out of Vantage for other reasons.
>
> Thanks,
> Chris
>
>
> --- In vantage@yahoogroups.com, "Dave Olender" <dolender@> wrote:
> >
> > Mr. Chris: 8.03.404 has a security report that you can run.
> However
> > I put together a crystal report that can work as an interim
> solution.
> >
> > It's in the files->Crystal Reports->Menu001-MenuSecurity.rpt of
> this
> > newsgroup. It's not as nice as the Epicor 8.03.404 report, but
is
> > better than nothing.
> >
> > The tables to use are Menu and security. The tables need to be
> > loaded recursively (or as aliases at least that's the only way I
> know
> > how to do it).
> >
> > Good Luck,
> >
> > Dave Olender
> > dolender@
> > Ph: 651-246-3281
> >
> >
> >
> > --- In vantage@yahoogroups.com, "Chris" <cryhal@> wrote:
> > >
> > > I am looking for a simple SQL query to pull the menu security
> > details,
> > > IE: Who has access to what.
> > >
> > > I need to do this direct ODBC and not from the XML that is
> > generated
> > > from Vantage. Anyone have a quick solution to this?
> > >
> > > Also, is there an easy way to find out what tables in SQL the
XML
> > is
> > > generated from?
> > >
> >
>
The information within the data definition is of the tables to be
creatd with the newly populated XML file generated. I need a menu
security report to pull everything direct from SQL. I can't see to
find where the data is coming from. I can't seem to figure out, how
you link the user DCDUSERID to what menu's they have access too.

--- In vantage@yahoogroups.com, "Craig Weiss" <cweiss@...> wrote:
>
> Chris,
> We are still running 8.03.305, so I don't have access to the report
> you are looking at, but generally the .xml defenition is held under
> System Management > Company Config > Report Data Defenition. Less
> frequently, they will be under Executive Management > Business
> Activity Management > General Operations > BAQ Report Designer
> Good Luck,
> Craig
>
> --- In vantage@yahoogroups.com, "Chris" <cryhal@> wrote:
> >
> > Dave,
> >
> > I appreciate your help. I actually DID try your report while
> digging
> > through user files :)
> >
> > I had to modify for a SQL 2005 connection as yours was directed
> > towards OpenEdge, but, I think I got the same outcome as you did.
> >
> > I basically need the report to look like so:
> >
> > UserName
> > <Menus User Can Access>
> >
> > via grouping like you used in your report. I don't think your
> > report had that exact outcome.
> >
> > If I could simply figure out where the XML for the default menu
> > security report is generated from I think I could get it. I need
> to
> > be able to run the report out of Vantage for other reasons.
> >
> > Thanks,
> > Chris
> >
> >
> > --- In vantage@yahoogroups.com, "Dave Olender" <dolender@> wrote:
> > >
> > > Mr. Chris: 8.03.404 has a security report that you can run.
> > However
> > > I put together a crystal report that can work as an interim
> > solution.
> > >
> > > It's in the files->Crystal Reports->Menu001-MenuSecurity.rpt of
> > this
> > > newsgroup. It's not as nice as the Epicor 8.03.404 report, but
> is
> > > better than nothing.
> > >
> > > The tables to use are Menu and security. The tables need to be
> > > loaded recursively (or as aliases at least that's the only way
I
> > know
> > > how to do it).
> > >
> > > Good Luck,
> > >
> > > Dave Olender
> > > dolender@
> > > Ph: 651-246-3281
> > >
> > >
> > >
> > > --- In vantage@yahoogroups.com, "Chris" <cryhal@> wrote:
> > > >
> > > > I am looking for a simple SQL query to pull the menu security
> > > details,
> > > > IE: Who has access to what.
> > > >
> > > > I need to do this direct ODBC and not from the XML that is
> > > generated
> > > > from Vantage. Anyone have a quick solution to this?
> > > >
> > > > Also, is there an easy way to find out what tables in SQL the
> XML
> > > is
> > > > generated from?
> > > >
> > >
> >
>