Be aware of upcoming changes to the Sheet Access and Published Items reports in Admin Center
Hi Community,
We wanted to share some details on upcoming changes we will be making to the Sheet Access and Published Items reports in the Smartsheet Admin Center.
Today, these reports can be time-consuming to generate and contain thousands of rows, making them difficult to consume.
To improve the experience and enable additional automationwe will be:
- Removing asset and workspace namesfrom the Sheet Access & Published Items reports and making this information retrievable through the newresource API URLandresource ID字段,所以your admins can automate the retrieval of the desired information.
- Removing theownerfieldfrom both reports and making this information retrievable through the newpermissions set namecolumn in the Sheet Access report, which will list each user or group and their shared permission.
These changes will go into effect onDecember 5, 2023.
With this change,admins may need to create scripts to consume the data within these reports– andsample Ruby scriptswill be provided as a reference. SysAdmins without the required expertise or access to programming tools are advised to work with their IT teams to create the necessary scripts to parse the report data.
Please note that you will still be able to view theshared toemail addressesin the new Sheet Access report as well as thepublishing useremail addressesin the new Published Items report without any custom scripting.
For more information, please refer to thishelp article. If you have any further questions or feedback, please fill out thisformand a member of the Smartsheet team will get back to you.
You can also stay informed bysubscribing to receive product release updates.
Best regards,
The Smartsheet Product Team
Comments
-
Scott Peters ✭✭✭✭✭@Lekshmi Unnithan- Would it be possible to for you to post examples of what the revised reports will look like? For example, will the columns now be blank or removed all together? Will any other columns be renamed or change position? We will need to update data shuttle jobs and test this well in advance so our current automations do not break.
-
Sarah Keortge ✭✭✭
Yes, please provide examples so that your customers can begin planning for this change. This is critical data and for many organizations it takes time to get IT resources lined up for supporting something like this. A month is short notice.
