CSV output using commands

Management Information

Management information is acquired for a remote HULFT, converted into CSV format, and output to a file.

Management Information CSV Output Command

mansyscsv -c connectID -f filename [-o n|r|a] [-cd] [-dt] [-nt] 
          -i {snd|rcv|job|hst|tgrp|fmt|mfmt|mail|sch|trg|env} [-id id]

Explanation of the parameters

-c connectID

Specify the Connect ID of the host to which the request is to be issued. (Mandatory)

For details about the Connect ID, refer to Initial settings.

-f filename

Specify the file name to be output. (Mandatory)

-o n|r|a

Specify an action to be carried out when the file is present. (Optional)

n (new creation):

An error occurs if the file already exists.

r (replace):

Content is cleared if the file already exists.

a (append):

The data is added at the end of the content if the file already exists.

If omitted, 'n (new creation)' is set.

If the file does not exist, the file is created regardless of the mode.

-cd

Specify whether to output the CSV Output Condition Settings to a CSV file. (Optional)

If omitted, the CSV Output Condition Settings is not output.

-dt

Specify whether to output the date when the data was output to a CSV file. (Optional)

If omitted, the date of CSV output is not output.

The date is displayed in the format that is set in Date Format in the System Environment Settings.

-nt

Specify whether to output the title to the CSV file. (Optional)

If omitted, the title will be output.

-i {snd|rcv|job|hst|tgrp|fmt|mfmt|mail|sch|trg|env}

Specify the management information to be output in CSV format. (Mandatory)

snd:

Send Management Information

rcv:

Receive Management Information

job:

Job Information

hst:

Host Information

tgrp:

Transfer Group Information

fmt:

Format Information

mfmt:

Multi Format Information

mail:

Mail Interface Information

sch:

Schedule Information

trg:

File Trigger Information

env:

System Environment Settings

-id id

Specify the ID to be output. (Optional)

If omitted, it will be applicable to all IDs.

= Remarks =

You can use a wild card (prefix match*) in the value for the argument -id. If a wild card is specified, entries that match the string that comes before the wild card will be retrieved. (Only prefix match is supported.)

Usage example

[Example 1]

The Host Information records of which host IDs starting with an 'x' are acquired from the management host (hp2) that is registered with the Connect ID 'hp2,' and the records are output to a file in CSV format. The title will be output to the file.

  1. Register HULFT at the destination host as the management host (hp2) on the Hosts screen.

    When registering the management host, specify 'hp2' for Connect ID.

  2. Execute the Management Information CSV Output command.

> mansyscsv -c hp2 -f c:\temp\hp2_hst.csv -i hst -id x*

[Example 2]

The System Environment Settings information for the management host (hp2) that is registered with the Connect ID 'hp2' is acquired and output to a file in CSV format. The title will not be output to the file.

  1. Register HULFT at the destination host as the management host (hp2) on the Hosts screen.

    When registering the management host, specify 'hp2' for Connect ID.

  2. Execute the Management Information CSV Output command.

> mansyscsv -c hp2 -f c:\temp\hp2_env.csv -nt -i env

Log

