IBM Maximo: Cleanup of Start Center: Difference between revisions

From Wiki
(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...")
(No difference)

Revision as of 14:17, 24 July 2023

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