Yeah I was eventually able to create a report using the UserFile table. Its probably not the best way to do it, but it does give me the info that I need.
Thanks for all of your help!
Dustin Biniek
________________________________
From: pbparker <scrumbus@...>
To: vantage@yahoogroups.com
Sent: Thu, April 22, 2010 12:53:53 PM
Subject: [Vantage] Re: Security Groups
Â
I'm using Progress (could likely work for SQL too).
I have a Crystal Report that queries through ODBC to the tables and generates a report listing all the security groups and then displays all the users within the security group.
I could post the Crystal, but it has my ODBC source name, so you'd have to set up a ODBC source of the same name - that or take what you see and recreate it. Either way, if someone wants it I could always email it to ya as well.
Basically, top level report queries SecGroup table, then a subreport withint it queries the UserFile table. For each user it splits the GroupList into an array and compares each value to that of the current group. I use a suppression rule on the detail line to suppress the line if there is no match.
The suppression formula is:
NumberVar intArrayLimit;
NumberVar i;
NumberVar hit;
StringVar array aGroupList;
StringVar GroupString;
aGroupList := split({Command. GroupList} ,"~");
intArrayLimit := Count(aGroupList) ;
// Try looping through array
i := 1;
hit := 0;
GroupString := "";
while i <= intArrayLimit do
(
If aGroupList[i] = {?Pm-Command. SecGroupCode} Then
hit := 1;
i := i + 1;
);
If hit = 0 Then
true;
Thanks for all of your help!
Dustin Biniek
________________________________
From: pbparker <scrumbus@...>
To: vantage@yahoogroups.com
Sent: Thu, April 22, 2010 12:53:53 PM
Subject: [Vantage] Re: Security Groups
Â
I'm using Progress (could likely work for SQL too).
I have a Crystal Report that queries through ODBC to the tables and generates a report listing all the security groups and then displays all the users within the security group.
I could post the Crystal, but it has my ODBC source name, so you'd have to set up a ODBC source of the same name - that or take what you see and recreate it. Either way, if someone wants it I could always email it to ya as well.
Basically, top level report queries SecGroup table, then a subreport withint it queries the UserFile table. For each user it splits the GroupList into an array and compares each value to that of the current group. I use a suppression rule on the detail line to suppress the line if there is no match.
The suppression formula is:
NumberVar intArrayLimit;
NumberVar i;
NumberVar hit;
StringVar array aGroupList;
StringVar GroupString;
aGroupList := split({Command. GroupList} ,"~");
intArrayLimit := Count(aGroupList) ;
// Try looping through array
i := 1;
hit := 0;
GroupString := "";
while i <= intArrayLimit do
(
If aGroupList[i] = {?Pm-Command. SecGroupCode} Then
hit := 1;
i := i + 1;
);
If hit = 0 Then
true;
--- In vantage@yahoogroups .com, "Ross Hughes" <ross.hughes@ ...> wrote:
>
> I ended up creating a couple of modules in an Access db that auto-execute on
> load and recreates the table in Access with a normalized structure. The
> Access reports are then run from these new local tables.
>
> This does require a read-only ODBC source but takes a lot of the
> security-reporting pain away.
>
> It can be done just as easily in a stored procedure if you are a SQL user.
> Then you could tie a Crystal report to a Vantage menu.
>
> Let me know if you want more information on this.
>
> Ross
>
> -----Original Message-----
> From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
> Brian W. Spolarich
> Sent: Wednesday, April 21, 2010 3:56 PM
> To: vantage@yahoogroups .com
> Subject: RE: [Vantage] Security Groups
>
> The data is stored in the Userfile table. Grouplist contains a
> ~-separated list of SecGroup IDs that the user belongs to.
>
> So its kind of hard to work with. It easy to say "show me which groups a
> user belongs to", but hard to go the other way.
>
> I'm not sure how to do this in MSSQL, but I'm curious enough to
> investigate.
>
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
> Picometrix
> Â Â Â Â bspolarich@. .. ~ 734-864-5618 ~
> www.advancedphotoni x.com
>
>
> -----Original Message-----
> From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
> melissa hietala
> Sent: Wednesday, April 21, 2010 3:54 PM
> To: vantage@yahoogroups .com
> Subject: [Vantage] Security Groups
>
> Anyone have any thoughts on this????
> Â At a quick glance, how can IÂ get a list of users that belong to a
> particular security group.
>
> Or what tables is this information held in so that I can create a report on
> it?
>
> Thanks,
> Â
> Dustin Biniek
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------ --------- --------- ------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups. yahoo.com/ group/vantage/ files/.
> (2) To search through old msg's goto:
> http://groups. yahoo.com/ group/vantage/ messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links
>
>
>
>
>
> ------------ --------- --------- ------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups. yahoo.com/ group/vantage/ files/.
> (2) To search through old msg's goto:
> http://groups. yahoo.com/ group/vantage/ messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links
>
[Non-text portions of this message have been removed]