The log (Send Log, Receive Log, Schedule Log, Transfer Status, Resend Queue Status, or Today's Schedule) is acquired for a remote HULFT and output to a CSV format file.

Log CSV Output Command

manlogcsv -c connectID -f filename [-o n|r|a] [-cd] [-dt] [-nt] 
          [-from date1] [-fromt hhmmss1] [-to date2] [-tot hhmmss2] 
          -l {snd|rcv|sch|sndq|rsndq|tsch} [-id fileid] [-h hostname] [-ab] 
          [-s s|r|a]

Explanation of the parameters

-c connectID

Specify the Connect ID of the host to which the request is to be issued. (Mandatory)

-f filename

Specify the file name to be output. (Mandatory)

-o n|r|a

Specify an action to be carried out when the file is present. (Optional)

n (new creation):

An error occurs if the file already exists.

r (replace):

Content is cleared if the file already exists.

a (append):

The data is added at the end of the content if the file already exists.

If omitted, 'n (new creation)' is set.

If the file does not exist, the file is created regardless of the mode.

-cd

Specify whether to output the CSV Output Condition Settings to a CSV file. (Optional)

If omitted, the CSV Output Condition Settings is not output.

-dt

Specify whether to output the date when the data was output to a CSV file. (Optional)

If omitted, the date of CSV output is not output.

The date is displayed in the format that is set in Date Format in the System Environment Settings.

-nt

Specify whether to output the title to the CSV file. (Optional)

If omitted, the title will be output.

-from date1

Specify the start date for the range of log records. (Optional)

Specify in line with the setting for Date Format, using one of the following formats:

  • 'yyyymmdd'

  • 'mmddyyyy'

  • 'ddmmyyyy'

If omitted, the oldest date in the log will be applied.

-fromt hhmmss1

Specify the start time for the range of log records. (Optional)

Use the 'hhmmss' format.

If omitted, the oldest time in the log for the relevant date will be applied. Time cannot be specified without a date.

-to date2

Specify the end date for the range of log records. (Optional)

Specify in line with the setting for Date Format, using one of the following formats:

  • 'yyyymmdd'

  • 'mmddyyyy'

  • 'ddmmyyyy'

You can specify this parameter only when you specify 'snd (Send Log),' 'rcv (Receive Log),' or 'sch (Schedule Log)' for the -l parameter. If omitted, the latest date in the log will be applied.

-tot hhmmss2

Specify the end time for the range of log records. (Optional)

Use the 'hhmmss' format.

You can specify this parameter only when you specify 'snd (Send Log),' 'rcv (Receive Log),' or 'sch (Schedule Log)' for the -l parameter. If omitted, the latest time in the log for the relevant date will be applied. Time cannot be specified without a date.

-l {snd|rcv|sch|sndq|rsndq|tsch}

Specify the log to be output in CSV format. (Mandatory)

snd:

Send Log

rcv:

Receive Log

sch:

Schedule Log

sndq:

Transfer Status

rsndq:

Resend Queue Status

tsch:

Today's Schedule

-id fileid

Specify the ID to be output. (Optional)

You can specify this parameter only when you specify 'snd (Send Log),' 'rcv (Receive Log),' or 'sch (Schedule Log)' for the -l parameter.

If omitted, this command will be applied to all IDs.

-h hostname

Specify the host name to be output. (Optional)

You can specify this parameter only when you specify 'snd (Send Log)' or 'rcv (Receive Log)' for the -l parameter.

If omitted, this command will be applied to all hosts.

-ab

Specify this parameter to output only the log records of transfers that terminated unsuccessfully. (Optional)

If omitted, both the log records of transfers that terminated successfully and of those that terminated unsuccessfully will be output.

-s s|r|a

Used for Transfer Status. (Optional)

Specify this parameter if you specify 'sndq (Transfer Status)' for the -l parameter.

s:

Only send

r:

Only receive

a:

Send and receive

Usage example

[Example 1]

The Send log records for the file ID 'FILE01' and the host name 'mspx' are acquired from the management host (hp2) that is registered with the Connect ID 'hp2,' and the records are output to a file in CSV format. The title will be output to the file.

  1. Register HULFT at the destination host as the management host (hp2) on the Hosts screen.

    When registering the management host, specify 'hp2' for Connect ID.

  2. Execute the Log CSV Output command.

> manlogcsv -c hp2 -f c:\temp\hp2_sndlog.csv -l snd -id FILE01 -h mspx

[Example 2]

The Schedule log records of schedules that were started on December 11, 2014 are acquired from the management host (xs347d) that is registered with the Connect ID 'NT,' and the records are output to a file in CSV format. The title will not be output to the file.

  1. Register HULFT at the destination host as the management host (xs347d) on the Hosts screen.

    When registering the management host, specify 'NT' for Connect ID.

  2. Execute the Log CSV Output command.

> manlogcsv -c NT -f c:\temp\hp2_env.csv -nt -from 20141211 -to 20141211 -l sch

Observe Log

The Observe log records are acquired for the remote HULFT, converted into CSV format, and output to a file.

Observe Log CSV Output Command

manobscsv -c connectID -f filename [-o n|r|a] [-cd] [-dt] [-nt] 
          [-from date1] [-fromt hhmmss1] [-to date2] [-tot hhmmss2] 
          [-s service] [-ab]

Explanation of the parameters

-c connectID

Specify the Connect ID of the host to which the request is to be issued. (Mandatory)

-f filename

Specify the file name to be output. (Mandatory)

-o n|r|a

Specify an action to be carried out when the file is present. (Optional)

n (new creation):

An error occurs if the file already exists.

r (replace):

Content is cleared if the file already exists.

a (append):

The data is added at the end of the content if the file already exists.

If omitted, 'n (new creation)' is set.

If the file does not exist, the file is created regardless of the mode.

-cd

Specify whether to output the CSV Output Condition Settings to a CSV file. (Optional)

If omitted, the CSV Output Condition Settings is not output.

-dt

Specify whether to output the date when the data was output to a CSV file. (Optional)

If omitted, the date of CSV output is not output.

-nt

Specify whether to output the title to the CSV file. (Optional)

If omitted, the title will be output.

-from date1

Specify the start date for the range of log records. (Optional)

Specify in line with the setting for Date Format, using one of the following formats:

  • 'yyyymmdd'

  • 'mmddyyyy'

  • 'ddmmyyyy'

If omitted, the oldest date in the log will be applied.

-fromt hhmmss1

Specify the start time for the range of log records. (Optional)

Use the 'hhmmss' format.

If omitted, the oldest time in the log for the relevant date will be applied. Time cannot be specified without a date.

-to date2

Specify the end date for the range of log records. (Optional)

Specify in line with the setting for Date Format, using one of the following formats:

  • 'yyyymmdd'

  • 'mmddyyyy'

  • 'ddmmyyyy'

If omitted, the latest date in the log will be applied.

-tot hhmmss2

Specify the end time for the range of log records. (Optional)

Use the 'hhmmss' format.

If omitted, the latest time in the log for the relevant date will be applied. Time cannot be specified without a date.

-s service

Specify the service name to be output in CSV format. (Optional)

If omitted, this command will be applied to all services.

-ab

Specify this parameter to output only the log records of transfers that terminated unsuccessfully. (Optional)

If omitted, both the log records of transfers that terminated successfully and of those that terminated unsuccessfully will be output.

Usage example

[Example 1]

The Send Request log records are acquired from the management host (hp2) that is registered with the Connect ID 'hp2,' and the records are output to a file in CSV format. The title will be output to the file.

  1. Register HULFT at the destination host as the management host (hp2) on the Hosts screen.

    When registering the management host, specify 'hp2' for Connect ID.

  2. Execute the Observe Log CSV Output command.

> manobscsv -c hp2 -f c:\temp\hp2_sndlog.csv -s SEND

[Example 2]

The log records of all services requested on December 11, 2014 are acquired from the management host (xs347d) registered with the Connect ID 'NT,' and the records will be output to a file in CSV format. The title will not be output to the file.

  1. Register HULFT at the destination host as the management host (xs347d) on the Hosts screen.

    When registering the management host, specify 'NT' for Connect ID.

  2. Execute the Observe Log CSV Output command.

> manobscsv -c NT -f c:\temp\hp2_env.csv -nt -from 20141211 -to 20141211