Thanks for your kind response. If possible please could you provide me the steps to schedule any report query in db.
Regards, Abhishek On 13-Jun-2017 11:37 PM, "Sivarama Velicheti" <[email protected]> wrote: > ** > Abhishek, > > The query on the incident form could be along the lines of > > SELECT [column name 1], [column name 2], [column name 3] ....[column > name n] FROM HPD_Help_Desk {WHERE CLAUSE} > > You would require knowledge of how the AR Tables are structured within > the database. All the column names would be the DB names and not the Label > Names of the field. Below is a sample query in SQL that I wrote. Once you > know the underlying table structure you should be able to construct a lot > of complex queries/reports not possible within the Application UI. > > -- List of Open Tasks for Changes in "Scheduled" or "Implementaion In > Progress" status. > > SELECT > T.Task_ID, > Task_Status = > CASE > WHEN T.Status = 1000 THEN 'Staged' > WHEN T.Status = 2000 THEN 'Assigned' > WHEN T.Status = 3000 THEN 'Pending' > WHEN T.Status = 4000 THEN 'Work In Progress' > WHEN T.Status = 5000 THEN 'Waiting' > WHEN T.Status = 6000 THEN 'Closed' > WHEN T.Status = 7000 THEN 'Bypassed' > END, > T.Location_Company AS Company, > T.Summary, > (DATEADD(s, T.Scheduled_Start_Date, '1969-12-31 19:00:00')) AS > Task_Scheduled_Start_Date, > (DATEADD(s, T.Scheduled_End_Date, '1969-12-31 19:00:00')) AS > Task_Scheduled_End_Date, > CURRENT_TIMESTAMP AS Todays_Date, > (DATEDIFF(DAY, (DATEADD(s, T.Scheduled_End_Date, '1969-12-31 > 19:00:00')), CURRENT_TIMESTAMP)) AS Days_Past_The_End_Date, > T.Assignee_Group, > T.Assignee, > C.Infrastructure_Change_ID, > Change_Request_Status = > CASE > WHEN C.Change_Request_Status = 0 THEN 'Draft' > WHEN C.Change_Request_Status = 1 THEN 'Request For > Authorization' > WHEN C.Change_Request_Status = 2 THEN 'Request For Change' > WHEN C.Change_Request_Status = 3 THEN 'Planning In > Progress' > WHEN C.Change_Request_Status = 4 THEN 'Scheduled For > Review' > WHEN C.Change_Request_Status = 5 THEN 'Scheduled For > Approval' > WHEN C.Change_Request_Status = 6 THEN 'Scheduled' > WHEN C.Change_Request_Status = 7 THEN 'Implementation In > Progress' > WHEN C.Change_Request_Status = 8 THEN 'Pending' > WHEN C.Change_Request_Status = 9 THEN 'Rejected' > WHEN C.Change_Request_Status = 10 THEN 'Completed' > WHEN C.Change_Request_Status = 11 THEN 'Closed' > WHEN C.Change_Request_Status = 12 THEN 'Cancelled' > ELSE NULL > END, > (DATEADD(s, C.Scheduled_Start_Date, '1969-12-31 19:00:00')) AS > Change_Scheduled_Start_Date, > (DATEADD(s, C.Scheduled_End_Date, '1969-12-31 19:00:00')) AS > Change_Scheduled_End_Date > FROM TMS_Task T > INNER JOIN CHG_Infrastructure_Change C ON T.RootRequestID = > C.Infrastructure_Change_ID > WHERE (C.Change_Request_Status = 6 OR C.Change_Request_Status = 7) AND > T.Status < 6000 AND T.Support_Company = xxxx > > Your DBA should be able to help you with scheduling the report or run > you through the steps of scheduling one. > > Thanks > Shiva Velicheti > > > On Tue, Jun 13, 2017 at 12:09 PM, Abhi$hek <[email protected]> wrote: > >> ** >> Thanks for your response. >> >> Please could you guide with the steps to design a sample SQL query and >> how to schedule it. >> >> Regards, >> Abhishek >> >> On 13-Jun-2017 9:11 PM, "Sivarama Velicheti" <[email protected]> wrote: >> >>> ** >>> Abhishek, >>> >>> The easiest method that I usually follow to go around the entries >>> returned restriction, is that I build SQL queries which retrieve the data >>> directly from AR database. I usually run the queries ad-hoc and provide the >>> reports as needed. For the scheduled reports I usually have the script >>> configured in the SQL server to send out reports at specific times to the >>> intended audience. >>> >>> Thanks >>> Shiva Velicheti >>> >>> On Tue, Jun 13, 2017 at 9:35 AM, Abhi$hek <[email protected]> >>> wrote: >>> >>>> ** >>>> We can't update the server settings as it's applied for the server >>>> performance only. >>>> >>>> On 13-Jun-2017 7:51 PM, "Kevin Shaffer" <[email protected]> >>>> wrote: >>>> >>>>> ** >>>>> I believe you can change the config.properties to allow more than >>>>> 2000. >>>>> >>>>> Get Outlook for Android <https://aka.ms/ghei36> >>>>> >>>>> ------------------------------ >>>>> *From:* Action Request System discussion list(ARSList) < >>>>> [email protected]> on behalf of Abhishek Anand < >>>>> [email protected]> >>>>> *Sent:* Tuesday, June 13, 2017 4:27:17 AM >>>>> *To:* [email protected] >>>>> *Subject:* Can we schedule AR Reports & send it to third party via >>>>> web service? >>>>> >>>>> Hi Experts, >>>>> >>>>> Can we schedule AR Reports & send it to third party via web service? >>>>> As we are having the 2000 rows restrictions at server level so unable >>>>> to achieve it via AR System Report console. >>>>> >>>>> Early response will be highly appreciated. >>>>> >>>>> Regards, >>>>> AA >>>>> >>>>> ____________________________________________________________ >>>>> ___________________ >>>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>>>> "Where the Answers Are, and have been for 20 years" >>>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>> >>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>> >>> >>> >>> >>> -- >>> Thanks >>> Shiva >>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> > > > > -- > Thanks > Shiva > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
