Products
Solutions
Support & Services
Company
How To Buy
Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Register
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Communities
Enterprise Software
Mainframe Software
Symantec Enterprise
Blogs
All Blogs
Enterprise Software
Mainframe Software
Symantec Enterprise
Events
Enterprise Software
Mainframe Software
Symantec Enterprise
VMware
Water Cooler
Groups
Enterprise Software
Mainframe Software
Symantec Enterprise
Release Automation
Private Community
Community Home
Threads
Library
Events
Members
Back to discussions
Expand all
|
Collapse all
Nolio Official KB: How do I query The database for all published Processes?
1.
Nolio Official KB: How do I query The database for all published Processes?
0
Recommend
ca.portal.admin
Posted Dec 18, 2013 04:16 PM
Reply
Reply Privately
Options Dropdown
The following SQL query will generate a list of all published process:
SELECT id,process_name FROM process_container p where EXISTS (
SELECT 1
FROM published_process e
WHERE e.originalProcessId = p.id
) and p.parent_category_id is not null
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Footer
Copyright 2023. All rights reserved.
Powered by Higher Logic