| Author |
Message |
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 25/12/2008 07:57:09
|
Haim
SysAider
Joined: 15/04/2008
Messages: 2449
Offline
|
Hello SysAiders!
From time to time, we receive requests to perform customization to reports in SysAid.
We have gathered some of the customized reports we have created and they are listed below:
http://www.ilient.com/Sysforums/posts/list/1219.page - Report fix: Software/Hardware inventory duplicate listing fix
http://www.ilient.com/Sysforums/posts/list/1226.page - Adding your own company logo to SysAid's reports
http://www.ilient.com/Sysforums/posts/list/1227.page - Removing the windows hot fixes from the "asset changes" report
http://www.ilient.com/Sysforums/posts/list/1228.page - Creating a basic report "service request list"
http://www.ilient.com/Sysforums/posts/list/1229.page - Changing the reports page size
http://www.ilient.com/Sysforums/posts/list/1230.page - Add grouping by admin group to the "Service Quality By Timer" report
http://www.ilient.com/Sysforums/posts/list/1231.page - Running the "activities by administrator" report for all administrators at the same time
http://www.ilient.com/Sysforums/posts/list/1232.page - Create a report "Opened/Closed Requests Per Department"
http://www.ilient.com/Sysforums/posts/list/2351.page - How to add the "expression builder" to reports who don't have it (workload by administrator example)
As we gather more reports, we will keep this list updated, so remember to come back and get updates.
If you need assistance in implementing a report, please post your question in that report's post.
Best regards,
Haim
This message was edited 3 times. Last update was at 02/07/2009 08:23:38
|
Pushing IT forward |
|
|
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 01/01/2009 20:54:22
|
Harold.Ballinger
Elite SysAider

Joined: 16/06/2008
Messages: 132
Offline
|
Awesome, I was just looking for one of those.
Report #1
A modification of the "End Users with the longest SRs time - average" to:
1) Have no graphic (so that more items can be displayed on each page)
2) Include the First Name of the User (in addition to the User Name which already is displayed)
Report #2
A modification of the "Categories with the longest SRs time - average" to:
1) Have no graphic (so that more items can be displayed on each page)
2) When using "Third-Level Category" each 3rd level selection needs to be listed separately.
For example, I have a category listings like "Application -> Microsoft Office -> Help / Training" and "Application -> Adobe Acrobat -> Help / Training" for all of our applications. The third level names are identical, they are just separated so that I know the Application and the type of problem. It seems that instead of realizing that they are separate, that the report bundles all of the tickets in a single "Help / Training" category and reports them all as "Application -> Adobe Acrobat -> Help / Training" in the report instead of as separate instances.
Report #3 (It looks like from your post, this one is already available, THANKS!)
A modification of the "Service Quality by Timer" to:
1) The grouping has an option for "user" but this selection groups by "Admin" and not by user -- I need to be able to group by End User
|
|
|
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 01/01/2009 20:58:06
|
Harold.Ballinger
Elite SysAider

Joined: 16/06/2008
Messages: 132
Offline
|
Actually, I had misread one of the report descriptions... I still am looking for Report #3 as well.
Thanks!
|
|
|
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 16/06/2009 13:59:36
|
JeffD73
SysAider
Joined: 16/06/2009
Messages: 1
Offline
|
I have tried to implement the Requests by Department report.
I added the Department field to my users. I categorized each user by Department.
I made the changes to the Prompt and Scripts. The attached file is the edited script file.
When I run the report, it comes back and says No Data Found.
What have I done wrong?
| Filename |
department.txt |
|
| Description |
Script file for Requests by Department |
| Filesize |
18 Kbytes
|
| Downloaded: |
7 time(s) |
|
|
|
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 17/06/2009 04:10:46
|
Haim
SysAider
Joined: 15/04/2008
Messages: 2449
Offline
|
Hello JeffD73,
Welcome to the SysAid community.
In order to be able to check why the report doesn't find any information, please contact our support team at helpdesk@ilient.com and we will be glad to assist you in using this report.
Best regards.
Haim
|
Pushing IT forward |
|
|
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 29/09/2009 12:30:39
|
CNXS
SysAider

Joined: 14/10/2008
Messages: 18
Offline
|
Hello,
I am new to the reporting facility on Sysaid.
Having looked at some of the files for creating a report i am struggling to create a report, is there an easy way to do it?
I am after two reports (one for open and one for closed) that simply lists the service/change/projects etc for an administrator (during a time period) and for each of the requests details the activities and/or solution to them. I intend to use them during supervision meetings to disscuss performance or problems with tasks.
Do you have a report that already does this? if not how do i go about writing one
Thanks
|
|
|
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 30/09/2009 12:10:33
|
Haim
SysAider
Joined: 15/04/2008
Messages: 2449
Offline
|
Hello CNXS.
SysAid's reporting tool was intended to provide statistical information on your helpdesk's performance.
You can use the "open/closed requests per admin" to see How many requests are being handled by each admin.
If you want to export the details of each request, you can use the helpdesk list.
By filtering the list, you can show requests by period or by a specific admin and export the information to a PDF or CSV file.
Best regards.
Haim
|
Pushing IT forward |
|
|
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 29/12/2009 06:31:47
|
lwyatt
Super SysAider

Joined: 20/11/2009
Messages: 88
Offline
|
JeffD73 wrote:I have tried to implement the Requests by Department report.
I added the Department field to my users. I categorized each user by Department.
I made the changes to the Prompt and Scripts. The attached file is the edited script file.
When I run the report, it comes back and says No Data Found.
What have I done wrong?
Hey JeffD73
I also had problems following the instructions on how to create this report so I had to request further support too.
If these reports are asked for so frequently, I wonder why they are not included in the build?
|
|
|
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 04/01/2010 09:46:19
|
itayH
SysAid support

Joined: 23/09/2009
Messages: 843
Online
|
Hi lwyatt,
You can put it for a vote if you want to add more Reports.
Regards,
Itay
|
Best Regards,
Itay |
|
|
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 22/07/2010 15:26:08
|
krissy
SysAider
Joined: 15/07/2010
Messages: 2
Offline
|
Please update this forum with more custom reports!
|
|
|
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 25/07/2010 08:19:08
|
itayH
SysAid support

Joined: 23/09/2009
Messages: 843
Online
|
Hi krissy, Please try the Report wizard in v7. You can find it under Manager Portal > Design Dashboard.
This message was edited 1 time. Last update was at 25/07/2010 08:20:19
|
Best Regards,
Itay |
|
|