IBM Maximo: Cleanup of Start Center - Revision history

Ebasso at 18:15, 24 July 2023

2023-07-24T18:15:26Z

← Older revision		Revision as of 18:15, 24 July 2023
Line 1:		Line 1:
	'''Cleanstartcenters.bat/sh''' is a tool that deletes Start Center configuration data by specific user or for all users.		'''Cleanstartcenters.bat/sh''' is a tool that deletes Start Center configuration data by specific user or for all users.

			This script is installed on Maximo Administrative Workstation on directory.

	~~This script is installed on Maximo Administrative Workstation on directory. Example:~~		= Procedure =

	* C:\IBM\SMP\maximo\tools\maximo		* C:\IBM\SMP\maximo\tools\maximo
Line 32:		Line 33:
	</document>		</document>
	</nowiki>		</nowiki>


			== Generate a list of users with status DELETED and INACTIVE ==

	I use this sql command to get the list of status		I use this sql command to get the list of status
Line 43:		Line 47:
	where userid in (select USERID from maxuser where status in('DELETED','INACTIVE') ) group by userid		where userid in (select USERID from maxuser where status in('DELETED','INACTIVE') ) group by userid

			== Generate a list of orphan Start Centers ==

			select '<startcenterbyuser userid="' \|\| userid \|\| '"/>'
			from scconfig
			where USERID NOT in (select USERID from maxuser ) group by userid

	= Ver também =		= Ver também =

Ebasso at 17:18, 24 July 2023

2023-07-24T17:18:13Z

← Older revision		Revision as of 17:18, 24 July 2023
Line 6:		Line 6:
	* C:\IBM\SMP\maximo\tools\maximo		* C:\IBM\SMP\maximo\tools\maximo

	<?xml version="1.0" ?>
			To run this tool, you must run the following command:

			C:\IBM\SMP\maximo\tools\maximo>cleanstartcenters.bat -isccleanup.xml

			where sccleanup.xml is a xml file with a list of users.

			The '''sccleanup.xml''' has the following syntax

			<nowiki><?xml version="1.0" ?>
	<document docid="SCCleanup">		<document docid="SCCleanup">
	<!-- Samples		<!-- Samples
Line 19:		Line 28:

	'''<!-- PUT TAGS HERE -->'''		'''<!-- PUT TAGS HERE -->'''

	</startcenters>		</startcenters>
	</document>		</document>
			</nowiki>

	I use this sql command to		I use this sql command to get the list of status

	select status from maxuser group status		select status from maxuser group status

			after i use this sql command to generate tags to DELETED and INACTIVE users and add to '''sccleanup.xml''' file

	select '<startcenterbyuser userid="' \|\| userid \|\| '"/>' from scconfig s where userid in (select USERID from maxuser where status = 'DELETED') group by userid		select '<startcenterbyuser userid="' \|\| userid \|\| '"/>'
			from scconfig s
	~~to generate tags and add to '''sccleanup.xml''' file~~		where userid in (select USERID from maxuser where status in('DELETED','INACTIVE') ) group by userid

	~~After run this command~~

	~~C:\IBM\SMP\maximo\tools\maximo>cleanstartcenters.bat -isccleanup.xml~~

Ebasso: Criou a página com "'''Cleanstartcenters.bat/sh''' is a tool that deletes Start Center configuration data by specific user or for all users. This script is installed on Maximo Administrative..."

2023-07-24T14:17:53Z

Criou a página com "'''Cleanstartcenters.bat/sh''' is a tool that deletes Start Center configuration data by specific user or for all users. This script is installed on Maximo Administrative..."

New page

'''Cleanstartcenters.bat/sh''' is a tool that deletes Start Center configuration data by specific user or for all users.

This script is installed on Maximo Administrative Workstation on directory. Example:

* C:\IBM\SMP\maximo\tools\maximo

<?xml version="1.0" ?>
<document docid="SCCleanup">

<startcenters>

''''''
</startcenters>
</document>

I use this sql command to

select status from maxuser group status

select '<startcenterbyuser userid="' || userid || '"/>' from scconfig s where userid in (select USERID from maxuser where status = 'DELETED') group by userid

to generate tags and add to '''sccleanup.xml''' file

After run this command

C:\IBM\SMP\maximo\tools\maximo>cleanstartcenters.bat -isccleanup.xml

= Ver também =

* [[IBM Maximo| Artigos sobre IBM Maximo]]
* [[Tecnologias| Mais Artigos sobre Cloud / WebDev / Tecnologias]]

[[Category:IBM Maximo]]
[[Category:ibm-maximo-performance]]
[[Category:ibm-maximo-properties]]