1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

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