I need some DB help!

Discussion in 'OT Technology' started by MattR2, Sep 29, 2006.

  1. MattR2

    MattR2 New Member

    Joined:
    Sep 6, 2004
    Messages:
    408
    Likes Received:
    0
    so ive set up performance monitor alerts on all our servers and now id like to set up counters to do some informational and trend analysis.

    So you can save counter logs right to .csv files or to an sql database, unfortunately in my case access.

    Its just a big flat database, first field is the time then all the rest are the records taken for different counters.

    I would like to try and write a query that evaluates the time by the hour and then comes up with 1 average for each counter for that hour.

    All i can get in access is it to list all the recordings from a particular hour but i have no idea how to get it to give me just the avg of those records.

    please help!
     
  2. Peyomp

    Peyomp New Member

    Joined:
    Jan 11, 2002
    Messages:
    14,017
    Likes Received:
    0
    Post your schema, and we can help.
     

Share This Page