snapshots

Description

This table lists all the network images available in the database. Each image is identified by the "id_snapshot" field and this field is present in every WinReporter table.

Fields

Field name	Data type	Description
id_snapshot	number	Identifier of the network snapshot.
shot_time	time	Time when the scan of the snapshot began.

Example

For example, to view all the snapshots available in the database ordered by time, use the following SQL query:

SELECT * FROM snapshots ORDER BY shot_time