Exporting the job list

The JobList export type creates a summary of the jobs and their results.

The export can be produced either as a CSV or JSON file.

In addition to the keys described in the Parameter file section, there are also other keys (listed below), which can be used for this specific export type.

Key Values
Dir

Relative path to the part of the Project tree that you want to be exported.

  • If this key is empty (default value), the whole Project tree will be exported. (With the exception of the directories and components, to which the user carrying the export has no access to).
  • If the key is not empty, the entry must be preceded by a backslash ("\").
  • It is also possible to enter the path to a component (with its name).

This key is ignored if a value is specified for ComponentID.

IncludeAllComponents

Determines whether components are listed, for which no jobs have been configured. This makes it possible, for example, to see at a glance whether two jobs have been set up for all Sinumerik components.

The following values are possible:

  • Y: Components without jobs are listed
  • N: Components without jobs are not listed (default value)

 

Example call:

VDogAutoExport.exe "/rd:D:\vdClientArchive" "/CFile:D:\Test\exportJobList.ini"

 

Parameter file CiCoLog.ini:

[Common]
ReportType=JobList
ExportFile=D:\Test\myJobList.csv
Dir=\SmartShopFloor

[User]
Account=versiondog
Password={Password}

 

List of attributes that can be found in the resulting file

Column

 Description
Component Name of the component (including its path in the Project tree)
ComponentID ID of the component (in GUID format)
ComponentTypeID ID of the component type (in GUID format)
ComponentTypeName Name of the component type
JobID ID of the job (in GUID format)
JobName Name of the job
UploadClass Upload type of the job
WhoToNotify List of users to be notified about the job execution
WhoToNotifyNames

Names of versiondog users to be notified about job executions

Multiple names are separated by commas.

This column is only displayed when sending emails about job executions is configured.

WhoToNotifyEMails

Email addresses of versiondog users who should be notified about job executions

Multiple email addresses are separated by commas.

This column is only displayed if sending emails about job executions is configured.
WhoToNotifyAdditional

Email addresses of users who do not have a versiondog account but should still be notified about job executions

Multiple email addresses are separated by commas.

This column is only displayed when sending emails about job executions is configured.
Execution

Execution status of the job

The following values are possible:

0: Not according to a schedule

1: According to a schedule

2: Using the BackupClient
IpOrComputername

IP address or computer name

The value is issued dependent on the upload class
UploadAgent

Computer name or IP address of agent

This value is only issued when an upload agent is assigned to the job.
CompareAgent

Computer name or IP address of agent

This value is only issued when an upload agent is assigned to the job.
LastCheck (local) Date of last scheduled job execution (local time)
LastCheck (UTC) Date of last scheduled job execution (UTC)
NextStart (local) Starting time of next scheduled job execution (local time)
NextStart (UTC) Starting time of next scheduled job execution (UTC)
JobStart (local) Actual start time of the last job execution (manual or scheduled) (local time)
JobStart (UTC) Actual start time of the last job execution (manual or scheduled) (UTC)
JobFinish (local)

End time of the last job execution (manual or scheduled) (local time)
JobFinish (UTC) End date of the last job execution (manual or planned) (UTC)
ResultVersionVsBackup

Result of the comparison between the version on the server and the backup.

A list of issued status codes and their descriptions can be found in the Job results section, located in the AdminClient tutorial.
ErrorVersionVsBackup The column only contains a value if an error has occurred when comparing Server version <-> Backup.
WarningVersionVsBackup The column only contains a value if an error has occurred when comparing Server version <-> Backup.
ResultBackupVsPreBackup

The result of the comparison between the current and previous backup.

A list of issued status codes and their descriptions can be found in the Job results section, located in the AdminClient tutorial.
WarningBackupVsPreBackup The column only contains a value if an error arose when comparing Previous backup <-> Backup.
ErrorBackupVsPreBackup The column only contains a value if an error arose when comparing the Previous backup <-> Backup.
DirBackup

The relative path of the directory in the server archive where the current backup of the job (Backup.zip file) was stored.
TimeStampBackup (local) Timestamp of the Backup.zip file (local time)
TimeStampBackup (UTC) Timestamp of the Backup.zip file (UTC).
DirPreBackup The relative path to the directory, in the server archive, where the previous backup of the job (Backup.zip file) was stored.
TimeStampBackup (local) Timestamp of the Backup.zip file of the previous backup (in local time).
TimeStampPreBackup (UTC) Timestamp of the Backup.zip file of the previous backup (UTC).

OutOfDate

Shows whether the period (since the last backup) is longer than the set value.

The following values are possible:

Y: The backup is out of date.

N: The backup is not out of date.

?: The job has never been executed or no backup was yet created.

VersionVsBackupVersionNumber

Version number of the data that was used for the version and backup comparison.

DeactivatedComment

Text entered when a job was deactivated.

 

Related topics

AdminClient -> Module jobs

Parameter file