Skip to main content

assyst Reporting

Questions regarding reporting in IFS assyst.

  • 19 Topics
  • 55 Replies
19 Topics
M
Sidekick (Customer)
mgswillsSidekick (Customer)
asked in assyst Reporting
Resolution SLA Breech Report

Has anyone created a PowerBI report to show incidents that have breeched their Resolution SLA?I can create it easily as a monitor by using the SVD Resolution Breach flag but we only get Resolution Due and Actual Resolution date/times is the Incident Table.Was hoping I could somehow create a filter that would only show me incidents where the Resolution Due date/time was before the Actual Resolution date/time but after trawling the internet I can’t see a way to do this in PowerBI.I could do this really easily with a bit of SQL but PowerBI doesn’t let me define filters as SQL I don’t think.

382
M
Sidekick (Customer)
M
Sidekick (Customer)
mgswillsSidekick (Customer)
asked in assyst Reporting
Event/Incident ERD

Does anyone know if there is an ERD for Events (the main table is called Incident) as it seems to be missing from the following wiki page?Entity Relationship Diagrams - assyst11-8Wiki 

291
C
Hero (Employee)
M
Sidekick (Customer)
mgswillsSidekick (Customer)
asked in assyst Reporting
Incident Stage Reporting

I’ve had a request from a Service Department to add a status field to incidents so they can report what stage it is in.I’ve create a custom field on the incident form in Customiser and a lookup containing 4 options: 1.Investigation, 2. Problem Identified, 3.Resolution in Progress, 4. Acceptance & Deployment. All working nicely except I can’t create a monitor that will display the field or filter on certain values.Is there a better way of doing this where our support team can report on the status based on the stages above?

283
M
Sidekick (Customer)
S
Do Gooder (Customer)
simardlDo Gooder (Customer)
asked in assyst Reporting
Assyst 11.6.3 custom field data

I trying to extract the value of a custom field with property type “l: system lookup”.The lookup_VAL_ID does not seem to match anything in the jptsys_web_lkup_dataAlso what is weird is we are on 11.6.3 and table jptsys_web_cust_prop is not supposed to be removed  11.5 but it is there and it is populated with something!!!here is the SQL that I use to get the “Lookup_val_ID”:(select max(convert(varchar,jc.LOOKUP_VAL_ID))     from  jptsys_web_cust_prop_cont (NOLOCK) jc              left join jptsys_web_cust_prop (NOLOCK) j  on jc.jptsys_web_cust_prop_id=j.jptsys_web_cust_prop_id            left join jptsys_web_lkup_data (nolock) drop_dwn_val on drop_dwn_val.jptsys_web_lkup_data_id = jc.LOOKUP_VAL_ID           left join jptsys_web_lkup (NOLOCK) lkup on drop_dwn_val.jptsys_web_lkup_id = lkup.jptsys_web_lkup_id           where i.incident_id=jc.entity_id            and j.jptsys_web_cust_prop_sc='REGION'      ) AS "Region / Région",

1363
paulc
Do Gooder (Employee)
L
Do Gooder (Customer)
lloyd1306Do Gooder (Customer)
asked in assyst Reporting
Hidden Fields still written to the assyst database

We have a single select field with answers Yes and No, and use visibility expressions to display fields based on the Yes/No selection.  We've found that when (for example) Yes is selected and values are entered for the fields dependent on Yes, if you change your mind and select No, and then enter values for the fields displayed on No, when the form is saved, all the values entered for Yes and No are written to the database. We use powerBI for our reporting and wondered if there was a way to hide these hidden completed fields from the database or if there was a way they do not get written to the database? Below is a snippet from our test database to show an example of this problem.  

672
paulc
Do Gooder (Employee)
S
Do Gooder (Customer)
simardlDo Gooder (Customer)
asked in assyst Reporting
Assyst 11.6.3 Custom Field

I am trying to write a report that extract a custom field with custom property type of ‘l’ which is no longer listed but was part of 5.5 for system fields.In any case it fills a “LOOKUP VALUE ID” which I am trying to look up but the data schema only say“The value of a Custom System lookup field.Introduced in assyst10 SP5.5.” What table(s) are associated with custom System Lookup?

471
paulc
Do Gooder (Employee)
matteo.ghilardi
Do Gooder (Partner)
matteo.ghilardiDo Gooder (Partner)
asked in assyst Reporting
Report Wizzard - x-axis sorting by number of events

 Hi all,for a customer we produced the following report, which shows the most used products in the last month:Is there a possibility to sort the graph by number of events instead of product name?I can't find any option that allows me to do this in the Group by section of the chart data. Furthermore, is it possible to also sort the detailed table below by count event in ascending order? 

752
matteo.ghilardi
Do Gooder (Partner)
A
Do Gooder (Customer)
Amal.aljohaniDo Gooder (Customer)
posted in assyst Reporting
How to measure Response time on Assyst

Hi Could anyone support me with ideas for measuring response time? on our system, not all services/incidents forms have “callback Required” checked, also we are using some services heavily on system that services contain Workflow so we want to measure the response for that service since ticket logged to system until first stage on workflow closed 

1071
R
Do Gooder (Customer)
M
Sidekick (Customer)
moconnor1Sidekick (Customer)
posted in assyst Reporting
PowerBI Report Build/Templates Community Share

