Provided by: pcp-export-pcp2xlsx_6.2.0-1.1build4_amd64 bug

NAME

       pcp2xlsx - pcp-to-xlsx metrics exporter

SYNOPSIS

       pcp2xlsx  [-5CGHILmrRvVz?]   [-4  action]  [-a archive] [-A align] [--archive-folio folio]
       [-b|-B space-scale] [-c config] [--container container]  [--daemonize]  [-e  derived]  [-f
       format]  [-F  outfile]  [-h  host]  [-i instances] [-K spec] [-O origin] [-P|-0 precision]
       [-q|-Q count-scale] [-s samples] [-S starttime] [-t interval] [-T  endtime]  [-y|-Y  time-
       scale] [-Z timezone] metricspec [...]

DESCRIPTION

       pcp2xlsx  is  a  customizable  performance  metrics  exporter  tool from PCP to XLSX.  Any
       available performance metric, live or archived, system and/or application, can be selected
       for exporting using either command line arguments or a configuration file.

       pcp2xlsx  is  a  close  relative  of  pmrep(1).   Refer  to  pmrep(1)  for  the metricspec
       description accepted on pcp2xlsx command line.  See pmrep.conf(5) for description  of  the
       pcp2xlsx.conf  configuration  file  syntax.  This page describes pcp2xlsx specific options
       and configuration file differences with pmrep.conf(5).  pmrep(1)  also  lists  some  usage
       examples of which most are applicable with pcp2xlsx as well.

       Only  the  command line options listed on this page are supported, other options available
       for pmrep(1) are not supported.

       Options via environment values (see pmGetOptions(3)) override the  corresponding  built-in
       default   values   (if  any).   Configuration  file  options  override  the  corresponding
       environment  variables  (if  any).   Command  line  options  override  the   corresponding
       configuration file options (if any).

CONFIGURATION FILE

       pcp2xlsx  uses a configuration file with syntax described in pmrep.conf(5).  The following
       options are common with pmrep.conf: version, source, speclocal, derived, header,  globals,
       samples, interval, type, type_prefer, ignore_incompat, names_change, instances, omit_flat,
       include_labels, precision, precision_force, count_scale,  count_scale_force,  space_scale,
       space_scale_force,  time_scale,  time_scale_force.  The rest of the pmrep.conf options are
       recognized but ignored for compatibility.

   pcp2xlsx specific options
       None.

