MET/TEAM has been installed on the web server or the current PC, running standalone. The database installed is called METTEAM and can be accessed using the MET/TEAM application. The report writer has access to the database, via integrated security (domain account access) or an explicit user name and password, provided by the SQL Server® administrator.

The data used for demonstration purposes is what is available via the default database installation option.

Note: To successfully run the Turnaround Time Report on just the default data, it may be necessary to update CallSheetResults.nTechnicianUID with a valid Users.nUserUID.

This can be done like this, for example:

UPDATE dbo.CallsheetResults SET nTechnicianUID = (SELECT nUserUID FROM dbo.Users WHERE cUsername = 'fluke') WHERE nTechnicianUID IS NULL;

Furthermore, CallSheets.tOpenDate may contain the same value as CallSheets.tMaintDate. In order to produce a more illustrative report, an update like this may be of help:

UPDATE dbo.CallSheets SET tOpenDate = DATEADD(DAY,-2,tOpenDate) WHERE tOpenDate = tMaintDate

Do not run these updates on production data.