http://www.ilient.com/Sysforums/posts/list/118.page JForum - http://www.jforum.net
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:

[url]http://www.ilient.com/Sysforums/posts/list/1219.page[/url] - Report fix: Software/Hardware inventory duplicate listing fix

[url]http://www.ilient.com/Sysforums/posts/list/1226.page[/url] - Adding your own company logo to SysAid's reports

[url]http://www.ilient.com/Sysforums/posts/list/1227.page[/url] - Removing the windows hot fixes from the "asset changes" report

[url]http://www.ilient.com/Sysforums/posts/list/1228.page[/url] - Creating a basic report "service request list"

[url]http://www.ilient.com/Sysforums/posts/list/1229.page[/url] - Changing the reports page size

[url]http://www.ilient.com/Sysforums/posts/list/1230.page[/url] - Add grouping by admin group to the "Service Quality By Timer" report

[url]http://www.ilient.com/Sysforums/posts/list/1231.page[/url] - Running the "activities by administrator" report for all administrators at the same time

[url]http://www.ilient.com/Sysforums/posts/list/1232.page[/url] - Create a report "Opened/Closed Requests Per Department"

[url]http://www.ilient.com/Sysforums/posts/list/2351.page[/url] - 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

]]> http://www.ilient.com/Sysforums/posts/preList/1233/5343.page http://www.ilient.com/Sysforums/posts/preList/1233/5343.page GMT
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
]]> http://www.ilient.com/Sysforums/posts/preList/1233/5426.page http://www.ilient.com/Sysforums/posts/preList/1233/5426.page GMT
Thanks!]]> http://www.ilient.com/Sysforums/posts/preList/1233/5427.page http://www.ilient.com/Sysforums/posts/preList/1233/5427.page GMT 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?]]> http://www.ilient.com/Sysforums/posts/preList/1233/10647.page http://www.ilient.com/Sysforums/posts/preList/1233/10647.page GMT 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]]> http://www.ilient.com/Sysforums/posts/preList/1233/10650.page http://www.ilient.com/Sysforums/posts/preList/1233/10650.page GMT
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 ]]> http://www.ilient.com/Sysforums/posts/preList/1233/12744.page http://www.ilient.com/Sysforums/posts/preList/1233/12744.page GMT
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]]> http://www.ilient.com/Sysforums/posts/preList/1233/12792.page http://www.ilient.com/Sysforums/posts/preList/1233/12792.page GMT 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?[/quote]

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?]]> http://www.ilient.com/Sysforums/posts/preList/1233/15714.page http://www.ilient.com/Sysforums/posts/preList/1233/15714.page GMT
You can put it for a vote if you want to add more Reports.

Regards,
Itay]]> http://www.ilient.com/Sysforums/posts/preList/1233/15794.page http://www.ilient.com/Sysforums/posts/preList/1233/15794.page GMT ]]> http://www.ilient.com/Sysforums/posts/preList/1233/22506.page http://www.ilient.com/Sysforums/posts/preList/1233/22506.page GMT
Please try the Report wizard in v7.
You can find it under Manager Portal > Design Dashboard.]]> http://www.ilient.com/Sysforums/posts/preList/1233/22550.page http://www.ilient.com/Sysforums/posts/preList/1233/22550.page GMT
I'm at a real loss as far as creating reports goes.

Any help much appreciated.]]> http://www.ilient.com/Sysforums/posts/preList/1233/31170.page http://www.ilient.com/Sysforums/posts/preList/1233/31170.page GMT