IBM Maximo: Cleanup of Start Center
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