IBM Maximo: Cleanup of Start Center

From Wiki
Revision as of 14:17, 24 July 2023 by Ebasso (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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