-
1. Re: Can I get the real SQL query from Query which created in Query and report Designer at LANDESK Console
CCrossfield Aug 27, 2013 2:57 AM (in response to anyar)Hi Anyar,
It's possible to get the SQL used by following the instruction for database access logging in the LDSDAdminstrator.pdf manual found here:
http://community.landesk.com/support/community/servicedesk/documentation
The information is found in the appendix on page 166. Which could give SQL for your DBA to analysis the query for performance improvements (such as indexing or altering the query criteria).
If you are having problems with query speed the there is some guidance in the performance.pdf document on running the database tuning advisor which would give database query recommendations.
This can be found on page 11 and page 24 in performance guide as the answers above questions.
Calvin
-
2. Re: Can I get the real SQL query from Query which created in Query and report Designer at LANDESK Console
anyar Aug 29, 2013 1:49 AM (in response to anyar)Our current version is LANDesk Service Desk 7.4, I still not found how to get real sql query from Query which created by LANDesk Console.
I just found that LANDesk Management Suit 9.0 can do
from link : http://community.landesk.com/support/docs/DOC-21733
" ... For custom reports written in pure SQL, the SQL can be copied from the old reports to use in the new reports. To extract the SQL, copy the XML data for the report definition from the content column in the amp_reporting table. The SQL query will always start with the word "select." This is what the XML date will look like in the amp_reporting table, content column:
<queryString> <![CDATA[select distinct ROI.Currency, ROI.RC_Saving as Saving, sub.StartTime, sub.EndTime, sub.ViewingComputer, sub.ManagedComputer, sub.UserName from (select r.EventTime as StartTime, MIN(s.EndTime) as EndTime, r.ViewingComputer, r.ManagedComputer, r.UserName from RCLog r join (select EventTime as EndTime, ManagedComputer from RCLog where RCAction_Idn = 2) s on s.ManagedComputer = r.ManagedComputer and s.EndTime > r.EventTime where r.rcaction_idn = 1 group by r.EventTime, r.ViewingComputer, r.ManagedComputer, r.UserName) sub, ROI where ROI_Idn = 1 and (sub.StartTime >= $P{StartDate} AND sub.StartTime <= ($P{EndDate} + 1))]]> </queryString>
The text highlighted in red is the SQL query. What is not in red is part of the XML data that should not be copied "
So, I would like to ask LANDesk Service Desk 7.4 like us can do like this ....
-
3. Re: Can I get the real SQL query from Query which created in Query and report Designer at LANDESK Console
elizabethcombrink Aug 29, 2013 1:53 AM (in response to anyar)Following Calvin's post will help you get the SQL.
-
4. Re: Can I get the real SQL query from Query which created in Query and report Designer at LANDESK Console
CCrossfield Aug 29, 2013 8:34 AM (in response to anyar)Hi Anyar,
In 7.4 the documentation which shows how to setup the logging can be found in its own manual called TPSDiagnosticLogging.pdf.
It is applied directly in the tps.config file instead of the Configuration Centre in 7.5 onwards.
It would be advisable to do the logging on a test system.
Calvin