SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 3 of 3
  1. #1
    Member
    Join Date
    Sep 2006
    Location
    Greensboro, NC
    Posts
    59
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Report for Users logged into system and Duration

    Is there a report (either canned or created) that I can run to report on the Users loged into Quality center (throughout the day) and the duration that they were logged in?

    Thanks,
    Gary
    Gary Hopson
    IT Quality Analyst
    Lorillard Tobacco Company
    Greensboro, NC

  2. #2
    Member
    Join Date
    Apr 2007
    Posts
    86
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Report for Users logged into system and Duration

    You can run a SQL query against the QCSITEADMIN_DB.SESSIONS_HISTORY table. For each connection, it provides start time, end time, domain and project, user ID, and client type (e.g., QC, "Testing Tool"/QTP, etc.). You can join this table to the QCSITEADMIN_DB.USERS table to get actual user names rather than user IDs.

    Extract that to an Excel spreadsheet and you can adjust the data and pivot it to your heart's content.

    Hope this helps.

    m.a.g.

  3. #3
    Member
    Join Date
    Sep 2006
    Location
    Greensboro, NC
    Posts
    59
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Report for Users logged into system and Duration

    Thanks AG,
    Unfortunately, since the tool does not expose this table, I will need to download SQL Express to run the Query.

    Thanks again,
    Gary
    Gary Hopson
    IT Quality Analyst
    Lorillard Tobacco Company
    Greensboro, NC

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 11.11%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 07:56 AM.

Copyright BetaSoft Inc.