IBM Maximo: Cleanup of Start Center

From Wiki
Revision as of 17:18, 24 July 2023 by Ebasso (talk | contribs)

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


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

<?xml version="1.0" ?>
 <document docid="SCCleanup">
 <!-- Samples
 
 <startcenters>
 <startcenter id="93"/>
 <startcenterbygroup groupname="SRMSELFSERVICE"/>
 <startcenterbygroup groupname="ITADMIN"/>
 <startcenterbyuser userid="ESPH"/>
 -->
 <startcenters>
 
 '''<!-- PUT TAGS HERE -->'''

 </startcenters>
 </document>

I use this sql command to get the list of 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 in('DELETED','INACTIVE') ) group by userid


Ver também