Service Desk Practitioners Forum
cancel

SQL query to report on Approvers

SOLVED
Go to solution
VDesai
Trusted Contributor.

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
Acclaimed 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