Results 1 to 3 of 3

Thread: Tracking

  1. #1
    Join Date
    Jul 2004
    Posts
    191

    Unanswered: Tracking

    Hi,

    I am trying to create a tracking spreadsheet for my SQL Servers in order to keep track of every thing.

    Here is a example of what I have:

    Date Tracking ID Server Issues Solution

    8/26/2004 6760 FORMSCAPEDOCS Backup fail Switch Transaction logs to the D:\ and left the database backup on the E:\

    Should I be more detailed and add some more fields and if yes can you recommend some.

    Thanks

  2. #2
    Join Date
    Jul 2004
    Posts
    191
    I didn't like the format the speadsheet below come out.

    Date Tracking ID Server Issues Solution

    8/26/2004 6760 FORMSCAPEDOCS Backup fail Switch Transaction logs to the D:\ and left the database backup on the E:\


    Here is the list of fields

    Date
    Tracking ID
    Server
    Issues

    I just thought of something I should have the database name.

    Thanks

    Lystra

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I track a few things...

    In one table I track generic information about the case itself.

    The Case id, which is an IDENTITY.

    The start date, which is when the problem was first reported, and can not be NULL.

    The end date, which is when the problem was closed (not necessarily resolved), which will be NULL if the case is still active.

    The server name, which can be NULL if the problem isn't specific to a given server.

    The Database name, which can be NULL if the problem isn't specific to a given database.

    The reporter, the employee number of the person that first reported the problem.

    The business owner, an employee number of the person that "owns" the case from the business perspective.

    In a separate table, I track each activity against the case.

    The activity ID, which is an identity.

    The case ID, which is from the case table.

    The employee ID of the person responsible for this activity.

    The effective_date, which is when this activity occured.

    A short description of the activity (25 characters).

    A column for notes about this activity.

    These seem to work for me.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •