Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Mass removal of old ta...
Microsoft Dynamics GP (Archived)

Mass removal of old tasks in GP

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I have a bunch of old cnv_ roles that I want to delete.  I know I can delete them one at a time, but it is there an easy way to delete them at all once? 

Would there be a problem with doing it in SQL?  If not, which table should I look in?

 

Thanks

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Mass removal of old tasks in GP

    I ended up doing this

    select * from DYNAMICS.dbo.SY10700 where SECURITYTASKID like 'CNV%'

    select * from DYNAMICS.dbo.SY09000 where SECURITYTASKID like 'CNV%'

    select * from DYNAMICS.dbo.SY10600 where SECURITYROLEID like 'CNV%'

    select * from DYNAMICS.dbo.SY09100 where SECURITYROLEID like 'CNV%'

    select * from DYNAMICS.dbo.SY10500 where SECURITYROLEID like 'CNV%'

    select * from DYNAMICS.dbo.SY10800 where SECMODALTID like 'CNV%'

    select * from DYNAMICS.dbo.SY09200 where SECMODALTID like 'CNV%'

    select * from DYNAMICS.dbo.SY10550 where SECMODALTID like 'CNV%'

    To remove the records created during the security conversion, you can use the user interface to manually delete the added tasks and roles or you can use the following SQL scripts:

    SQL Scripts to remove records created by the v10.0 Security Conversion Tool

    delete from DYNAMICS.dbo.SY10700 where SECURITYTASKID like 'CNV%'

    delete from DYNAMICS.dbo.SY09000 where SECURITYTASKID like 'CNV%'

    delete from DYNAMICS.dbo.SY10600 where SECURITYROLEID like 'CNV%'

    delete from DYNAMICS.dbo.SY09100 where SECURITYROLEID like 'CNV%'

    delete from DYNAMICS.dbo.SY10500 where SECURITYROLEID like 'CNV%'

    delete from DYNAMICS.dbo.SY10800 where SECMODALTID like 'CNV%'

    delete from DYNAMICS.dbo.SY09200 where SECMODALTID like 'CNV%'

    delete from DYNAMICS.dbo.SY10550 where SECMODALTID like 'CNV%'

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    Re: Mass removal of old tasks in GP

    Hi Carl,

    The problem with doing this in SQL is that these are going to be held in several tables if they are assigned to users. Here are the tables you will want to look at:

    SY09100

    SY10500

    SY10600

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Mass removal of old tasks in GP

    nudge

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans