Subscribe by Email
SQL
Table Scan Index Scan and Index Seek
Monday, April 28th, 2008This 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 an [...]
SQL – extracting the workflow queue.
Monday, March 31st, 2008This 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 know the [...]
Identifying Positions based on divisions - SQL.
Wednesday, February 27th, 2008This 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
Useful SQL Queries – Workflow Processes exposed.
Monday, November 12th, 2007This 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.
Useful SQL Queries - Workflow Process and Workflow Policies
Thursday, November 8th, 2007This 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 [...]
Useful SQL Queries - Customization exposed
Saturday, November 3rd, 2007We 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:
Useful SQL Queries in Siebel - Views and Responsibility.
Friday, November 2nd, 2007Below 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.