Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

SQL query to report on Approvers

SOLVED
Go to solution
Highlighted
VDesai
Super Collector

SQL query to report on Approvers

Hello,

I need to know if some one has developed a query to extract from OVSD 4.5 (SQL 2000) the following:
- Approvers (Name of the Approver) and the Change tickets that they voted on - along with their vote.

As Approvers are not accessible via the Views, its difficult to respond to the most basic of the audit questions: WHO Voted WHAT on WHICH Changes?

Thanks,
Vishal
1 REPLY
George M. Meneg
Honored Contributor
Solution

Re: SQL query to report on Approvers

Hello Vishal,

Votes are stores on table ITSM_APPROVER_VOTES

join this table with ITSM_CHANGES on ITSM_APPROVER_VOTES.APV_APT_OID=ITSM_CHANGES.CHA_OID and with ITSM_PERSONS on ITSM_APPROVER_VOTES.APV_PER_OID=ITSM_PERSONS.PER_OID
to get information about change and person.
menes fhtagn
//Add this to "OnDomLoad" event