Managing report objects 147 - IBM Tivoli Netcool Performance Manager Wireline Component Documen

Explains how to use resmgr to manage report objects and to export, import, and different Tivoli Netcool Performance Manager object types that belong to the report category.

Report includes the following object types:

v Web users v Applications v Scheduler

Before using the commands in this chapter, review the information in Chapter 4,

“Managing Tivoli Netcool Performance Manager objects,” on page 15.

Working with web users

This section contains the commands you can use to manage web users. When you use resgmr to work with web users, you work with the following object types:

v rusr v owner v ruprp v ruproperty v rugp

v linkGroupRU

Exporting web user

Exporting report user name and properties

resmgr -export rusr -colNames "name ruprp.name ruprp.value" -file

$DIR/rusr_ruprp.dat

# type = rusr

# col = name ruprp.name ruprp.value

# filter =

# order =

# sep = |_|

# sepRec =

# cmdLine = -export rusr -colNames "name ruprp.name ruprp.value"

FAMA|_|

FDOU|_|

Frankie|_||_||_|

Marcus|_|

SSSW\\SuperUser|_|DV_UserProfile|_|NOC|_|DV_UserResourceName|_|1|_|

DV_UserShowCurrentPeriod|_|true|_|

SSSW\\adminfcar|_|DV_UserProfile|_|NOC|_|DV_UserResourceName|_|1|_|

DV_UserShowCurrentPeriod|_|true|_|

SSSW\\alcatel|_|DV_UserProbeConfigAccess|_|read-write|_|DV_UserProfile|_|SLA|_|

Exporting all report users

resmgr -export rusr -colNames "dbIndex name mail type" -file

$DIR/rusr.dat

# type = rusr

# col = dbIndex name mail type

# filter =

# order =

# sep = |_|

sepRec =

# cmdLine = -export rusr -colNames "dbIndex name mail type"

100000017|_|SSSW\\jtho|_||_|Tivoli Netcool Performance Manager USER|_|

100000149|_|SSSW\\noc|_||_|Tivoli Netcool Performance Manager USER|_|

100000152|_|SSSW\\coca|_||_|Tivoli Netcool Performance Manager USER|_|

100000153|_|SSSW\\quallaby|_||_|Tivoli Netcool Performance Manager USER|_|

100000154|_|SSSW\\business|_||_|Tivoli Netcool Performance Manager USER|_|

100015938|_|SSSW\\cargill|_||_|Tivoli Netcool Performance Manager USER|_|

100007838|_|SSSW\\cisco|_||_|Tivoli Netcool Performance Manager USER|_|

100007863|_|SSSW\\ciscodemo|_||_|Tivoli Netcool Performance Manager USER|_|

100008522|_|SSSW\\design|_||_|Tivoli Netcool Performance Manager USER|_|

100008064|_|SSSW\\realtime|_||_|Tivoli Netcool Performance Manager USER|_|

100009714|_|SSSW\\tt2|_||_|Tivoli Netcool Performance Manager USER|_|

100009717|_|SSSW\\tt1|_||_|Tivoli Netcool Performance Manager USER|_|

100009991|_|SSSW\\xtra|_||_|Tivoli Netcool Performance Manager USER|_|

100009812|_|SSSW\\adminfcar|_||_|Tivoli Netcool Performance Manager USER|_|

100009843|_|SSSW\\juniper|_||_|Tivoli Netcool Performance Manager USER|_|

100020250|_|SSSW\\flagtelecom|_||_|Tivoli Netcool Performance Manager USER|_|

100020666|_|Frankie|_|[email protected]|_|EMAIL RECIPIENT|_|

Exporting report users group

resmgr -export rugp -colNames "npath rusr.name" -file $DIR/rugp.dat

# type = rugp

# col = npath rusr.name

# filter =

# order =

# sep = |_|

# sepRec =

# cmdLine = -export rugp -colNames "npath rusr.name"

~Users|_|SSSW\\jtho|_|

~Orphans|_|SSSW\\cisco|_|

~Orphans|_|SSSW\\ciscodemo|_|

~Orphans|_|SSSW\\design|_|

