TN AppSvr170 How to find a checked out object name in the galaxy(Security)

Detailed Steps

When you want to change security in a galaxy you sometimes get this error message below.

This means on object is checked out in the galaxy. But after looking in the Template Toolbox and Graphic Toolbox you not able to find the object.

To find the object you can open SQL Server Management Studio:

Once in SQL Server Management Studio you can create a new query against your galaxy name.

Then type this into the query box.

Select up.user_profile_name
,GOB.is_template
,GOB.tag_name
,GOB.hierarchical_name
,GOB.contained_name
From gobject GOB
Left Outer Join user_profile UP
on GOB.checked_out_by_user_guid = UP.user_guid
WHERE GOB.checked_out_by_user_guid is not null
OR GOB.checked_out_package_id <> 0

You will get something similar to the result below.

This query returns what object is checked out. Now you can search this name in the galaxy and check in the object.