Skip to content

Instantly share code, notes, and snippets.

@sudarsang

sudarsang/gist:f2eb5b0f794ee73d396c

Last active August 29, 2015 14:22
Show Gist options
  • Save sudarsang/f2eb5b0f794ee73d396c to your computer and use it in GitHub Desktop.
Save sudarsang/f2eb5b0f794ee73d396c to your computer and use it in GitHub Desktop.
Download ZIP
test
Raw
gistfile1.txt
/**
* Name: BACSOS-76-ENABLE_AUDIT.SQL
* Author: Sudarsan Gopal
* Date: 29/05/2015
* Platform: SQL Server
* Maximo Version: 7.5
* This script will update the DB Config to enable Auditing to the selected fields as per the requirement.
**/
UPDATE MAXATTRIBUTECFG SET EAUDITENABLED=1, CHANGED='Y' WHERE OBJECTNAME='ASSET' AND ATTRIBUTENAME IN ('CHANGEBY','CHANGEDATE','CHILDREN','CLASSSTRUCTUREID','CONTRACTOR','DESCRIPTION','GLACCOUNT','INSTALLDATE','MOVEDATE','MOVEDBY','MOVEMEMO','SERIALNUM','STATUS','STATUSDATE','WARRANTYEXPDATE');
UPDATE MAXATTRIBUTECFG SET EAUDITENABLED=1, CHANGED='Y' WHERE OBJECTNAME='PM' AND ATTRIBUTENAME IN ('ASSETNUM','CHANGEBY','CHANGEDATE','CONTRACTOR','DESCRIPTION','FREQUENCY','FREQUNIT','LEAD','NEXTDATE','PERSONGROUP','PMCOUNTER','ROUTE','SUPERVISOR','WORKTYPE','WOSEQUENCE','WOSTATUS');
UPDATE MAXATTRIBUTECFG SET EAUDITENABLED=1, CHANGED='Y' WHERE OBJECTNAME='PMSEQUENCE' AND ATTRIBUTENAME IN ('INTERVAL','JPNUM','ORGID','PLUSCJPREVNUM_NP','PMNUM','PMSEQUENCEID');
UPDATE MAXATTRIBUTECFG SET EAUDITENABLED=1, CHANGED='Y' WHERE OBJECTNAME='MAXUSER' AND ATTRIBUTENAME IN ('USERID','PERSONID','STATUS','TYPE','LOGINID','MEMO');
UPDATE MAXATTRIBUTECFG SET EAUDITENABLED=1, CHANGED='Y' WHERE OBJECTNAME='PERSON' AND ATTRIBUTENAME IN ('DISPLAYNAME','FIRSTNAME','LASTNAME','LOCATION','STATUS','STATUSDATE','SUPERVISOR','WOAPPROVALLIMIT');
UPDATE MAXOBJECTCFG SET CHANGED='A' where OBJECTNAME IN ('ASSET', 'PM', 'PMSEQUENCE', 'MAXUSER', 'PERSON');
select sr.ticketid, sr.status, sr.description, relatedrecord.relatedreckey, (select status from workorder where workorder.wonum = relatedrecord.relatedreckey), relatetype
from sr
left join relatedrecord on relatedrecord.recordkey = sr.ticketid
where status not in ('closed','resolved') and relatedrecord.relatedrecclass = 'workorder' and (select status from workorder where workorder.wonum = relatedrecord.relatedreckey) in ('can','close')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment