General Functions > Import / Export > Secure File Transfer > Direct Database Transfers > Defining a query > Using the date parameter to send delta files

Each time a file is created by direct database access, the date/time the file was created is saved locally by the client. This timestamp can then be referenced in your query using the following tag:

{%V1%}

The tag will be filled in by the most recent timestamp from the last successful creation AND transfer of the file to the MIE.

Using this timestamp allows for sending deltas to the MIE (instead of entire data dumps each time). This is useful - albeit necessary - when dealing with very large volumes of data (such as auto-discovered hardware and software data).

This does require the presence of a column somewhere in the target source data that is maintained by the source system and contains the date of last update of the source system's record.

An example of how this works is:

SELECT * FROM Table WHERE LastUpdated>'{%V1%}'

Note: The first time the file transfer is scheduled there will be no date of last success (it will be blank). The client will substitute '1/1/1900' for the {%V1%} tag in that instance.

The current timestamp that will be substituted for the {%V1%} tag in your query can be viewed in the read-only fields on the left side of the screen in the field entitled Current {%V1%}.