Script to Check Stock On Hand Availability across Inventory Organization

Hi

I am looking for Script to Check Stock On Hand Availability across Inventory Organization.

For an existing item we wanted to make some changes to Item Master but before  go ahead and make changes, we would like to know Stock of that Item under different Inventory Organization along with Stock Locator information.

We looked at View Multiple Organization  Quantity Report, but we do not see data, possibly due to user who is running report doesn't have access to all Inventory Organizations, we have 40+ Inventory orgs, hence was checking if we can run SQL Script