Automate

 View Only

  • 1.  FAQ - Reporting in Evolve/Studio Manager

    Employee
    Posted 07-12-2021 12:02
    Hello Winshuttle Evolve/SM Admins, 
    Some of  you have reached about how Reports work in Evolve/Studio Manager.
    Attached are some resources to get you started with the basics. 

    Here is your quick 5 minute Intro - For details, please refer to the attachments: 
    1. You need Report Admin Permissions to Create/Edit/Publish/Share reports. All end users can access reports if shared with them. 
    2. Evolve/SM comes with some standard delivered example reports - you can edit them or add columns by editing the SQL Query associated with it. Not all SQL syntax is supported. [Fine Print is here]
    3.  If the SQL query includes an aggregate function, such as count, it is a graph based report, and can be pinned to an app home page as a pie chart, donut, bar chart etc., . Otherwise, it will display a table-based report. Only graph-based reports can be pinned.
    4. There are 2 types of Reporting Views in the DB -> Standard Views & Custom Views (Solution Specific Views). 
    5.  Reports can be created using a Wizard with 4 easy steps. Details are here.
    6.  Some troubleshooting tips:
    • Design and test your query in SQL Server Management Studio (SSMS) before pasting in the wizard editor.
    • Test smaller queries first and add joins, filter conditions, calculated columns etc., gradually 

    Also including some commonly requested SQL queries to
    1. Identify scripts that are used the most or the least or not at all 
    2. List of all Overdue Workflow Tasks across all Apps/Users
    3. Calculate time savings or Avg Processing Time per Tcode
    4. Calculate Avg Run times for Query Scripts
    5. Calculate Total Records Processed in each Run or by each User
    ...

    Hope this helps as a starting point, please tweak the examples to suit your use case.
    Jayasri

    ------------------------------
    Jayasri Varyani | Solutions Engineer
    Winshuttle North America |
    ------------------------------

    Attachment(s)

    txt
    Reporting - SQL Queries.txt   3 KB 1 version
    pdf
    Reporting in Studio Manager.pdf   671 KB 1 version
    pdf
    Reporting in Evolve.pdf   667 KB 1 version


  • 2.  RE: FAQ - Reporting in Evolve/Studio Manager

    Employee
    Posted 08-05-2021 10:24
    Here is an updated SQL Query for "Unused Scripts" - this will work in the Evolve Report Editor. 

    Select Distinct (RPT_SolutionView.Title) AS 'ScriptName',RPT_SolutionView.Description AS 'Description',RPT_AppGroupView.Appname AS RPT_AppGroupView_Appname FROM [RPT_SolutionView]

    JOIN RPT_APPGroupView on RPT_SolutionView.AppId = RPT_APPGroupView.Appid where RPT_SolutionView.ScriptType in (0,1)

    AND RPT_SolutionView.Title NOT In

    (SELECT distinct RPT_SolutionView.Title

    FROM RPT_SolutionView

    JOIN [RPT_TransactionRoiView] txr ON RPT_SolutionView.AppId = txr.ReferenceId

    where RPT_SolutionView.ScriptType = 0 and txr.TxrTitle like CONCAT('%', RPT_SolutionView.Title, '%')

    and DATEDIFF(MINUTE,txr.ActivityDateTime, GETUTCDATE()) >0)

    AND RPT_SolutionView.Title NOT In

    (SELECT distinct RPT_SolutionView.Title

    FROM RPT_SolutionView RPT_SolutionView

    JOIN [RPT_QueryRoiView] qr ON RPT_SolutionView.AppId = qr.ReferenceId

    where RPT_SolutionView.ScriptType = 1 and qr.QueryFileName like CONCAT('%', RPT_SolutionView.Title, '%')

    and DATEDIFF(MINUTE,qr.DateTimeOfRun, GETUTCDATE()) >0)



    ------------------------------
    Jayasri Varyani | Solutions Engineer
    Winshuttle North America |
    ------------------------------