~Orphans|_|SSSW\\realtime|_|

~ABC|_|SSSW\\xtra|_|

~Admin Noc|_|SSSW\\adminfcar|_|

~Orphans|_|SSSW\\juniper|_|

~ABC|_|SSSW\\ihug|_|

~ABC|_|SSSW\\tnz_noc|_|

~Orphans|_|SSSW\\alcatel|_|

~Orphans|_|SSSW\\ciscodev|_|

~Users|_|SSSW\\timl|_|

~DV [Internal Use Do Not Remove]|_|SSSW\\SuperUser|_|

~Orphans|_|SSSW\\bt|_|

Importing web user

Importing a new customer with a property

If you want to import a new customer called customer1 with a property called property1 you can use the following command.

resmgr -import rusr -colNames "name ruprp.property1:value" -line

"SSSW\\\\customer1|_|value_property1"

Info : === insert : nothing ON Report User ( SSSW\\customer1 ) (exists)

Info : === insert : INSERT ON property ( property1 ) (does not exist)

Info : === insert : INSERT ON Ruser property ( 100000265 100008523 value_property1 ) (does not exist)

Grouping this customer

resmgr -import rugp -colNames "npath rusr.name" -line

"~Group1|_|SSSW\\\\customer1"

Info : === insert : nothing ON Ruser Group ( ~Group1 ) (exists) Info : === insert : nothing ON Report User ( SSSW\\customer1 ) (exists)

Info : === insert : INSERT ON Link RU/RUG ( SSSW\\customer1 Group1 ) (does not exist)

Deleting web user

Deleting a report user (name or index)

resmgr -delete rusr -colNames "name" -line "SSSW\\\\customer1"

Info : === delete : DELETE ON Report User ( SSSW\\customer1 ) (exists)

Unlinking a report user from a group

resmgr -delete linkGroupRU -colNames "npath rusr.name" -line

"~Group1|_|SSSW\\\\customer1"

Info : === delete : DELETE ON Link RU/RUG ( SSSW\\customer1 Group1 ) (exists)

Info : === Update Histo : 0

Deleting just the value of the property for a report user

resmgr -delete ruproperty -colNames "name ruprp.name" -line

"SSSW\\\\customer1|_|property1"

Info : === delete : DELETE ON Ruser property ( 100008524 100008523 value_property1 ) (exists)

Deleting a group of report users

resmgr -delete rugp -colNames "npath" -line "~Group1"

Info : === DELETE GROUP : ~Group1 (index = 100007970)

Info : === delete : DELETE ON Ruser Group ( ~Group1 ) (exists) Info : === Update Histo : 0

Working with reporters

This section contains the commands you can use to manage reporters and reporter stylesheets. When you use resgmr to work with reporters, you work with the following object types:

v app v agp

v appS (report Style) v linkGroupAPP v linkGroupAPPS

Exporting reporters

Exporting report styles

resmgr -export appS -sepRec "<E>" -colNames "dbIndex

definition comment name type" -order "dbIndex" -filter "name(AP TopN Chart Style - Bar - DD Details - min avg max)" -file

$DIR/appS.dat

# type = appS

# col = dbIndex definition comment name type

# filter = name(AP TopN Chart Style - Bar - DD Details - min avg max)

# order = dbIndex

# sep = |_|

# sepRec = <E>

# cmdLine = -export appS -colNames "dbIndex definition comment name type" -filter "name(AP TopN Chart Style - Bar - DD Details - min avg max)"

6073|_|<chart>

<color r="254" g="254"

b="230">background</color>

<color r="0" g="0" b="0">foreground</color>

</appearance>

<threeDEffect depth="0" elevation="0" rotation="0"

effect="false"/>

<views>

<serie>

<color r="150" g="150"

b="255">line</color>

</line>

</serie>

<serie>

<color r="0" g="170"

b="255">line</color>

</line>

</serie>

<serie>

<color r="0" g="0"

b="255">line</color>

</line>

</serie>

<serie>

<color r="42" g="0"

b="85">line</color>

</line>

</serie>

<serie>

<color r="31" g="34"

b="255">line</color>

</line>

</serie>

<serie>

