Hi,

Why would this be handy and especially when its done by Outsystems?

Because you can retrieve the information yourself

You can get this information already from OutSystems, and create a function to export it to excel or not?

Good morning,

How can you retrieve the information? 

I mean, I only can see a list on service studio, if I have more than 200 applications and want to keep track of them it would be nice to be able to export.

OutSystems stores all of it's metadata information in the database, so if you have access to that, it's likely the easiest way.  All of the tables you'd be interested in would be prefixed by OSSYS_***.  I believe you can get access to all of these tables as imports from (System) within OutSystems itself.

An example query to get the information you're requesting at the Espace level would be:

select ev.Espace_Id, ev.espace_name, Uploaded_Date, (SELECT u.NAME FROM ossys_User u WHERE u.Id = ev.Uploaded_By) Updated_By
FROM (
    select Espace_Id, MAX(Uploaded_Date) Latest_Upload_Date
    FROM ossys_Espace_Version
    GROUP BY Espace_Id
) as m
INNER JOIN ossys_Espace_Version as ev ON m.Espace_Id = ev.Espace_Id AND m.Latest_Upload_Date = ev.Uploaded_Date
ORDER BY ev.Espace_Id

If you want it at the Application Level, it's a bit trickier as you have to aggregate up the espace information...but the tables you'd be interested in are: OSSYS_APPLICATION, OSSYS_APP_DEFINITION_MODULE and OSSYS_MODULE.

Thank you John!

But it would be so practical to have an export button that could do that for us.

Regards

Agreed...But it should be a fairly simple component to write, and put out on the forge.

Vania,

Why do you need to keep track of those 200 applications?

(and why do you need that in an excel?)

I am asking, because I still do not understand WHY you need it?

Good morning J.,

We need to keep track of all the apps, who own them and which ones are still relevant.

And for that maintenance, it's easier if everything it's on a list, with some details like last modified on and by who.

It's a matter of tracking cause it's an environment used by a lot of people.

I hope I was clearer now. Sorry