Big news! The community will be moving to a new platform April 21. Read more.
Big news! The community will be moving to a new platform April 21. Read more.
Absent Member.. Absent Member..
Absent Member..
1762 views

Creating SQL Report Using QC Database

Jump to solution

I am creating a 6 month report that shows the: Number of users who have used QC in the last six months, the log in times and log out times. It shows the users full name and what area of work they are in.

When I access the server and database, it gives me a choose a table of ALL the users in our system and their session history.

I creat two spread sheets for the two tables (Users and Session history) What we've been doing is highlighting the end time column in the session history table and creating a pivot table sorting it by user and end time.

The issue is that not all of our user show up in the pivot table, though they are there in the user table. We have 410 users in the user table but only 193 users in the session history tab.

Why is that? Is there anything different we can do? Is that how it is?

Any help would be appreciated. Let me know if more information is needed to help answer the answer.

Thank you,

Zach

Tags (1)
0 Likes
1 Solution

Accepted Solutions
Absent Member.. Absent Member..
Absent Member..
Session History is retained for a period of time specified in the Site Configuration in Site Admin. It is highly likely that only 193 of your users have connected to QC in that time period. Session History tracks actual connections by users. Just because a user has an account doesn't mean that they have connected to QC.
[If this post solves or helps solve your issue, mark the thread as solved and give KUDOS to the author for their assistance.]

(Opinions expressed in my postings are mine alone, and do not reflect the opinions of my employer.No warranties express or implied for any solution/suggestion posted.)

View solution in original post

0 Likes
6 Replies
Absent Member.. Absent Member..
Absent Member..

The query from the following link can give you an idea of what to do.

Just play a little with the start_time and end_time

 

http://www.qualitycenterstepbystep.com/2012/users-connected-by-projects/

 

Kind regards

 


0 Likes
Absent Member.. Absent Member..
Absent Member..

The link isn't working...

0 Likes
Absent Member.. Absent Member..
Absent Member..
The link worked for me, just now.
[If this post solves or helps solve your issue, mark the thread as solved and give KUDOS to the author for their assistance.]

(Opinions expressed in my postings are mine alone, and do not reflect the opinions of my employer.No warranties express or implied for any solution/suggestion posted.)
0 Likes
Absent Member.. Absent Member..
Absent Member..

The website works now, and the query, but that's not the problem. The table isn't retriving all the log on times for the users, a portion of them and I don't know why. We have 410 users but only 193 of them show up in the Session_Histroy table. I'm just trying to figure out why that is.

 

Thanks for you help

0 Likes
Absent Member.. Absent Member..
Absent Member..
Session History is retained for a period of time specified in the Site Configuration in Site Admin. It is highly likely that only 193 of your users have connected to QC in that time period. Session History tracks actual connections by users. Just because a user has an account doesn't mean that they have connected to QC.
[If this post solves or helps solve your issue, mark the thread as solved and give KUDOS to the author for their assistance.]

(Opinions expressed in my postings are mine alone, and do not reflect the opinions of my employer.No warranties express or implied for any solution/suggestion posted.)

View solution in original post

0 Likes
Absent Member.. Absent Member..
Absent Member..

Thank you. This is what I was looking for. Unfortunately, I am not site admin so I'll have to talk to mine. Thank you very much.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.