Powershellf script to capture screnshot # Load necessary assemblies Add-Type -AssemblyName PresentationCore Add-Type -AssemblyName System.Windows.Forms Add-Type -AssemblyName System.Drawing # Define the screenshots folder path and ensure it exists $desktopPath = Join-Path -Path $env:USERPROFILE -ChildPath "Desktop\screenshots" if (!(Test-Path -Path $desktopPath)) { New-Item -ItemType Directory -Path $desktopPath | Out-Null } # Main loop to check for Shift key press while ($true) { # Check if either Shift key is pressed if ([System.Windows.Input.Keyboard]::IsKeyDown([System.Windows.Input.Key]::LeftShift) -or [System.Windows.Input.Keyboard]::IsKeyDown([System.Windows.Input.Key]::RightShift)) { Write-Output "Shift key is pressed." # Generate a unique file path with a timestamp $timestamp = (Get-Date).ToString("yyyyMMdd_HHmmss") $filePath = Join-Path -Path $desktopPath -ChildPath "screenshot_$timestamp.png" Write-Output "Screenshot will be saved to: $filePath" # Get primary monitor dimensions $screenWidth = [System.Windows.Forms.SystemInformation]::PrimaryMonitorSize.Width $screenHeight = [System.Windows.Forms.SystemInformation]::PrimaryMonitorSize.Height # Create a new bitmap and graphics object for screen capture $bitmap = New-Object System.Drawing.Bitmap $screenWidth, $screenHeight $graphics = [System.Drawing.Graphics]::FromImage($bitmap) $graphics.CopyFromScreen(0, 0, 0, 0, $bitmap.Size) # Get mouse position $mouseX = [System.Windows.Forms.Cursor]::Position.X $mouseY = [System.Windows.Forms.Cursor]::Position.Y $highlightRadius = 30 # Radius for the highlight circle # Draw a circle around the mouse pointer $highlightPen = New-Object System.Drawing.Pen([System.Drawing.Color]::Red, 3) $graphics.DrawEllipse($highlightPen, $mouseX - $highlightRadius, $mouseY - $highlightRadius, $highlightRadius * 2, $highlightRadius * 2) # Save the screenshot as a PNG file $bitmap.Save($filePath, [System.Drawing.Imaging.ImageFormat]::Png) # Release resources $highlightPen.Dispose() $graphics.Dispose() $bitmap.Dispose() Write-Output "Screenshot saved to $filePath" # Delay to avoid multiple screenshots on a single key press Start-Sleep -Milliseconds 500 } else { # Optional: Remove this line if constant output isn't needed Write-Output "Shift key is not pressed." } # Short delay before checking again Start-Sleep -Milliseconds 5 }

How to Add a page in Peoplesoft

Create HTML Area and assign it to the record field.

Create a string with
&URL = " WWw.yaho.com&xml=yes";
in that Rowniit.....
Record .FB_HTMLSTAT.Value = GetHTMLText(HTML.FBB_CRM01_HTML, &Url);

in the HRML section

Solution Administration

Solution Advisor Setup Instructions

Step1. Navigate to Setup CRM > Common Definitions >Component Configuration->Display Templates >Display Template Details and enter following parameters
Template Id = RC_Support
Component =RC_CASE
Market = Global

Enable solution checkbox. See the Red box below.



Step2. Navigate to Setup CRM -> Utilities ->Search -> Search Page Definition
Enter CALLCENTER on Search Page Definition.
a. On Search Definition Tab
Change Results to Display = 25 and enable word variations -Exact words.

b. Tab to Record Index list Page
Uncheck Call center Case, Troubleshooting Guide, Defect, Fix check boxes. (See the red box below)

Search Definition Tab


Step3. Navigate to SetupCRM > Utilities >Search >Search Index Template>
Enter following parameters
Collection Name = CRM_RB_SRCHDB
Record name = RC_CASE_VW2
a. Update SQL statement with this string WHERE CASE_ID = 0
b.Enable SOLN_Keywords check box.










