@simardl there is more information on custom fields (and much more besides) in the report development documentation that is attached in this Knowledge Base article:
@lloyd1306 The visibility expression does not affect the values in the hidden fields so it isn’t surprising they get saved with values under the scenario you gave. You may want to add an idea for setting hidden fields to null when saving. (You wouldn’t want to do that when you hide in case it was hidden by mistake so rectifying that would mean you lose those values which be very annoying to the user) There may be reasons for not doing this but I can see what they are.In the meantime, I suggest in your Power BI report you should apply transformations on those fields and set the shown/hidden fields to null based of the value of the Yes/No field as appropriate. I hope that helps you. Paul CooperReport DesignerIFS ESM BU
See my answer to your question in:
@simardl The field is a system lookup so the values would not be in the jptsys_web_lkup_data table as that is for custom lookups. System lookups are for system lookup tables which can currently be only one of items, contact users or cost centres. You can tell which by looking at the lookup_table_id field in jptsys_web_cust_prop. These are:lookup_table_id Table Schema Name 26 Cost Centres cost_centre 49 Contact Users usr 143 Items item ( You can see the mappings from number to table in the jptsys_tabledata table)If REGION is an item then the SQL would be:(select lkup.item_nfrom jptsys_web_cust_prop_cont (NOLOCK) jc inner join jptsys_web_cust_prop (NOLOCK) j on jc.jptsys_web_cust_prop_id=j.jptsys_web_cust_prop_id inner join item (NOLOCK) lkup on jc.LOOKUP_VAL_ID = lkup.item_idwhere i.incident_id = jc.entity_id and j.jptsys_web_cust_prop_sc= 'REGION') AS "Region / Région", If it was a cost centre then:(select lkup.cost_centre_nfrom jptsy
@matteo.ghilardi Currently it is not possible to sort by value in the Summary Table. I suggest you request this in the Ideas section: https://community.ifs.com/ideas?filters%5BproductArea%5D%5B0%5D=assystWith Kind Regards, Paul CooperReport DesignerIFS ESM BU
@ChrisButters Here is example code for all events for SQL Server/Azure SQL:WITH inc as (SELECT incident.incident_id, (CASE WHEN inc_data.u_date1 IS NOT NULL THEN inc_data.earliest_sla_resolve_due ELSE incident.inc_resolve_due END) breach_date, --Due/breach date. This takes into account stopped clocks (SELECT TOP 1 act_reg.date_actioned FROM act_reg WHERE act_reg.incident_id = incident.incident_id AND act_reg.act_type_id IN (4, 5) AND act_reg.date_actioned <= (CASE WHEN inc_data.u_date1 IS NOT NULL THEN inc_data.earliest_sla_resolve_due ELSE incident.inc_resolve_due END) ORDER BY act_reg.date_actioned DESC) last_resolve_or_close_date, --before or on the breach date (SELECT TOP 1 act_reg.date_actioned FROM act_reg WHERE act_reg.incident_id = incident.incident_id AND act_reg.act_type_id = 6 AND act_reg.date_actioned <= (CASE WHEN inc_data.u_date1 IS NOT NULL THEN inc_data.earliest_sla_resolve_due ELSE incident.inc_resolve_due END) ORDER BY act_reg.date_actioned DESC) las
@girvand This is not a set of assyst dashboard reports as those individual visualisations are not in the out-of-the-box set for dashboard reports. Also the fact it has a footer gives it away. This is instead either a Fixed Design Wizard report or more likely a Full-Page Dashboard report designed to look like a standard Dashboard. It is again not one of the out-of-the-box ones of either type.I have asked someone who I believe created this to take a look.With Kind Regards, Paul CooperSoftware Engineer/Report Designer.
@Amal.aljohani I suggest you take a look at the OLA Template (an assyst Wizard Template) which can be found here:https://wiki.axiossystems.com/assyst11-6Wiki/index.php/OLA_Template_-_Wizard_TemplateThis template links event records to assignment actions so should provide the information you are looking for. Please note that this template has limitation (see below for details).Upload this template and all its dependencies and you can use it to create report designs configured such as these:Report Design 1Layout: Chart: None Aggregate Table: None Detailed Table: Detailed TableDetailed Table: Columns:Date Logged Assigned Service Department Name Date Actioned OLA Assignment Time (this is in SLA Minutes) Groupings:Event Reference Sorting:Date Actioned (Ascending)Filters:Date Logged (This template doesn’t have a filter for Event Reference so if you can get the date logged for the event and set this filter to be as tight to that date and time as possible then that sho
@musahadzi We don’t have any reports out of the box that look at the types of entities you mention but it wouldn’t be hard for you to create them. Install Eclipse BIRT (4.5.0) and modify the Fixed Design Starter Report (available in the Knowledge Base) with the SQL for the entity of interest. (You can add multiple data sets for multiple entities if you wish.) And then add tables, charts etc. to your report.(Please note you need at least one filter parameter).You can get more information and the starter report in the Knowledge Base Article: With Kind Regards, Paul CooperSoftware Engineer/Reports Designer
@mancelticIn response to point (1) it tells you what you need to set up here: https://wiki.axiossystems.com/assyst11-6Wiki/index.php/Reports_in_the_Self-Service_PortalIf that doesn’t resolve your issue then please raise a support call.Point (2) here is the page discusses reports and emails: https://wiki.axiossystems.com/assyst11-6Wiki/index.php/Installation:How_the_assyst_Application_Interfaces_with_SMTP#How_an_assyst_Report_Server_sends_email if you have any further issues with this you should raise a support call.To answer point (3) is yes. When you click on the reports in the Self-Service (assystNet) you get set of tiles for the reports you are subscribed to and an “Unsubscribed Reports” tile. Click on the “Unsubscribed Reports” tile to see the reports in that list.Reports Section:Unsubscribed Reports: With Kind Regards, Paul CooperSoftware Engineer/Reports Designer
Hi, we’re running on-prem Assyst 10sp7 and I need to run some stats against change, request and incident numbers and resolution times. I’ve tried using the reporting section but not getting the level of detail I need from the reports available to me. I thought I would just download the raw data into excel and create some pivot tables but the event search seems to be limited to 4000 records. Is there another way I can create these reports or get the raw data out? Thanks Matt Hi Matt, (@mgswills) I am interesting in knowing what type of data you were looking to get and what was missing when you said “I’ve tried using the reporting section but not getting the level of detail I need from the reports available to me.”I may be able to point you at an out-of-the-box report that provides what you are after or at least know what we could add. With Kind Regards, Paul CooperIFS assyst Software Engineer/Report DesignerIFS ESM BU
@PerkinsJ, unfortunately export support was never made available for reports through the dashboard mechanism (which includes Full-Page reports). You will be getting basic browser printing options only. I suggest you add that as an idea in the ideas section of this site (https://community.ifs.com/ideas)
@PerkinsJ I assume you are using a BIRT report uploaded to IFS assyst (@bpfrenchak this is a channel for IFS assyst reporting only) You should have the option to select HTML, PDF, XLS, XLSX and CSV (the last requires you select a table for the section if the sections have been setup) See https://wiki.axiossystems.com/assyst11-5Wiki/index.php/Report_Wizard#Viewing_a_Report_Result for details.(Please note that Page Size and Page Format only works if previewing a report from the report design not if are viewing a saved report result.)
Hi @coker-b There isn’t currently an out-of-the-box report that pulls action data (other that counts). This was mainly due to the amount of data this could end up being pulled from the database, particularly on the Wizard Templates where the data could then be discarded if that field wasn’t used.There is a new Actions Template on the horizon that has only really been feasible as we are now applying trimming of the SQL (dynamic rewriting of the SQL, data set and bindings) to limit the data pulled to only that required by the report. Unfortunately this Action Template does not get the action remarks but if it was extended to do so it would be able to pull them for only the action type(s) selected.I will speak to Product Management regarding extending the Actions Template to include action remarks.(Please note that this template would not work well on v11.1 as it includes support for 11.2 and later - though you can get round it by making sure you do not select fields not in your schema.
@Istanczyk If you are talking about Aurena then you are not after help with IFS assyst the relatively recently acquired ITSM/ESM tool. This section is for IFS assyst only not any other IFS product. I know nothing about connecting to Aurena’s data. Could you post your request in the appropriate area so the relevant people can pick it up. Thanks. Paul
@lstanczyk,If you are an On-Premise customer then you can use an On-Premise Power BI Gateway to connect your SQL Server or Oracle assyst database to the Power BI Service. You should also be able (depending on your network permissions) to connect directly to an assyst database using the appropriate database connector in Power BI Desktop for developing reports. Though, probably not wise to connect to your production database for developing.If you are a SaaS customer you will need a read only copy of the database in Azure and then use a Power BI Gateway to connect that database to the Power BI Service which I believe the SaaS team can set up. I am not sure of the exact details, so speak to our SaaS team for more (and probably more correct) information and what costs there are, if any. This will not work for Power BI Desktop. For that you would need a copy of the assyst database on your local machine or on your network (say a copy of your test version of assyst) to develop reports from. Pa
@moconnor1 I do not have control of the schedule so I have passed that question on to those that do.
Just to let you know that we at IFS have developed 17 Power BI reports based on the SDI Global Best Practice Standard for Service Desk V8 recommendations using the assyst REST API. Unfortunately, we found that the assyst REST API was not really designed for reporting due to the limited filter options and the lack of paging support (it is really designed for data entry and updates) so we are looking to convert these to use SQL before we make them available. That work has still to be scheduled.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
