how to pull Zephyr data base to reflect on the custom fields will count the tests on stories

[Vijay]

• • #of Total Tests – will count how many Test issue type are linked to that story
  • #of Passed Tests – will count how many Test issue type are linked to that story which are in status Passed
  • #of Failed Tests – will count how many Test issue type are linked to that story which are in status Failed
  • #of Not Executed Tests – will count how many Test issue type are linked to that story which are in all the rest of the statuses
• Fields should not be editable to anybody and should be calculated automatically

please suggest me a script for this