How to get the list of approvers

[mdsh]

Hi,

We want a list of users who have been approvers in last 6 months.

I went to sysapproval_approver table and ran a filter (created at of after last 6 months). But this list is huge and I am unable to export it due to SNOW limitation.

Is there any other way?

Thanks

[Ankur Bawiskar]

Hi,

So you are facing the issue while exporting the records.

What type of export you want csv, xls or xml

There is a default limit for each type which can be configured in the system.

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Jaspal Singh]

Hi,

If the issue is with Export I would suggest you to go through the export thresolds for extract. Also, you can try changing the export form to CSV instead of Excel for better results.

Thanks,

Jaspal Singh

Hit Helpful or Correct on the impact of response.

[mdsh]

Thanks Jaspal. I added the export limit property and exported them in csv format.

[Jaspal Singh · Accepted solution]

Glad to know it helped.

If you got what was expected you can mark this thread as Correct & close so that it does not appear in unanswered list.

Thanks,

Jaspal Singh

Hit Helpful or Correct on the impact of response.