Maintenance is complete- We've moved from the saas.hpe.com domain to softwaregrp.com click to read more
As part of our journey to complete our separation work and our future integration with Micro Focus, we've now updated our domain for the community. This is an interim step, which will be followed by a series of future update / improvements: - Piloting Idea boards - Refreshing the entire UI. (more to come later) - and more
Service Desk Practitioners Forum
cancel

SQL query to report on Approvers

SOLVED
Go to solution
Highlighted
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