Blue Prism Manifest V3 Announcement - Need utility for Azure Hosted

[SaifulKhan]

We have downloaded the Manifest V3 Impact Assessment Utility and We followed the instructions mentioned in README file came with the package, downloaded and ran it, but were unable to retrieve any VBO’s(PFA Snip). Probably this could be as we are Azure hosted and the Utility only has 2 authentication Modes (Windows and SQL server)

Could you please let us know if Blue prism has an utility for Azure Hosted Environment (with Azure authentication modes) or related SQL scripts that we can run to extract the output for our VBO’s?

[ewilson]

Hi @Saif,

I'm at a loss for what's going on in your environment as we've had other customers with SQL Server deployed on Azure that are not experiencing this problem. Having said that, since you have access to SSMS you can just run the query directly from it. Below is a query that will return a list of objects that use Chrome or Edge and that are using Insert Javascript or Invoke Javascript actions. If there are any matches you'll see two columns in the output: the name of the specific VBO as well as the group (aka folder) it can be found under in the Interactive Client.

SELECT [blueprism_db].[BPAProcess].[name] as 'VBO Name', [blueprism_db].[BPVGroupedobjects].[groupname] as 'Group' 
FROM [blueprism_db].[dbo].[BPAProcess] 
INNER JOIN [blueprism_db].[dbo].[BPVGroupedObjects] ON ([blueprism_db].[dbo].[BPAProcess].[processid]=[blueprism_db].[dbo].[BPVGroupedObjects].[id]) 
WHERE ([blueprism_db].[dbo].[BPAProcess].[ProcessType] = 'O' AND [AttributeID] <> 1) AND (([processxml] LIKE '%WebInjectJavascript%' OR [processxml] LIKE '%WebInvokeJavascript%') AND ([processxml] LIKE '%chrome.exe%' OR [processxml] LIKE '%msedge.exe%'));​

​
Cheers,
Eric

[SaifulKhan]

Thanks Eric for the query, was getting Multipart-Identifier bound with the below query, have bounded with aliases and extracted the result.

SELECT [blueprism_db].[BPAProcess].[name] as 'VBO Name', [blueprism_db].[BPVGroupedobjects].[groupname] as 'Group' FROM [blueprism_db].[dbo].[BPAProcess] INNER JOIN [blueprism_db].[dbo].[BPVGroupedObjects] ON ([blueprism_db].[dbo].[BPAProcess].[processid]=[blueprism_db].[dbo].[BPVGroupedObjects].[id]) WHERE ([blueprism_db].[dbo].[BPAProcess].[ProcessType] = 'O' AND [AttributeID] <> 1) AND (([processxml] LIKE '%WebInjectJavascript%' OR [processxml] LIKE '%WebInvokeJavascript%') AND ([processxml] LIKE '%chrome.exe%' OR [processxml] LIKE '%msedge.exe%'));​




Have bounded it with out changing the logic and extracted result against blueprism DB. will validate across the env from BP Studio.

select p.name as 'VBO Name', g.groupname as 'Group' from bpaprocess p inner join BPVGroupedObjects G on p.processid = g.id WHERE p.ProcessType = 'O' AND p.AttributeID <> 1 AND p.processxml LIKE '%WebInjectJavascript%' OR p.processxml LIKE '%WebInvokeJavascript%' AND processxml LIKE '%chrome.exe%' OR p.processxml LIKE '%msedge.exe%'

[ewilson]

@Saif,

Glad to hear we’ve made some progress. 😁

Cheers,
Eric​