Seaward PATGuard Elite SQL - Manual (Page 34)

Seaward PATGuard Elite SQL 2 User Manual
- 32 - Rev. 1.4
Figure 23: Example PATGuard Elite SQL database tree
A Site may also contain a number of Locations, such as individual rooms or departments.
Asset View
By selecting a Site or Location from within the tree the right-hand view will display all the Assets within the
selected Site or Location.
The Asset text will be green if the Asset is untested, red if it is outside its re-test period and black if it is still within
the test period.
Each Asset View column (Description, Asset ID, Last Tested, Next Tested, Last Visual, Next Visual) can be
individually sorted in ascending or descending order by clicking the column title with the mouse pointer.
Main Window Operations
The following operations are allowed within PATGuard Elite SQL:
•
A Client can be created at the database level only.
•
A Site may be created at either the database level or from within an existing Client.
•
A Location can only be created from within a Site.
•
An Asset may be added directly to a Site or to a Location within a Site.
•
A Test Sequence can be created at a Client level only.
Clients, Sites and Locations may be added by either selecting the Add icon in the Asset display area or from the
tree using the context menu (right hand mouse button). Then depending upon the item highlighted:
•
Add Client… - Launches the Client Details dialog (see Adding Clients) to allow a new client to be created.
This is available only from the database.
•
Add Site… - Launches the Site Details dialog (see Adding Sites) to allow a new site to be created. This is
available only from the database and Client.
•
Add Location… - Launches the Location Details dialog (see Adding Locations) to allow a new location to be
created. This is available only from a Site.
All deleted Assets are placed in the Recycled bin. If the bin is emptied they will be deleted permanently. The
contents of the bin will be displayed if Recycled is selected. Assets can be retrieved from the bin by selecting the
Asset, right mouse click to display the context menu, then select Restore.