<color r="234" g="208"

b="229">line</color>

<text>

<text-advanced alignment="center"

orientation="horizontal" rotation="0"/>

</text>

<color r="102" g="255"

b="255">background</color>

<color r="0" g="51"

b="51">foreground</color>

</appearance>

<location visible="false" x="310" y="465" w="80" h="14"

anchor=""/>

</footer>

</chart> |_|Comment here|_|AP TopN Chart Style - Bar - DD Details - min avg max|_|0|_|<E>

Exporting report group stylesheets

resmgr -export agp -colNames "npath appS.name" -file

$DIR/agp_appS.dat

# type = agp

# col = npath appS.name

# filter =

# order =

# sep = |_|

# sepRec =

# cmdLine = -export agp -colNames "npath appS.name"

~AP Styles|_|AP TopN Chart Style - Bar - DD Details - min avg max|_|

~AP Styles|_|AP Baseline Chart Style - avg max|_|

~AP Styles|_|AP RV Chart Style - avg|_|

~AP Styles|_|AP TS Chart Style - Line - avg|_|

~AP Styles|_|AP TS Chart Style - Bar - min avg max|_|

~AP Styles|_|AP TS Chart Style - Line (Y-axis 0-100)|_|

~AP Styles|_|AP TS Chart Style - Pie - Ratio|_|

~AP Styles|_|AP TS Chart Style - Bar 3-D - min avg max|_|

~AP Styles|_|AP TS Chart Style - Area - max avg|_|

~AP Styles|_|AP TS Chart Style - Bar 3-D - sum|_|

~AP Styles|_|AP TS Chart Style - Bar 3-D - max|_|

~AP Styles|_|AP TS Chart Style - Area - avg|_|

~AP Styles|_|AP TS Chart Style - Bar 3-D - avg|_|

~AP Styles|_|AP TopN Chart Style - Bar - DD Details - avg max|_|

~AP Styles|_|AP TopN Chart Style - Bar - DD Details - avg|_|

Exporting report group

resmgr -export agp -colNames "dbIndex npath app.name" -file

$DIR/agp_app.dat

# type = agp

# col = dbIndex npath app.name

# filter =

# order =

# sep = |_|

# sepRec =

# cmdLine = -export agp -colNames "dbIndex npath app.name"

7385|_|~AP MIB-II Pack~Interface~Utilization Metrics|_|Interface Volume Resource Detail Chart|_|

7385|_|~AP MIB-II Pack~Interface~Utilization Metrics|_|Interface Volume Resource|_|

7385|_|~AP MIB-II Pack~Interface~Utilization Metrics|_|Interface Volume Resource Threshold - Inbound Volume (octets)|_|

7385|_|~AP MIB-II Pack~Interface~Utilization Metrics|_|Interface Volume Resource Threshold - Inbound Throughput (bps)|_|

7385|_|~AP MIB-II Pack~Interface~Utilization Metrics|_|Interface Volume Resource Threshold - Outbound Volume (octets)|_|

7385|_|~AP MIB-II Pack~Interface~Utilization Metrics|_|Interface Volume Resource Threshold - Outbound Throughput (bps)|_|

7385|_|~AP MIB-II Pack~Interface~Utilization Metrics|_|Interface Utilization Resource Detail Chart|_|

7385|_|~AP MIB-II Pack~Interface~Utilization Metrics|_|Interface Utilization Resource Threshold - Inbound Utilization (percent)|_|

7385|_|~AP MIB-II Pack~Interface~Utilization Metrics|_|Interface Utilization Resource Threshold - Inbound Throughput (bps)|_|

7385|_|~AP MIB-II Pack~Interface~Utilization Metrics|_|Interface Utilization Resource Threshold - Outbound Utilization (percent)|_|

7385|_|~AP MIB-II Pack~Interface~Utilization Metrics|_|Interface Utilization Resource Threshold - Outbound Throughput (bps)|_|

7385|_|~AP MIB-II Pack~Interface~Utilization Metrics|_|Interface Utilization Group|_|

7396|_|~AP MIB-II Pack~Interface~Availability Metrics|_|Interface Availability Resource Detail Chart|_|

