IBM Maximo: Cleanup of Start Center: Difference between revisions
(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 edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| 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. | |||
= Procedure = | |||
* 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 29: | ||
'''<!-- PUT TAGS HERE -->''' | '''<!-- PUT TAGS HERE -->''' | ||
</startcenters> | </startcenters> | ||
</document> | </document> | ||
</nowiki> | |||
I use this sql command to | |||
== Generate a list of users with status DELETED and INACTIVE == | |||
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 | select '<startcenterbyuser userid="' || userid || '"/>' | ||
from scconfig s | |||
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 = | ||
Latest revision as of 18:15, 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.
Procedure
- 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>
Generate a list of users with status DELETED and INACTIVE
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
Generate a list of orphan Start Centers
select '<startcenterbyuser userid="' || userid || '"/>' from scconfig where USERID NOT in (select USERID from maxuser ) group by userid