Is there a SQL query to List Job Names Nested Under a Particular Folder in the GSS Console?

Products

• Ghost Solution Suite

Issue/Introduction

In the Ghost Solution Suite console you have a folder(s) that you want to know what jobs are inside them.  Is there a SQL query you can run to product these results?

Environment

Release : 3.3

Resolution

Yes, you can see this information using the following query:

select ev.name as [Job Name], evf.name as [Folder Name]
from event ev
join dbo.event_folder evf on evf.folder_id = ev.folder_id
--Use the below where statement to filter on a specific folder name
where evf.name = 'Enter Name Of Folder Here'