• State Verified Answer
  • Replies 2 replies
  • Subscribers 17 subscribers
  • Views 456 views
  • Users 0 members are here
Options

Find all objects needing redeploy.

Richard Lawrence

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.

Parents
  • +1

    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 

Reply
  • +1

    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 

Children
  • 0 in reply to Kristian Dahle

    Hi Kristian,  Thanks the query works nicely.   I hadn't even noticed License down there in the bot-left corner.  My eyes scanned the list and stopped at 'Close'.   It should be renamed to 'We had a few things left over and we didn't want to make more menu items so we threw them in here'.

© 2025 AVEVA Group Limited or its subsidiaries. All Rights Reserved.