Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Larry Carrethers]

Is there a way to tell  users who logged into GP for the last 12 months without activity monitoring being on?

——————————
Larry Carrethers
Sr. System Admin/DBA
Dolese Bros. Co.
Oklahoma City OK
——————————

[David Musgrave]

Hi Larry

Not easily if you don’t have any tracking active. The only thing you could look at is the last user to edit and the modified date on various tables.

GP Power Tools can track this information, but it does not keep the logs forever as they would get too large.

Regards

David

——————————
David Musgrave MVP, GPUG All-Star

Managing Director
Winthrop Development Consultants

Perth, Western Australia

http://www.winthropdc.com
——————————
——————————————-

[Larry Carrethers]

Is there a way I can pull a report of all users and there security roles in GP?

 

Larry Carrethers Senior System Administrator / DBA Information Technology Department Phone: +1-405-297-8383 http://www.dolese.com

NOTICE OF CONFIDENTIALITY: The information contained in this transmission including any attached documentation is privileged and confidential. It is intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copy of this communication is strictly prohibited. If you have received this communication in error, please notify Dolese Bros. Co. immediately by replying to this email,and please delete all copies of this message and any attachments immediately.

——————————————-

[Ryan Galang]

HI Larry,

You can try the User Security report.

——————————
Ryan Galang
BTP Technologies LLC
CHANTILLY VA
——————————
——————————————-

[Blair Christensen]

You can use this from Victoria Yudin’s website:

/**
view_Security_Roles_and_Tasks
Created Mar 12 2009 by Victoria Yudin - Flexible Solutions, Inc.
For updates see https://victoriayudin.com/gp-reports/
Shows all security roles and tasks by user by company
**/

SELECT S.USERID UserID
, U.USRCLASS
, CASE U.UserStatus
WHEN 1 THEN 'Active'
WHEN 2 THEN 'Inactive'
ELSE 'Unknown'
END as UserStatus
, U.SQLLoginID
, S.CMPANYID CompanyID
, C.CMPNYNAM CompanyName
, S.SECURITYROLEID
, coalesce(T.SECURITYTASKID,'') SecurityTaskID
, coalesce(TM.SECURITYTASKNAME,'') SecurityTaskName
, coalesce(TM.SECURITYTASKDESC,'') SecurityTaskDescription

FROM SY10500 S -- security assignment user role
-- company master
LEFT OUTER JOIN SY01500 C ON S.CMPANYID = C.CMPANYID
-- tasks in roles
LEFT OUTER JOIN SY10600 T ON S.SECURITYROLEID = T.SECURITYROLEID
-- tasks master
LEFT OUTER JOIN SY09000 TM ON T.SECURITYTASKID = TM.SECURITYTASKID
-- users
LEFT OUTER JOIN SY01400 U on S.USERID = U.USERID
--where S.USERID = 'MICHAELEV'
where T.SECURITYTASKID LIKE 'INQ_FIN_004%'

——————————
Blair Christensen
Database Administrator
Oppenheimer Companies, Inc.
Boise Idaho GPUG Chapter Leader
——————————
——————————————-

[Larry Carrethers]

Thank you, this is exactly what I was looking for.

 

——————————————-

[Blair Christensen]

There is nothing built into GP which will do this, though there are several third party products which could do it.  If you’re really good with Triggers, you could put one on the ACTIVITY or DEX_SESSION tables which logs to your own table.

——————————
Blair Christensen
Database Administrator
Oppenheimer Companies, Inc.
Boise Idaho GPUG Chapter Leader
——————————
——————————————-