I would like to know if there is a way to run a SQL query against the schema of casd of MDB database. I can see only the schema dbo. I appreciate any help or information.
The best way to know how SDM queries are executed, You may follow these below simple steps
# Login to the application and keep your screen handy .
# From the primary server -> command prompt -> execute these commands
pdm_logstat -f sqlclass.c TRACE
pdm_logstat -f sqlquery.c TRACE
# Now you may try to perform any activity on UI. Once done the stop the tracing
pdm_logstat -f sqlquery.c 0
pdm_logstat -f sqlclass.c 0
If you review the stdlog , you should be able to find the exact query thats been executed at the database.
Example : This is the sample query when a ticket is updated.
03/23 23:56:22.44 ITSMW12SD sqlagt:Act_Log 89420 MILESTONE sqlclass.c 1057 The following statement took 82 milliseconds: Clause (INSERT INTO act_log ( action_desc, analyst, call_req_id, description, internal, knowledge_session, knowledge_tool, last_mod_dt, persid, rel_ticket_type, system_time, time_spent, time_stamp, type, id ) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )) Input (<action_desc:string>FIELD='Description' OLD='testing as servicedesk' NEW='testing as servicedesk- vinod' FIELD='Requested By' OLD='' NEW='Administrator' |<analyst:uuid>C56A9F834D6AD545BCE4F30979B58FB1|<call_req_id:string>cr:400152|<description:string>FIELD='Description' OLD='testing as servicedesk' NEW='testing as servicedesk- vinod' FIELD='Requested By' OLD='' NEW='Administrator' |<internal:int>0|<knowledge_session:string>(NULL)|<knowledge_tool:string>PDM|<last_mod_dt:time>03/23/2016 23:56:22|<persid:string>alg:401363|<rel_ticket_type:string>(NULL)|<system_time:time>03/23/2016 23:56:22|<time_spent:duration>67|<time_stamp:time>03/23/2016 23:56:22|<type:string>FLD|<id:int>401363)
If you wanted to run the query directly again database , then replace ? with the appropriate input values
Not sure I understand what you are looking to accomplish
Can you explain a little more?
Hi Miguel, can you explain a bit about what type of data you are looking to gather or what query you are looking to run? Maybe a quick use case example?
Retrieving data ...