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.
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
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.