Does anyone currently utilize PowerBI for their reporting? Would the assyst community find it beneficial to potentially share some of the different templates you've created or structure you’ve put together to present useful and efficient reports?Thought it could be beneficial to center some of that in a community conversation thread as opposed to having to schedule calls with other IFS assyst customers through our account managers etc! Full disclosure we are in the exploratory stages of PowerBI as we transition from on-prem to SaaS with our assyst instance. Very interested in seeing what people have done and built, and of course if anyone is willing to collaborate and share all the better!​​​​​

83515
Marcel.Ausan
Ultimate Hero (Partner)
C
Sidekick (Customer)
ChrisButtersSidekick (Customer)
asked in assyst Reporting
How to Identify Where a Ticket is Assigned to at the Point of Breaching SLA

Hello All, Has anybody before been able to using SQL identify where a ticket is assigned (SVD) to at the point when the ticket has breached?If so would you be kind enough to share this with me

1261
paulc
Do Gooder (Employee)
G
Sidekick (Customer)
girvandSidekick (Customer)
asked in assyst Reporting
Daily Dashboard Report

Hi All,Just wondering if anyone has come across this dashboard demonstrated in the assyst Essentials training on the IFS Academy? I appreciate if anyone can advise if this is a custom dashboard or something available out of the box? Best regards,David.

2922
A
Do Gooder (Employee)
A
Do Gooder (Customer)
Amal.aljohaniDo Gooder (Customer)
asked in assyst Reporting
Set up report show ticket history

Hi Could anyone recommend report to show the full history of ticket in one page? I need to know how much time ticket spending in each service department 

2711
paulc
Do Gooder (Employee)
M
Do Gooder (Customer)
mancelticDo Gooder (Customer)
asked in assyst Reporting
Report Menu on End User Portal

We have been creating some standard reports in Assyst Web using the report wizard as well as some dashboard reports too.We would like to make those reports available to groups of users. In some cases, those users may only be contact users and in other cases they may also be assyst users as well.I’ve looked through the WIKI and have verified our privilege groups for both end users and support staff have all the required entity privileges. Using the Assyst web report wizard I was able to create, share and publish a report. In Assyst Web I can now see that under my Subscriptions. However, I’m not able to enable the Reporting Menu item on our end user portal to make the report available there. (1). Has anyone setup the Net End User Portal to enable the reporting menu icon/item and if so what controls that?(2). Has anyone figured out how to get published & scheduled reports to email users once run?(3). When you publish your report to contact users, can I assume they see all the subscrib

1712
M
Do Gooder (Customer)
M
Do Gooder (Customer)
musahadziDo Gooder (Customer)
asked in assyst Reporting
Reporting on Assyst infrastructure - SVDs, Services, Offerings, etc

Hi everyone, is there I way (without external reporting) to report on Assyst elements that are not Events, such as SVDs, Services, groups, etc. This would be useful for housekeeping, update and/or migrations. Thank you.

1221
paulc
Do Gooder (Employee)
M
Sidekick (Customer)
mgswillsSidekick (Customer)
asked in assyst Reporting
Annual reporting

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?ThanksMatt

1055
paulc
Do Gooder (Employee)
P
Do Gooder (Customer)
PerkinsJDo Gooder (Customer)
asked in assyst Reporting
Export Results of Full Page Report to Excel

We have several Fixed-format reports we would like to have exportable.  Currently, users of the report only have the option to print the results to a PDF format.  Because we are a SaaS customer, we do not have access to the internal functions of BIRT, SQL, or the reporting server.  I’m hoping there is a setting I may have missed.  Thanks!

6937
M
Hero (Employee)
pasmith
Do Gooder (Customer)
pasmithDo Gooder (Customer)
asked in assyst Reporting
Chatbot Reporting

We are currently going through the installation of the assyst chatbot in our test system, and are starting to think about how we can report on user interactions with the chatbot.Would any existing customers of the chatbot be able to suggest the best way on how the report on the efficiency of chatbot interactions? So interactions that result in events being logged but more so the interactions that do not result in events being logged. The desire being to identify gaps in Chatbot responses or to highlight the most common types of questions/language used by users looking for services.We are an on premise assyst customer 11.5.Thank you

1191
C
Hero (Employee)
C
Do Gooder (Customer)
coker-bDo Gooder (Customer)
asked in assyst Reporting
Reports Showing Remarks for Each Action?

Hello - We are using AssystWEB 11.1 and need a report that shows the remarks for just one action type. I can’t find a canned report for this. Any suggestions? Thanks in advance.

932
paulc
Do Gooder (Employee)
S
Do Gooder (Customer)
simardlDo Gooder (Customer)
asked in assyst Reporting
How to setup BIRT data Source to point to SaaS Environment

I am trying to change the data source of a BIRT report (e.g. rptdesign file used by assyst Report Wizard) from our on premise database to the cloud Saas Database, I was using Database URL “jdbc:sqlserver://W-99999-D5E:1523;databaseName=PDRPSQGCG;”and the connection was working fine.But now I was told to use “jdbc:sqlserver://cac-99301-axios.secondary.database.windows.net:1433;database=99301;” as an example but it fails the connection. I tried various combinations but still no success.IFS Support was not able to help other than we were able to test the connection tot he database using SSMS so all indication points to the BIST data source to be incorrectly specified.Does anyone have the proper info to setup the the connection?

1873
S
Do Gooder (Customer)

Badges

Show all badges
Terms & ConditionsCookie settings