Dynamics GP - Auto Enable Activity Tracking - Expose log through smartlist builder

--------------------------------------------------

Set on a job schedule to run as often as you need to check for new users

---------------------------------------------------

update Dynamics.dbo.SY60100

set TRKUSER = 1

where TRKUSER = 0

print 'Changed : ' + str ( @@ROWCOUNT )

-------------------------------------------

Create smartlist

--------------------------------------------

select * from dynamics.dbo.sy05000

Give permission to SQL object

Give permission to smartlist object

Give GP permission to view smartlists with sql data

Give GP permission to Smartlist