Question

Need a way to export list of Forms processes that haven't run recently for cleanup purposes

Forms

Updated December 12, 2024

asked on December 12, 2024

We have a client that is needing a way to export a list of Forms processes to something like Excel. The intent here is to essentially find what processes they can delete for house cleaning purposes. They have MANY forms processes, and trying to use the Forms Reporting feature for this proved very tedious. We have to manually select all of their forms to add to the report, and it will only pull back instance variables (of which there are tens of thousands).

Does anyone know of a more efficient way, perhaps through SQL, that they can generate a report that can assist them in determining what processes they can remove from their system? Thanks in advance.

0 0

Replies

replied on December 12, 2024

The Cloud Assessment utility also shows some usage statistics. Check that out.

https://www.laserfiche.com/solutions/migration-tools/

4 0

replied on December 12, 2024

I forgot about that! That does show a nice view of what isn't being used.

0 0

replied on December 12, 2024

Try this in the Forms DB

WITH RankedInstances AS (
    SELECT 
        [bp_instance_id],
        [ref_bp_instance_id],
        [process_id],
        [start_date],
        [end_date],
        [status],
        [title],
        [user_snapshot_id],
        [lastacted_snapshot_id],
        [lastacted_date],
        [bp_name],
        [submission_data_removed],
        [stats_removed],
        [lastacted_comment],
        ROW_NUMBER() OVER (PARTITION BY [process_id] ORDER BY [start_date] desc) AS rn
    FROM 
        [LF_Forms].[dbo].[cf_bp_main_instances]
    WHERE 
        status = 2
)
SELECT 
    [bp_instance_id],
    [ref_bp_instance_id],
    [process_id],
    [start_date],
    [end_date],
    [status],
    [title],
    [user_snapshot_id],
    [lastacted_snapshot_id],
    [lastacted_date],
    [bp_name],
    [submission_data_removed],
    [stats_removed],
    [lastacted_comment]
FROM 
    RankedInstances
WHERE 
    rn = 1
ORDER BY 
    [start_date] asc;

This should let you see the most recent start date of each Process ID that is complete.

2 0

You are not allowed to follow up in this post.

Question

Question

Need a way to export list of Forms processes that haven't run recently for cleanup purposes

Replies

Sign in to reply to this post.