Get My Tasks info

Hello.

I'm trying to find My Tasks and Recenyly Accessed Tasks on the data base to export this info and create new roles according to this information.

I know recent tasks info is on tsmUserMenuItem table. But I can't fin My Tasks info.

Can anybody tell me how can I find this information?

Thanks

  • 0

    Hi David,

    Happy New Year. Hope you're doing well.

    Here's a script that could probably help you:


    declare @orgdtkey int
    SELECT @ORGDTKEY = UserDesktopKey FROM tsmUserDesktop WHERE ActualUserID = 'admin' -- NOTE: Make sure to change the ActualUserID to the one you want to show and get the userDesktopKey
    SELECT * FROM tsmUserMenuItem WHERE UserDesktopKey = @ORGDTKEY AND RecentlyUsed=0

    Let me know if this is what you need. Thank you.