Solved: Re: Creating SQL Report Using QC Database - Micro Focus Community

Zbyrd · ‎2012-06-19

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

Trudy Claspill · ‎2012-06-20

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

YValenzuela · ‎2012-06-19

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

Zbyrd · ‎2012-06-19

The link isn't working...

Trudy Claspill · ‎2012-06-19

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.)

Zbyrd · ‎2012-06-20

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

Trudy Claspill · ‎2012-06-20

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

Zbyrd · ‎2012-06-25

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.