Skip to content
Automation Script to reset user's Start Centers

Automation Script to reset user's Start Centers

November 28, 2018

In a previous post I have explained how to force the reload of a the start center for a specific group of users.
I have now developed a useful automation script that can be invoked from the Security Group application to automatically perform this task with just one click.
Register the script as a Script with an Action Launch Point and link it to a sigoption and to a menuaction, toolbar icon or application button as described in this post or this one.

# Reset users Start Centers

Object: MAXGROUP

Resets the Start Centers for all users assigned to the selected Security Group

Should be called when all users are logged off so the start center is reloaded after the login

See: http://bportaluri.com/2012/11/how-to-reset-users-start-centers.html

from psdi.server import MXServer from psdi.util.logging import MXLoggerFactory

mxserver = MXServer.getMXServer() logger = MXLoggerFactory.getLogger(“maximo.maximodev”) logger.info(“Entering MXD_RESETSC”)

Execute delete statement

def execDelete(objectName, where): sql = “delete from " + objectName + " where " + where logger.debug(“Executing SQL statement: " + sql) conKey = mxserver.getSystemUserInfo().getConnectionKey() con = mxserver.getDBManager().getConnection(conKey) s= con.createStatement() s.executeUpdate(sql) s.close() con.commit() mxserver.getDBManager().freeConnection(conKey)

grpname = mbo.getString(“GROUPNAME”)

where1 = “scconfigid IN (SELECT scconfigid FROM scconfig WHERE groupname=’” + grpname + “’)” where2 = “layoutid IN (SELECT layoutid FROM layout WHERE " +where1+ “)”

execDelete(“PORTLETDISPLAY”, where2) execDelete(“REPORTLISTCFG”, where2) execDelete(“RSCONFIG”, where2) execDelete(“FACONFIG”, where2) execDelete(“INBXCONFIG”, where2) execDelete(“KPILCONFIG”, where2) execDelete(“KPIGCONFIG”, where2) execDelete(“ACTIONSCFG”, where2) execDelete(“LAYOUT”, where2)

execDelete(“SCCONFIG”, where1)



Share this:
Twitter Facebook LinkedIn