Skip to main content

- - Knowledge base
Product Updates
Events
Groups
Feedback

Community
IFS assyst
assyst Reporting

assyst Reporting

Questions regarding reporting in IFS assyst.

16 Topics
49 Replies

When you subscribe we will email you when there is a new topic in this category

16 Topics

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",

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.

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?

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?

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

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!

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

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.

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

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

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.

mgswillsDo Gooder (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

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!

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

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.

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?

Badges

IFSRUNINNOVALhas earned the badge 25th Topic
SRHhas earned the badge 25th Reply
JenDineenhas earned the badge 10th Topic
geekgalhas earned the badge 1st Reply
SIRIWVhas earned the badge 5th Topic

Show all badges

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Login as an IFS Employee

or

Username (Do not use your email as a username.) *

Email Address (Use your work email address.) *

Name *

Company *

Account Number

(Private)

Only you and moderators can see this information

Job Title *

Member Type *

IFS Employee IFS Partner IFS Customer Just Visiting

Products Used

(Private)

Only you and moderators can see this information

IFS Cloud IFS Applications FSM PSO Maintenix Fleet Planner Alliance FieldCentrix assyst MWM Other

Country

Password *

I accept the terms & conditions

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Login as an IFS Employee

or

Username or Email

Password

Remember me

Forgot password?

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK