Nintex Ideas

đź‘‹ Use this site to provide feedback and ideas for all Nintex Products. See our post on Nintex Community "Welcome to Nintex Ideas" for more details on Nintex Ideas, how an idea is handled by our product teams and more!


If you have questions about Nintex Ideas, please contact ideas@nintex.com

If you require support, please visit Nintex Customer Central

If you have a sales inquiry, please contact sales@nintex.com

Add a new idea Subscribe
Status Open for voting
Workspace Nintex Process Manager (formerly Promapp)
Categories Reporting
Created by Meghan Blue
Created on Nov 5, 2021

RELATED IDEAS

Add report for all processes by role keyword

Often times we need to together the processes by a specific department. This will include several roles (ie Purchasing - Contract Admin, Purchasing - Buyer, etc). At a minimum, I would like to see a report that can search on role keyword to be exported to Excel with minimode links. I would really like to be able to print this package of processes to be able to provide to an executive leader, as they generally prefer to get the pdf version in a packaged manner.
  • Attach files
  • Olivier Chatagnon
    Reply
    |     Oct 24, 2022

    Hi Meghan,

    For on premise, you can get this list with the following queries:

    SELECT [DestQueue].*,

    (SELECT COUNT(*)

    FROM [Server].ProcSet

    WHERE ProcSet.Folder=[DestQueue].Root) AS NbImpactedProcesses,

    'Table DestQueueUser' AS [Table DestQueueUser],

    [DestQueueUser].*,

    'Table Server' AS [Table Server],

    [Server].*

    FROM [Server].[DestQueue]

    LEFT JOIN [Server].[DestQueueUser] ON [DestQueueUser].QueueID=[DestQueue].ID

    LEFT JOIN [Server].[Server] ON [Server].ID=[DestQueue].ServerID

    SELECT [DestQueue].*,

    (SELECT COUNT(*)

    FROM [Server].ProcSet

    WHERE ProcSet.Folder=[DestQueue].Root) AS NbImpactedProcesses,

    'Table DestQueueUser' AS [Table DestQueueUser],

    [DestQueueUser].*,

    'Table Server' AS [Table Server],

    [Server].*,

    [Identity].FQN AS [Identity.FQN],

    [Identity].[Type] AS [Identity.Type],

    [Identity].[Enabled] AS [Identity.Enabled],

    [Identity].[ExpireOn] AS [Identity.ExpireOn],

    [IdentityDestQueueUser].FQN AS [IdentityDestQueueUser.FQN],

    [IdentityDestQueueUser].[Type] AS [IdentityDestQueueUser.Type],

    [IdentityDestQueueUser].[Enabled] AS [IdentityDestQueueUser.Enabled],

    [IdentityDestQueueUser].[ExpireOn] AS [IdentityDestQueueUser.ExpireOn]

    /*,

    'Table Identity' AS [Table Identity],

    [Identity].*,

    'Table IdentityDestQueueUser' AS [Table IdentityDestQueueUser],

    [IdentityDestQueueUser].*

    */

    FROM [Server].[DestQueue]

    LEFT JOIN [Server].[DestQueueUser] ON [DestQueueUser].QueueID=[DestQueue].ID

    LEFT JOIN [Identity].[Identity] ON [Identity].Type=2--Role

    AND [Identity].Name=[DestQueue].Name

    LEFT JOIN [Identity].[Identity] IdentityDestQueueUser ON IdentityDestQueueUser.FQN=[DestQueueUser].[User]

    LEFT JOIN [Server].[Server] ON [Server].ID=[DestQueue].ServerID


  • Kerry Hiki
    Reply
    |     Sep 7, 2022
    Thank you for the idea. This isn't on our near term roadmap so we'll open this for voting and gauge interest from other customers.
    For now you can use the Involvement report from Admin > Roles. This will give you an excel report of all processes associated to a role. However you will have to combine this with the process list report to get the associated minimode link for the process.