1. Please help support our sponsors by considering their products and services.
    Our sponsors enable us to maintain high-speed Internet connection and fast webservers.
    They support this free information and knowledge exchange forum service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions

SQL Select Question

Discussion in 'Scripting' started by Andrew21210, Jul 7, 2017.

  1. Andrew21210

    Andrew21210 ADSM.ORG Member

    Joined:
    Apr 10, 2008
    Messages:
    82
    Likes Received:
    1
    This may not be possible but I will post here before giving up. I am trying to find out the total number of mounts associated with a restore that I did awhile ago. Is it possible to build a select statement using the session id to get this info?
     
  2.  
  3. CoMaboy

    CoMaboy ADSM.ORG Senior Member

    Joined:
    Jun 4, 2012
    Messages:
    71
    Likes Received:
    11
    This should be enough to get you started.
    Code:
    select date(date_time) date, session, count(*) mounts from actlog where msgno=0510 group by date(date_time), session order by 1,2 
     
    Last edited by a moderator: Aug 3, 2017

Share This Page