7396|_|~AP MIB-II Pack~Interface~Availability Metrics|_|Interface Availability Resource Threshold - Inbound Loss|_|

7396|_|~AP MIB-II Pack~Interface~Availability Metrics|_|Interface Availability Resource Threshold - Availability|_|

Exporting report

resmgr -export app -sepRec "<E>" -colNames "dbIndex name comment url type data" -order "dbIndex" -file $DIR/app.dat

# type = app

# col = dbIndex name comment url type data

# filter =

# order = dbIndex

# sep = |_|

# sepRec = <E>

# cmdLine = -export app -colNames "dbIndex name comment url type data"

4250|_|GST - IPSec - Phase-1 Volume and Throughput (second level)|_|AP IPSec generic pack member

reporter|_|PVLsGroupSummaryTable_centerTitle.html|_|1

|_|"UserLogin.text=$USERPROPERTY:DV_UserLoginName"

"UserWelcome.link="

"groupSummaryTable.group.drilldown.reporter=4541"

"CSVExport.text=Export CSV"

"groupSummaryTableMediator.formula3.metrics=2305"

"reporterStyle="

"groupSummaryTable.formula1.drilldown.reporter=4542"

"reportTitle.text=IPSec - Phase-1 Volume and Throughput for

$GROUP_NAME"

"UserLogo.image=$USERPROPERTY:DV_UserCustomLogoFile"

"UserLogo.default.link="

"groupSummaryTableMediator.formula5.metrics=2307"

"groupSummaryTable.formula6.stats.labels="

"UserWelcome.text=Welcome $USERPROPERTY:DV_UserName"

"groupSummaryTableMediator.formula1.metrics=2301"

...

"UserLogo.link="

"groupSummaryTableMediator.formula2.stats=sum"

"groupSummaryTableMediator.formula4.stats=avg max"

"groupSummaryTable.formula6.metrics.labels="

"groupSummaryTable.formula2.metrics.labels="

"UpScaleNav.monthly.enable=true"

"reportSummary.text=$REPORT_PERIOD Group Summary Report

-$START_TIME"

"DownScaleNav.yearly.enable=true"

"reportTitle.link="

"groupSummaryTable.formula4.drilldown.reporter=4547"|_|<E>

Importing reporters

New app

You must use the name column when importing new applications. By default, dbIndex is taken from the DesignSequences, comment, data, owner, alias is null, type =0, typeR=Reporter, url = none, user=UNIX user, and date=current date.

You can also include the following columns:

v url v data type

New appS

You must use the name column when importing new application style sheets. By default, dbIndex is taken from the DesignSequences, comment, definition is null, and type =0.

You can also include the following columns:

v definition v comment v type

Updating app and appS

When updating existing applications and application style sheets, you must use the dbIndex or name columns, and the columns to be modified.

Importing the file reportStyle.txt after modifying it

resmgr -import appS -sepRec "<E>" -colNames "dbIndex

definition comment name type" -mode insert -file $DIR/appS.dat

Check the output for errors. If there is a major error, such as a corrupt file, it is reported on the last line of the output.

Copying a report (only the name is modified)

Use the nop keyword instead of dbIndex because dbIndex uniquely identifies a report. Another method is to manually modify the dbIndex in the export file.

resmgr -import app -sepRec "<E>" -colNames "nop name comment url type data" -file /tmp/report.txt

Check the output for errors. If there is a major error, such as a corrupt file, it is reported on the last line of the output.

Importing application group

resmgr -import agp -colNames "npath app.name" -line "~AP MIB-II Pack~Interface~TEST1|_|Interface Availability Resource Threshold -Availability|_|"

Info : === insert : INSERT ON Application Group ( ~AP MIB-II Pack~Interface~TEST1 ) (does not exist)

Info : === insert : nothing ON Application ( Interface Availability Resource Threshold - Availability ) (exists) Info : === insert : INSERT ON Link App/AppGroup ( Interface Availability Resource Threshold - Availability TEST1 ) (does not exist)

Info : === Update Histo : 0

Importing application group style sheets