OPTIONS

       The available command line options are:

       -0 precision, --precision-force=precision
            Like -P but this option will override per-metric specifications.

       -4 action, --names-change=action
            Specify which action to  take  on  receiving  a  metric  names  change  event  during
            sampling.   These  events  occur  when  a  PMDA  discovers new metrics sometime after
            starting up, and informs running client tools like pcp2xlsx.  Valid values for action
            are  update  (refresh  metrics  being  sampled),  ignore  (do  nothing  - the default
            behaviour) and abort (exit the program if such an event occurs).

       -5, --ignore-unknown
            Silently ignore any metric name that cannot be resolved.  At least one metric must be
            found for the tool to start.

       -a archive, --archive=archive
            Performance  metric  values  are retrieved from the set of Performance Co-Pilot (PCP)
            archive files identified by the archive argument, which is a comma-separated list  of
            names,  each  of  which may be the base name of an archive or the name of a directory
            containing one or more archives.

       -A align, --align=align
            Force the initial sample to be aligned on the boundary of a natural time unit  align.
            Refer to PCPIntro(1) for a complete description of the syntax for align.

       --archive-folio=folio
            Read  metric  source  archives  from  the  PCP  archive  folio  created by tools like
            pmchart(1) or, less often, manually with mkaf(1).

       -b scale, --space-scale=scale
            Unit/scale for space (byte) metrics,  possible  values  include  bytes,  Kbytes,  KB,
            Mbytes,  MB,  and  so  forth.   This  option  will  not  override possible per-metric
            specifications.  See also pmParseUnitsStr(3).

       -B scale, --space-scale-force=scale
            Like -b but this option will override per-metric specifications.

       -c config, --config=config
            Specify the config file or directory to use.  In case config is a directory all files
            in  it  ending  .conf  will  be  included.   The  default  is  the  first  found  of:
            ./pcp2xlsx.conf,       $HOME/.pcp2xlsx.conf,       $HOME/pcp/pcp2xlsx.conf,       and
            $PCP_SYSCONF_DIR/pcp2xlsx.conf.    For   details,   see   the   above   section   and
            pmrep.conf(5).

       --container=container
            Fetch performance metrics from the specified container, either local or  remote  (see
            -h).

       -C, --check
            Exit before reporting any values, but after parsing the configuration and metrics and
            printing possible headers.

       --daemonize
            Daemonize on startup.

       -e derived, --derived=derived
            Specify derived performance metrics.  If derived starts with a slash (``/'') or  with
            a  dot  (``.'')  it  will be interpreted as a PCP derived metrics configuration file,
            otherwise it will be interpreted as  comma-  or  semicolon-separated  derived  metric
            expressions.   For  complete  description  of derived metrics and PCP derived metrics
            configuration   files   see    pmLoadDerivedConfig(3)    and    pmRegisterDerived(3).
            Alternatively,  using  pmrep.conf(5)  configuration  syntax  allows  defining derived
            metrics as part of metricsets.

       -G, --no-globals
            Do not include global metrics in reporting (see pmrep.conf(5)).

       -f format, --timestamp-format=format
            Use the format string for formatting the timestamp.  The format  will  be  used  with
            Python's  datetime.strftime  method  which  is  mostly  the same as that described in
            strftime(3).  The default is %Y-%m-%d %H:%M:%S.

       -F outfile, --output-file=outfile
            Specify the output file outfile.

       -h host, --host=host
            Fetch performance metrics  from  pmcd(1)  on  host,  rather  than  from  the  default
            localhost.

       -H, --no-header
            Do not print any headers.

       -i instances, --instances=instances
            Retrieve and report only the specified metric instances from currently present metric
            instances.  By default all current instances are reported.

            Refer to pmrep(1) for complete description of this option.

       -I, --ignore-incompat
            Ignore incompatible metrics.  By default incompatible metrics (that is, their type is
            unsupported  or  they cannot be scaled as requested) will cause pcp2xlsx to terminate
            with an error message.  With  this  option  all  incompatible  metrics  are  silently
            omitted from reporting.  This may be especially useful when requesting non-leaf nodes
            of the PMNS tree for reporting.

       -K spec, --spec-local=spec
            When fetching metrics from a local context (see -L), the -K option  may  be  used  to
            control  the DSO PMDAs that should be made accessible.  The spec argument conforms to
            the syntax described in pmSpecLocalPMDA(3).  More than one -K option may be used.

       -L, --local-PMDA
            Use a local context to collect metrics from DSO PMDAs on the local host without PMCD.
            See also -K.

       -m, --include-labels
            Include PCP metric labels in the output.

       -O origin, --origin=origin
            When  reporting  archived  metrics,  start reporting at origin within the time window
            (see -S and -T).  Refer to PCPIntro(1) for a complete description of the  syntax  for
            origin.

       -P precision, --precision=precision
            Use precision for numeric non-integer output values.  The default is to use 3 decimal
            places  (when  applicable).   This  option  will  not  override  possible  per-metric
            specifications.

       -q scale, --count-scale=scale
            Unit/scale  for  count metrics, possible values include count x 10^-1, count, count x
            10, count x 10^2, and so forth from 10^-8  to  10^7.   (These  values  are  currently
            space-sensitive.)   This option will not override possible per-metric specifications.
            See also pmParseUnitsStr(3).

       -Q scale, --count-scale-force=scale
            Like -q but this option will override per-metric specifications.

       -r, --raw
            Output raw metric values, do not convert cumulative counters to rates.   This  option
            will override possible per-metric specifications.

       -R, --raw-prefer
            Like -r but this option will not override per-metric specifications.

       -s samples, --samples=samples
            The  samples argument defines the number of samples to be retrieved and reported.  If
            samples is 0 or -s is not specified, pcp2xlsx will sample and report continuously (in
            real  time  mode) or until the end of the set of PCP archives (in archive mode).  See
            also -T.

       -S starttime, --start=starttime
            When reporting archived metrics, the report  will  be  restricted  to  those  records
            logged at or after starttime.  Refer to PCPIntro(1) for a complete description of the
            syntax for starttime.

       -t interval, --interval=interval
            Set the reporting interval to  something  other  than  the  default  1  second.   The
            interval  argument  follows  the syntax described in PCPIntro(1), and in the simplest
            form may be an unsigned integer (the implied units in this case  are  seconds).   See
            also the -T option.

       -T endtime, --finish=endtime
            When  reporting  archived  metrics,  the  report  will be restricted to those records
            logged before or at endtime.  Refer to PCPIntro(1) for a complete description of  the
            syntax for endtime.

            When  used  to  define  the runtime before pcp2xlsx will exit, if no samples is given
            (see -s) then the number of reported  samples  depends  on  interval  (see  -t).   If
            samples  is given then interval will be adjusted to allow reporting of samples during
            runtime.  In case all of -T, -s, and -t are given, endtime determines the actual time
            pcp2xlsx will run.

       -v, --omit-flat
            Report  only  set-valued metrics with instances (e.g. disk.dev.read) and omit single-
            valued ``flat'' metrics without instances (e.g.  kernel.all.sysfork).  See -i and -I.

       -V, --version
            Display version number and exit.

       -y scale, --time-scale=scale
            Unit/scale for time metrics, possible  values  include  nanosec,  ns,  microsec,  us,
            millisec,  ms,  and  so forth up to hour, hr.  This option will not override possible
            per-metric specifications.  See also pmParseUnitsStr(3).

       -Y scale, --time-scale-force=scale
            Like -y but this option will override per-metric specifications.

       -z, --hostzone
            Use the local timezone of the host that is the source of the performance metrics,  as
            identified by either the -h or the -a options.  The default is to use the timezone of
            the local host.

       -Z timezone, --timezone=timezone
            Use timezone for the date and time.  Timezone is in the  format  of  the  environment
            variable  TZ  as described in environ(7).  Note that when including a timezone string
            in output, ISO 8601 -style UTC offsets are used (so  something  like  -Z  EST+5  will
            become UTC-5).

       -?, --help
            Display usage message and exit.

FILES

       pcp2xlsx.conf
            pcp2xlsx configuration file (see -c)

       $PCP_SYSCONF_DIR/pmrep/*.conf
            system provided default pmrep configuration files

PCP ENVIRONMENT

       Environment variables with the prefix PCP_ are used to parameterize the file and directory
       names used by PCP.  On each installation, the file /etc/pcp.conf contains the local values
       for  these  variables.   The  $PCP_CONF  variable  may  be  used to specify an alternative
       configuration file, as described in pcp.conf(5).

       For environment variables affecting PCP tools, see pmGetOptions(3).

SEE ALSO

       PCPIntro(1),  mkaf(1),  pcp(1),  pcp2elasticsearch(1),  pcp2graphite(1),  pcp2influxdb(1),
       pcp2json(1),   pcp2spark(1),  pcp2xml(1),  pcp2zabbix(1),  pmcd(1),  pminfo(1),  pmrep(1),
       pmGetOptions(3),   pmLoadDerivedConfig(3),    pmParseUnitsStr(3),    pmRegisterDerived(3),
       pmSpecLocalPMDA(3), LOGARCHIVE(5), pcp.conf(5), pmrep.conf(5), PMNS(5) and environ(7).