Step 4. Setting up Run Control
1).
Navigate to Setup CRM >utilities>search>Build Collection
And Enter
Run Control Id =1 and configure following parameters
Process Frequency = once
Collection Name = CRM_RB_SRCH_DB
Collection Directory = Set NAS Drive Path.
(Example in QA =


Server Operating Environment = Windows NT.
Search Collection Selection = Create NEW .
Language Selection = Single Language, Language Code = English



2. Navigate to People Tools > Process Scheduler > Schedule Jobset Definitions
Type following parameters in Add a new value
Schedule Name :XXXXx
JobName =XXXX

Add following parameters
Description = Solution Collection;
Run Control ID =1;
Recurrence Name = .
Status =Active.



5. Set the NAS drive Path for Search Collections in App server config file.

http://www.scribd.com/doc/48585473

Menu Path

SELECT DECODE(a.new_fields + a.del_fields + a.chg_fields, 0, 'Build New', DECODE(a.new_fields + a.del_fields, 0, '?Alter Old', 'Alter Old')) status, DECODE(b.rectype, 0, 'Table', 'View') rec_type,a.recname RECORD,a.new_fields,a.del_fields,a.chg_fieldsFROM (SELECT objectvalue1 recname,NVL(SUM(DECODE(objectid2, 2, DECODE(targetstatus, 1, 1))),0) new_fields, NVL(SUM(DECODE(objectid2, 2, DECODE(upgradeaction, 1, 1))),0) del_fields, NVL(SUM(DECODE(objectid2, 2, DECODE(targetstatus, 1, 0, DECODE(upgradeaction, 0, 1)))),0) chg_fields FROM psprojectitemWHERE projectname = :1AND objecttype = 0 -- records onlyAND upgradeaction <> 2 --ignore None action'GROUP BY objectvalue1) a,psrecdefn bWHERE a.recname = b.recnameAND b.rectype IN (0,1) -- tables and views onlyORDER BY 2, 1 DESC, 3

Junk dont follow this does not amasek sense

UPDATE XXXX ESET CH_CC_REP = (SELECT E1.PERSON_ID FROM PS_CH_WORKER_EXT E1 WHERE E1.CH_CORP_ANUM_ID = (SELECT SUBSTR(CH_CONV_L_ORG,2,6) FROM PS_CH_LEAD_STG S1 WHERE S1.LEAD_ID =E.LEAD_ID) )WHERE EXISTS (SELECT 'Y' FROM PS_CH_LEAD_STG S WHERE E.LEAD_ID =S.LEAD_ID AND E.LEAD_ID ='LEA3692712') Solution Admin Search collection Setup

List of all tables with new /Old ones in compares.
SELECT DECODE(a.new_fields + a.del_fields + a.chg_fields, 0, 'Build New', DECODE(a.new_fields + a.del_fields, 0, '?Alter Old', 'Alter Old')) status, DECODE(b.rectype, 0, 'Table', 'View') rec_type,a.recname RECORD,a.new_fields,a.del_fields,a.chg_fieldsFROM (SELECT objectvalue1 recname,NVL(SUM(DECODE(objectid2, 2, DECODE(targetstatus, 1, 1))),0) new_fields, NVL(SUM(DECODE(objectid2, 2, DECODE(upgradeaction, 1, 1))),0) del_fields, NVL(SUM(DECODE(objectid2, 2, DECODE(targetstatus, 1, 0, DECODE(upgradeaction, 0, 1)))),0) chg_fields FROM psprojectitemWHERE projectname = :1AND objecttype = 0 -- records onlyAND upgradeaction <> 2 --ignore None action'GROUP BY objectvalue1) a,psrecdefn bWHERE a.recname = b.recnameAND b.rectype IN (0,1) -- tables and views onlyORDER BY 2, 1 DESC, 3

SELECT * FROM PS_RI_INTERACTION A
, (
SELECT S1.* FROM
(SELECT CH_ECN_ACCT_NUM, BO_ID FROM champ.PS_CH_FIN_ACCOUNT a WHERE bo_id NOT IN (SELECT bo_id FROM champ.PS_RD_PERSON)) S1,PS_RI_INTERACTION R
WHERE R.BO_ID_CUST = S1.BO_ID

Peoplesoft CRM Tunings

After hitting heads with few walls here are some resolutions which make sense in tuning CRM. (ORACLE did not helped much than non ORACLE experienced DBA's/Sys Admins) This May help you folks. One thing you need is patience and think big approach.
1. Remove operators like "contains" from configurable searches.
2. Killer Table is BO_NAME. One good option is to re dump the table order by Last_Name_SRCH field. Al though a row be added at the last, this is very helpful if some one searched by "begins With". ( This is complex to understand. Talk with a practical DBA not a theoritical ones who talk a lottttttt).
3. If possible remove BC,CM Tables ( Profile_SEQ is the pain) and store address,phone no, Email in a custom sibling record. These tables add over head than actually resolving problems espectially if you have cusomer base in millions. (Reporting sucks with delivered ones). We are successful becasue we are not using order to cash so no Sold to, Ship To 's ...... convince the client to remove relationship viewer. This has improved the search little bit ( can be done easily throught configuration).
I will try to post the steps needed to remove CM's for Support module.
4. US PL/SQL scripts by doing the Set processing for data conversion (use insert select's than cursors).
5. Helps you the long running Query. This is been put by a smart lead not by me.
6.

SELECT s.last_call_et secs,
s.inst_id '.' s.sid isid,
decode(l.inst_id, NULL, NULL, l.inst_id '.' l.sid) lsid,
t.sql_text,
s.username,
s.client_info
FROM gv$SESSION s,
gv$LOCK l,
gv$lock lb,
gv$sqltext t
WHERE t.INST_ID = s.INST_ID
AND t.address = s.sql_address
AND t.hash_value = s.sql_hash_value
AND t.sql_id = s.sql_id
AND s.type <> 'BACKGROUND'
AND s.status = 'ACTIVE'
AND l.request (+) = 0
AND l.id1 (+) = lb.id1
AND l.INST_ID (+) = lb.INST_ID
AND lb.sid (+) = s.sid
AND lb.INST_ID (+) = s.INST_ID
AND lb.request (+) <> 0
AND s.audsid <> userenv('sessionid')
ORDER BY s.last_call_et, s.inst_id, s.sid, t.piece;
6. Have dedicated appservers for Sync Async services. This make more sense than people soft recommended Master/ Slave approach for Tuning Integeration Broker. Things I have seen is there is no hard and fast rule here.
7. Remove message logging. ( We chose this for some services).
8.For MQ try to have the queues setup at the webserver level which could reconnect itself if the queue gets paused. (battle been fought with the system admins to get this thing done).


------------------------------------------

Ideas to Kill Bench

Looks like Economy is getting sucked every day. Come on Benchers Just Blog , share the frustration,opputunities and Lets learn together and win this down time.
Things to Do in Bench
a.Sleep Well
b.Booze well
c. Watch Portfolios and load the stocks if you feel to own it.
d. Talk to Friends, Family.
e. Meditate and keep your self calm.
f. Excercise
g.Make sure you enjoy in Sex