Find all objects needing redeploy.

Question

I'm using Aveva Application Server 2023 P03. How do you find all the objects that need to be redeployed? In the previous IDE there was a Galaxy->status that gave the block counts. I can't find that function in the new IDE. 
 I've looked in the Galaxy SQL database at the gobject table. This selection seems the best but that includes one object that the IDE shows as not needing deploy. 
 WHERE deployed_package_id != checked_in_package_id AND deployed_package_id != 0 ORDER BY tag_name 
 I tried using deployed_version != configuration_version but that listed lots of items that the IDE showed not needing deploy.

Kristian Dahle · Accepted Answer

Hi, you can find the object counts in: Galaxy -> License. In my opinion this "License" button should be renamed to "About"..

In the Galaxy DB you can list objects that needs redeployment with this query: select * 
 from [***GalaxyName***].[dbo].[internal_list_objects_view] 
 where is_template = 0 
 and HasPendingUpdate = 1

Find all objects needing redeploy.

Top Replies