TNPM/resmgr automated
From neil.tappsville.com
Jump to navigationJump to search
Contents
- 1 A bunch of wrappers for the resmgr command
- 2 export_agp_appS_chart_group_links.pl
- 3 export_agp_app_report_group_links.pl
- 4 export_agp_report_groups.pl
- 5 export_appS_charts.pl
- 6 export_app_reports.pl
- 7 export_fgp_formula_groups.pl
- 8 export_frm_formulas.pl
- 9 export_linkGroupSE_report_links.pl
- 10 export_pctile_aggregation_requests.pl
- 11 export_segpreq_collection_requests.pl
- 12 export_seprp_properties.pl
- 13 export_thrdv_thresholds.pl
- 14 import_agp_appS_chart_group_links.pl
- 15 import_agp_app_report_group_links.pl
- 16 import_agp_report_groups.pl
- 17 import_appS_charts.pl
- 18 import_appS_charts_real.pl
- 19 import_app_reports.pl
- 20 import_fgp_formula_groups.pl
- 21 import_fgp_frm_formulas.pl
- 22 import_linkGroupSE_report_links.pl
- 23 import_pctile_aggregation_requests.pl
- 24 import_segpreq_requests.pl
- 25 import_segp_rules.pl
- 26 import_seprp_properties.pl
- 27 import_thrdv_gen_grp_thresholds.pl
- 28 import_thrdv_thresholds.pl
- 29 CompareFilesinDirs.pl
A bunch of wrappers for the resmgr command
Out of the box, resmgr will allow you to do some pretty stupid things to the database. These are logical wrappers that take the hurt out of doing development / syncing environments
Sorry the actual perl scripts are locked away, the format of the files they produce is listed here for reference however
export_agp_appS_chart_group_links.pl
resmgr -sepRec "<REC>" -sep "|_|" -noHead -export agp -colNames "dbIndex npath appS.dbIndex appS.name" -filter "dbIndex($agplevelhash{"$npath"}->{"dbindex"})" -order appS.dbIndex | sort > data/agp_appS/$agplevelhash{"$npath"}->{"dbindex"}.rmgr
export_agp_app_report_group_links.pl
resmgr -sepRec "<REC>" -sep "|_|" -noHead -export agp -colNames "dbIndex npath app.dbIndex app.name" -filter "dbIndex($agplevelhash{"$npath"}->{"dbindex"})" -order app.dbIndex | sort > data/agp_app/$agplevelhash{"$npath"}->{"dbindex"}.rmgr
export_agp_report_groups.pl
resmgr -sepRec "<REC>" -sep "|_|" -noHead -export agp -colNames "dbIndex npath" -filter "dbIndex($agplevelhash{"$npath"}->{"dbindex"})" -file data/agp/$agplevelhash{"$npath"}->{"dbindex"}.rmgr
export_appS_charts.pl
resmgr -sepRec "<REC>" -sep "|_|" -noHead -export appS -colNames "dbIndex name type comment definition" -filter "appS.dbIndex($dbIndex)" -file data/appS/$dbIndex.rmgr
export_app_reports.pl
resmgr -sepRec "<REC>" -sep "|_|" -noHead -export app -colNames "dbIndex name comment url type data" -filter "app.dbIndex($dbIndex)" -file data/app/$dbIndex.rmgr
export_fgp_formula_groups.pl
resmgr -sepRec "<REC>" -sep "|_|" -noHead -export fgp -colNames "dbIndex npath" -filter "dbIndex($fgplevelhash{"$npath"}->{"dbindex"})" -file data/fgp/$fgplevelhash{"$npath"}->{"dbindex"}.rmgr
export_frm_formulas.pl
resmgr -sepRec "<REC>" -sep "|_|" -noHead -export fgp -colNames "fgp.npath frm.dbIndex frm.name frm.comment frm.type frm.subType frm.data frm.dataType frm.defValue frm.state frm.domaine frm.exprType frm.invariant frm.curve frm.origin frm.user" -filter "frm.dbIndex($dbIndex)" -file data/fgp_frm/$dbIndex.FRM.rmgr resmgr -sepRec "<REC>" -sep "|_|" -noHead -export fgp -colNames "fgp.npath frm.dbIndex frm.name frm.mibPath frm.mibOrigin frm.mibUser frm.origin frm.user" -filter "frm.dbIndex($dbIndex)" -file data/fgp_frm/$dbIndex.MIB.rmgr
export_linkGroupSE_report_links.pl
resmgr -sepRec "<REC>" -sep "|_|" -noHead -export segp -colNames "npath app.dbIndex app.name" -filter "npath($npath)" | sort > data/linkGroupSE/$safename.rmgr
export_pctile_aggregation_requests.pl
resmgr -sepRec "<REC>" -sep "|_|" -noHead -export pctile -colNames "fgp.nName segp.npath ttype status storage period state instance value type user origin" -filter "segp.dbIndex($pctilelevelhash{"$npath"}->{"dbindex"})" -order fgp.nName | sort > data/pctile/$safename.rmgr
export_segpreq_collection_requests.pl
resmgr -sepRec "<REC>" -sep "|_|" -noHead -export segpreq -colNames "fgp.nName segp.npath ttype status storage period instance state user origin" -filter "segp.dbIndex($segpreqlevelhash{"$npath"}->{"dbindex"})" -order fgp.nName | sort > data/segpreq/$safename.rmgr
==export_segp_rules.pl== - Note this doesnt track dbIndexes, but it should (be warned when using with AP delivered groups)
resmgr -sepRec "<REC>" -sep "|_|" -noHead -export segp -colNames "npath name type cond state origin user" -filter "segp.dbIndex($segplevelhash{"$npath"}->{"dbIndex"})" -file data/segp/$safename.rmgr
export_seprp_properties.pl
resmgr -sepRec "<REC>" -sep "|_|" -export seprp -noHead -colNames "dbIndex name type defValue origin comment" -filter "dbIndex($dbIndex)" -file data/seprp/$dbIndex.rmgr
export_thrdv_thresholds.pl
import_agp_appS_chart_group_links.pl
import_agp_app_report_group_links.pl
resmgr -sepRec "<REC>" -sep "|_|" -noHead -import agp -colNames "dbIndex npath app.dbIndex app.name" -line "$line"