Select the search type
  • Site
  • Web
Search
You are here:  Support/Forums
Support

Bring2mind Forums

PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 02/08/2007 2:51 PM by  Mike Willard
Subscriptions for deleted users
 4 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Mike Willard
New Member
New Member
Posts:44


--
02/06/2007 12:59 AM

    We've now been using DNN w/AD authentication for about 1 year and have realized that something needs to be done to "clean up" users who no longer exist in AD, but have DNN user accounts.  I'm considering writing a script to compare DNN users to AD and delete those records from the database where no AD account exists.  The question is, what happens when a user is subscribed to a collection in DMX and the user has been deleted?  Will there be a flood of undeliverable emails?

     

    Thanks in advance...

     

    Mike

    Peter Donker
    Veteran Member
    Veteran Member
    Posts:4536


    --
    02/06/2007 11:26 PM
    Mike,
    If anything DMX won't be able to find the email. But under normal circumstances the subscription are 'cascade deleted' after a user is removed.
    Peter
    Mike Willard
    New Member
    New Member
    Posts:44


    --
    02/07/2007 9:33 PM
    Peter,

    Just to be clear, I'm talking about a query to go in and directly delete user records from the DNN user table, not removing them via the DNN admin interface. I know this is beyond the scope of DMX support, but I'm just wondering what the implications are? I have a SQL user table that is updated nightly with up to date information from AD and I would like to do a simple comparison to remove those users in DNN that no longer exist in AD. I'm not following how the subscription information in DMX would also be removed in this scenario.

    Thanks

    Mike
    Peter Donker
    Veteran Member
    Veteran Member
    Posts:4536


    --
    02/08/2007 12:03 AM
    Mike,
    As a module developer I only have the DB to go on. So it doesn't matter if you do it by hand or through the DNN interface: my modules just look at the data in your DNN database. There should be a cascade delete on the DMX_Subscriptions and DMX_Log. There is one other reference to users in DMX_Entries, but that should not affect program running. In any case: if you see anything weird it is easy to repair: you just set the UserId field to the admin's ID for all those that are left hanging in mid-air.
    Peter
    Mike Willard
    New Member
    New Member
    Posts:44


    --
    02/08/2007 2:51 PM
    Excellent suggestion! Thanks!
    You are not authorized to post a reply.