Running the reports via rpt_srv is ignoring the Where clause mentioned

book

Article ID: 196222

calendar_today

Updated On:

Products

CA Service Desk Manager SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Desk Manager - Mobile Application CA Service Desk Manager - Xtraction

Issue/Introduction

Issue:

====

Using rpt_srv command when we run report giving a where clause, the output ignores the given clause. Ex: rpt_srv -p 0 crdtl.rpt "WHERE priority='3'" ignores the priority clause of 3.

Environmental Details:

=================

USRD 17.1 RU9/17.3

Environment

Release : 17.3

Component : Svc Desk Reporting

Resolution

Should include backslah character as below for where clause:

rpt_srv -p 0 crdtl.rpt \"WHERE id='2800'\"

rpt_srv -p 0 crdtl.rpt \"WHERE priority='3'\"

The new rpt_srvr.exe executable utilizes getCommandLineW(), the wide byte character implementation of getCommandLine()(previously used) while reading the command line parameters, to support wide byte characters along with normal characters.

For Windows installations, getCommandLineW() requires double quotes to be escaped with backslash character while being passed in command to be treated correctly.