D.70. tarantella query billing

Outputs billing information for the array, or for a subset of the array, over a time period. Information is displayed on screen in CSV format.

Syntax

tarantella query billing { --full | --sessions | --summary }
                           --start date
                           --days days
                           --end date
                         [ --servers arrayhost... ]

Description

The following table shows the available options for this command.

Option

Description

--full

Displays detailed information for all user sessions and application sessions.

--sessions

Displays information for all application sessions.

--summary

Displays a short summary of billing information and an application session summary.

--start

Specifies the start of the billing period. The format is YYYY/MM/DD, for example, "2000/05/01".

--days

Specifies the number of days from the date specified by --start to display billing information.

--end

Specifies the end of the billing period. The format is YYYY/MM/DD, for example, “2000/05/02”. The end date is exclusive. This means, for example, that --start 2001/01/19 --end 2001/01/23 is the same as --start 2001/01/19 --days 4. Both examples query data covering the 19th, 20th, 21st, and 22nd.

--servers

Only reports billing information from the named SGD servers. Use peer DNS names. If you omit --servers, billing information across the array is reported.

The billing files are written at midnight local time each day.

You must run this command on the primary server in the array.

Note

You must enable billing services, see Section A.9.2, “Billing Service”, and restart all SGD servers in the array before any data is logged.

Examples

The following example displays billing information for the entire array, for the 30 days from May 1, 2000.

# tarantella query billing --full \
--start "2000/05/01" --days 30

The following example displays a short summary of billing information for the servers prague and paris, for the 30 days from January 1 2000.

# tarantella query billing --summary \
--start "2000/01/01" --days 30 \
-- servers prague.example.com paris.example.com

The following example displays billing information for all application sessions for the entire array for the period January 19 2001 to January 22 2001 and outputs the results to a file called Sessions.csv.

# tarantella query billing --sessions \
--start "2000/01/19" --end "2000/01/23" > sessions.csv