You may be able to avoid having to install anything on the server by using the /action/query endpoint of the /api/atelier API to run a SQL query such as this:
SELECT
p.Name ASProject,
p.Description,
pi.Name AS Component,
pi.Type
FROM
%Studio.Project AS p,
%Studio.ProjectItem ASpiWHERE
p.Name = pi.Project
ORDERBYProject,
Component- Log in to post comments
.png)