Mass change of application owners

[DLawrie]

We have a requirement to change 100's of application with application owner relationships. What is the best way to disconnect on mass current applications from their owners and assign them new applications. In our estate we have over 2000 applications and some owers at a senior level with over 100 applications they are classified as application owners of. We only have a Hopex hosted web front end and no windows Hopex interface. Any ideas?

[ilvetz]

You may also try using this Excel template.

Responsibility Assignment	Short Name	Business Role	Assigned Object	Assigned Person
0000000080000040	0000000040000063	000000000C00008A	235326C14ECD456E	000000000C000089
	[Person]-Local Application Owner-[Application]	Local Application Owner	[eg. Application Shortname]	[Person]

Let me know.

[DLawrie · Accepted solution]

Hi mostafafad thanks for the reply. We have not been able to use vbscript editor as we only have the hopex cloud solution and no windows access. 

I have been able to do some mass changes using excel import sheet as

Application	Application Code	Short Name	ITPM - Excel Application Application Owner
B1EDB2562C14016F	55EF6704336F00B1	0000000040000063	DBE4E3EF54375F5B

But it is a bit disconcerting that it works without an absolute id from the person that is being assigned and it removes access from the person that was an application owner. I need to do some more testing where there are multiple existing application owners and where there are multiple applications owners with the same name.. But for now my immediate requirement seems to be satisfied. Thanks again for taking the time to reply.

[mostafafad]

I think the best way with these one-time scenarios is to write a vbscript and run it through vbscript editor in order to do the transfer

[DLawrie]

Mass changes can be made by duplicating or transfering responsibilities between people within the Hopex Admistrator interface. Mass deletes can aslo be made through the admistrator tool. However new mass loads are still a problem to work on.