IT Process Automation

CA PAM - How to use Query_Database and loop

01. Execute Query

CA PAM::. How to use Query_Database operator - Process Example 

02. Row Count

Post-execution code

Process.numTotalRows = Process[OpName].QueryResults.ResultSets[0].Rows[0].TotalRow;
Process.numRowsPerLoop = 100;
Process.numLoopsRequired = Math.ceil(Process.numTotalRows / Process.numRowsPerLoop);
Process.currentLoop = 0;

03. Loop Property

• Repeat Count
  • Process.numLoopsRequired

04. For next step

On this example is Post-Execution Code on FetchDatabase operator

Process.currentLoop += 1;

CA PAM::. How to read a XML file - applyXPath Function 

Summary CA Process Automation 

Summary CA Service Management Community 

Service Desk Manager 15 days Implementation 

CABI:: Summary - BOXI for CA SDM 

Summary CA SDM Scoreboard 

Was useful, please leave your feedback!