resmgr -import agp -colNames "npath appS.name" -line "~AP MIB-II Pack~Interface~TEST1|_|AP TS Chart Style - Line - White - sum|_|"

Info : === insert : nothing ON Application Group ( ~AP MIB-II Pack~Interface~TEST1 ) (exists)

Info : === insert : nothing ON report style ( AP TS Chart Style -Line - White - sum ) (exists)

Info : === insert : INSERT ON report style Link ( AP TS Chart Style - Line - White - sum TEST1 ) (does not exist)

Info : === Update Histo : 0

Deleting reporters and reporter stylesheets

You must use the name column when importing new applications. Mandatory cols for app or appS : dbIndex or name

Mandatory cols for agp : dbIndex or npath

Deleting report stylesheets

resmgr -delete appS -colNames "name" -line "Import new report style"

Info : === delete : nothing ON report style ( Import new report style ) (does not exist)

Deleting report

resmgr -delete app -colNames "name" -line "New GST"

Info : === delete : nothing ON Application ( New GST ) (does not exist)

Deleting group report

resmgr -delete agp -colNames "npath" -line "~AP MIB-II Pack~Interface~TEST1"

Info : === DELETE GROUP : ~AP MIB-II Pack~Interface~TEST1 (index = 100008525)

Info : === delete : DELETE ON Application Group ( ~AP MIB-II Pack~Interface~TEST1 ) (exists)

Info : === Update Histo : 0

Unlinking a report from a report group

resmgr -delete linkGroupAPP -colNames "npath app.name" -line "~AP MIB-II Pack~Interface~TEST1|_|Interface Availability Resource Threshold - Availability"

Info : === delete : DELETE ON Link App/AppGroup ( Interface Availability Resource Threshold - Availability TEST1 ) (exists) Info : === Update Histo : 0

Unlinking a report style from a report group

resmgr -delete linkGroupAPPS -colNames "npath appS.name" -line

"~AP MIB-II Pack~Interface~TEST1|_|AP TS Chart Style - Line - White - sum|_|"

Info : === delete : DELETE ON report style Link ( AP TS Chart Style - Line - White - sum TEST1 ) (exists)

Info : === Update Histo : 0

Working with scheduler

This section contains the commands you can use to manage scheduler. When you use resgmr to work with scheduler, you work with the sched object type.

Exporting scheduler

Exporting general information

resmgr -export regisDV -colNames "path name value type" -filter

"path(DATAVIEW.SCHEDULER*)" -file $DIR/regisDV.dat

DATAVIEW.SCHEDULER.MASTER.LAST_UPDATE_TIME|_|LAST_UPDATE_TIME|_|1065455270804|_|0|_|

DATAVIEW.SCHEDULER.MASTER.OFFPEAK.START_TIME|_|START_TIME|_|79200000|_|0|_|

DATAVIEW.SCHEDULER.MASTER.OFFPEAK.END_TIME|_|END_TIME|_|25200000|_|0|_|

DATAVIEW.SCHEDULER.MASTER.LATEDATA.COMPLETION_TIME|_|COMPLETION_TIME|_|10800000|_|0|_|

DATAVIEW.SCHEDULER.MASTER.LATEDATA.WAIT_DAYS|_|WAIT_DAYS|_|0|_|0|_|

DATAVIEW.SCHEDULER.MASTER.OFFPEAK.MAX_PROCESSES|_|MAX_PROCESSES|_|20|_|0|_|

DATAVIEW.SCHEDULER.MASTER.PEAK.MAX_PROCESSES|_|MAX_PROCESSES|_|5|_|0|_|

DATAVIEW.SCHEDULER.MASTER.TASK.MAX_RUN_ONCE|_|MAX_RUN_ONCE|_|10|_|0|_|

DATAVIEW.SCHEDULER.MASTER.SLEEP_TIME|_|SLEEP_TIME|_|30000|_|0|_|

DATAVIEW.SCHEDULER.MASTER.CHECK_AFTER_NO_CYCLES|_|CHECK_AFTER_NO_CYCLES|_|5|_|0|_|

DATAVIEW.SCHEDULER.MASTER.QUEUE.MIN_SIZE_ALLOWED|_|MIN_SIZE_ALLOWED|_|5|_|0|_|

