This article has been submitted by my friend Ashish Arora who is working in Siebel Analytics and ETL for past 2 years and has a total of 3.5 years of experience in siebel. He is currently leading a team in an Software concern When the Query Optimizer is asked to optimize a query and create [...]
Full Story »Table Scan Index Scan and Index Seek
SQL – extracting the workflow queue.
This query has been shared by a “Svetj” a member of SiebelUnleashed forum. I find it quite useful in case if I work in admin and need to know the workflow queue. It shows The actual queue for a workflow policy group with the insert date of the next record to work so you can [...]
Full Story »Identifying Positions based on divisions – SQL.
This query has been shared by a reader of my blog Kaushik Ghosh. It helps us to identify position and parent position for the specified division. Can be really helpful in Support jobs involving creation of various positions. Avoid duplicate of Position creation Places where lot of divisions and positions exsist Here is the query
Full Story »Useful SQL Queries – Workflow Processes exposed.
This Query has been provided by my Friend Nitin. This query let’s you get all the information about workflow processes. You can get various kind of output by just modifying the where clause.
Full Story »Useful SQL Queries – Workflow Process and Workflow Policies
This SQL Query has been provided by a friend of mine Nitin Kumar. Who has been in siebel from past 2 years and is currently working as a Senior Siebel Developer in an MNC. When working with siebel Workflow policies and Workflow process are very common. This SQL can you help you to determine name [...]
Full Story »Useful SQL Queries – Customization exposed
We imparts you with great information. While surfing on web came across blog that had some articles on SQL and I think it is worth sharing with everybody. I orignal post was found on blog called nbrightside. Some useful queries that I found on that blog are: Custom Indexs and Custom Columns:
Full Story »Useful SQL Queries in Siebel – Views and Responsibility.
Below mentioned SQL Query will give you the list of users (First Name and Last Name) who have particular view added to their responsibility in Siebel.
Full Story »




