Download Total Visual Agent Manual

Object View
Database Statistics Snapshot Inquiry Form—Object View
The Object View of the Database Statistics Snapshot Inquiry form displays
object count statistics for a database over time.
As with Snapshot View, you can filter by database and by date. The “<ALL>”
choice for database, however, is not valid for Object View, since you can
only view one database at a time.
Generating Statistical Snapshot Reports
Total Visual Agent stores Database Statistics snapshot entries in a table
called “tblSysStatSnapShot” in the Total Visual Agent configuration
database named TVAGENT15.MDB. This table stores one record for each
snapshot that was taken. A related table named
“tblSysStatSnapShotTableDetail” stores one row for each table that was
checked when the snapshot was taken.
You may use Microsoft Access, or another database reporting tool to create
reports based on the Total Visual Agent Database Statistics tables. Several
Access reports are provided in the database for your use. Feel free to
modify or copy these reports. See 99 for more information about using this
database and the included reports.
104  Chapter 7: Other Management Features
Total Visual Agent