Hi @Qlikuser225
Are you on Sense Cloud or Client Managed (on-premise)?
If it is Client Managed, you will want to pull that information from a REST connection.
This code should do it, provided you have access to the connection:
// Connect to the REST connection
LIB CONNECT TO 'monitor_apps_REST_app';
// Load raw JSON Data
RawRESTData:
SQL SELECT
"id" AS "id_u1",
"createdDate",
"modifiedDate",
"modifiedByUserName",
"name" AS "name_u1",
"publishTime",
"published",
"description",
"fileSize",
"lastReloadTime",
"thumbnail",
"savedInProductVersion",
"availabilityStatus",
"schemaPath",
"__KEY_root",
(SELECT
"userId",
"userDirectory",
"name",
"__FK_owner"
FROM "owner" FK "__FK_owner"),
(SELECT
"name" AS "name_u0",
"__FK_stream"
FROM "stream" FK "__FK_stream")
FROM JSON (wrap on) "root" PK "__KEY_root";
This blog post gives a lot more detail on how to do this:
https://www.quickintelligence.co.uk/back-up-qlik-sense-applications/
Looking at what applications you have published on your Client Managed server and stats such as Last Reload Time is one of the example scripts that ships with my free Instant Sense Application. If you would like to take a look at this, you can do so here:
https://www.quickintelligence.co.uk/instant-qlik-sense-app/
Hope that is useful.
Steve
