slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Reporting & Notification Forums - Reporting
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Reporting | New Thread

View: Search:

Author

Thread: Group Owner and Rights

Veronka Capone
Posts: 113

Group Owner and Rights Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 28 Nov 07 7:58 AM

Hi all,

I am doing some DB/group cleanup... There is any way to get a list of all groups, owner, Released To, kind of report? If not, which tables should I look into to get this info?

I would like to have something like this:

FamilyName GroupName Owner/ReleasedTo CreatedDate LastUsed???
-------------------------------------------------------------------------------------------------------------------------------------------------
ACCOUNT HighLeads Admin/Everyone 01/01/2007 11/01/2007

Can anyone point me in the right direction?

Thanks.

[Reply][Quote]

David Henry
Posts: 207

Re: Group Owner and Rights Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 29 Nov 07 8:30 AM

There are a few ways to do this:

hard way:
In the SalesLogix client you can use MANAGE GROUPS.

easy way:
Use the E1 User Groups utility. Export to excel features and most everything you are looking for. You can thank Declan Hillier and Mike Spragg for this tool. Here's the link:
http://www.slxdeveloper.com/page.aspx?action=viewarticle&articleid=72

[Reply][Quote]

Veronka Capone
Posts: 113

Re: Group Owner and Rights Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 29 Nov 07 11:06 AM

Thanks David,

It is not quite what I am looking for...
I need one level up info: All groups which are using X table, groupped by family, Created by whom and released to whom.
So, I did my own query (PLUGIN, SECCODE, USERINFO) tables to get the info what I need. It is almost working for what I need now...

It is not the best solution, but i won't use it often.

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/25/2024 12:24:21 PM