DATAVIEW.SCHEDULER.MASTER.QUEUE.MAX_SIZE_ALLOWED|_|MAX_SIZE_ALLOWED|_|40|_|0|_|

DATAVIEW.SCHEDULER.MASTER.TASK.MAX_PER_NOC|_|MAX_PER_NOC|_|100|_|0|_|

DATAVIEW.SCHEDULER.MASTER.TASK.MAX_PER_PSLA|_|MAX_PER_PSLA|_|50|_|0|_|

DATAVIEW.SCHEDULER.MASTER.TASK.MAX_PER_SLA|_|MAX_PER_SLA|_|10|_|0|_|

DATAVIEW.SCHEDULER.MASTER.TASK.MAX_REPORTS_NOC|_|MAX_REPORTS_NOC|_|100|_|0|_|

DATAVIEW.SCHEDULER.MASTER.TASK.MAX_REPORTS_PSLA|_|MAX_REPORTS_PSLA|_|50|_|0|_|

DATAVIEW.SCHEDULER.MASTER.TASK.MAX_REPORTS_SLA|_|MAX_REPORTS_SLA|_|50|_|0|_|

DATAVIEW.SCHEDULER.MASTER.ACCEPT_WITHIN_DAYS|_|ACCEPT_WITHIN_DAYS|_|1|_|0|_|

Exporting scheduler general information

resmgr -export sched -colNames "dbIndex name frequency state status start_DATE end_DATE type" -file $DIR/sched.dat

# type = sched

# col = dbIndex name frequency state status start_DATE end_DATE type

# cmdLine = -export sched -colNames "dbIndex name frequency state status start_DATE end_DATE type"

49000001|_|DAILY|_|DAILY|_|Assigned|_|http://pvdemo1.quallaby.com:8080/DV41|_|10/06/2003

Exporting scheduler consolidated report

resmgr -export sched -colNames "name app.name" -file

$DIR/sched_app.dat

# cmdLine = -export sched -colNames "name app.name"

DAILY|_|Daily Business Summary|_|<E>

DAILY|_|Daily High Level Summary|_|<E>

MONTHLY|_|Monthly SLA Report whole customers|_|<E>

DAILY|_|Tims Test Task|_|<E>

DAILY|_|Essai devoteam|_|<E>

DAILY|_|Sales|_|<E>

WEEKLY|_|Mcer|_|<E>

Export scheduler email recipient

resmgr -export sched -colNames "name app.name rusr.name rusr.mail rusr.type" -file $DIR/sched_mail.dat

# type = sched

# col = name app.name rusr.name rusr.mail rusr.type

# filter =

# order =

# sep = |_|

# sepRec = <E>

# cmdLine = -export sched -colNames "name app.name rusr.name rusr.mail rusr.type"

DAILY|_|Daily Business

Summary|_|Frankie|_|[email protected]|_|EMAIL RECIPIENT|_|<E>

DAILY|_|Daily High Level

Summary|_|Frankie|_|[email protected]|_|EMAIL RECIPIENT|_|<E>

DAILY|_|Tims Test Task|_|Tim|_|[email protected]|_|EMAIL RECIPIENT|_|<E>

WEEKLY|_|Mcer|_|Marcus|_|[email protected]|_|EMAIL RECIPIENT|_|<E>

MONTHLY|_|Monthly SLA Report whole

customers|_|Marcus|_|[email protected]|_|EMAIL RECIPIENT|_|<E>

DAILY|_|Essai devoteam|_|fama|_|[email protected]|_|EMAIL RECIPIENT|_|<E>

DAILY|_|Sales|_|FAMA|_|[email protected]|_|EMAIL RECIPIENT|_|<E>

DAILY|_|Sales|_|FDOU|_|[email protected]|_|EMAIL RECIPIENT|_|<E>

Importing scheduler

Use the export file , modify it and reimport it with the same column names.

Deleting scheduler

resmgr -delete sched -colNames "name"

In document IBM Tivoli Netcool Performance Manager Wireline Component Document Revision R2E1. Command Line Interface Guide (Page 155-169)