Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Business Alert for New...
Microsoft Dynamics GP (Archived)

Business Alert for New User Creation

(0) ShareShare
ReportReport
Posted on by Jim Lines 2

Greetings,
I feel like this question has probably been asked a million times, but I could not find anything in my searches so I'll ask...  Is there a way to set up a Business Alert to notify me when new users are created in GP?  I tried to create this myself but couldn't figure out how to build the formula.  Does anyone know if this is possible?

We do use Rockton's Auditor which is great for reviewing data, but I'd like to have an alert just the same.  Thanks in advance!

Jim

*This post is locked for comments

  • Jim Lines Profile Picture
    Jim Lines 2 on at
    RE: Business Alert for New User Creation

    Jothikrishnan,

    I used the following condition and did get results.  Since I don't need to know realtime, I've set it to look a couple days back.  I'll give yours a try when I have some down time.  Thanks for getting back to me!

    SY01400_T1.CREATDDT > DATEADD(DAY, -2, GETDATE())

    Jim

  • Suggested answer
    Jothi Krishnan N Profile Picture
    Jothi Krishnan N 1,865 on at
    RE: Business Alert for New User Creation

    Jim,

    I just tried and it worked like a charm. BA is nothing but a SQL Job. Did you look at you job and view history?  Is it failing? if so, try to address the errors. BA uses the Database Mail to send notifications. So, make sure you have one setup in SQL with a default profile and is working. Also when you setup a  BA thru Wizard, there is a Test mail option and make sure it sends a test mail. I chose Send Mail and Message with Report option and used the condition SY01400_T1.CREATDDT >= convert(varchar(10),getdate() , 101) .

    scheduled the job to run every 3 mins and it worked like a charm. I created a user and got an email with Text file containing new users.

    Regards,

    Jothikrishnan

  • Jim Lines Profile Picture
    Jim Lines 2 on at
    RE: Business Alert for New User Creation

    Jothikrishnan.

    It's been some time since this advice, but I was just reviewing my business alerts and it appears this didn't work.  I'll try changing things up and see what happens.  Have you implemented this yourself? Any suggestions?

  • Jim Lines Profile Picture
    Jim Lines 2 on at
    RE: Business Alert for New User Creation

    Jothi,

    Thank you so much!  I've set up the BA and will see how it works.  Much appreciated!

    Jim

  • Verified answer
    Jothi Krishnan N Profile Picture
    Jothi Krishnan N 1,865 on at
    RE: Business Alert for New User Creation

    Select the Users Master table from system series and use the formula  SY01400_T1.CREATDDT  =  convert(varchar(10),getdate() , 101) ... 101 is the US date format. I havent tried it completely... but try and let us know if it works for u...

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans