Customized reports collection!

 
Author
Message
SysAid Wiz
2449
 
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:

https://www.sysaid.com/Sysforums/posts/list/1219.page - Report fix: Software/Hardware inventory duplicate listing fix

https://www.sysaid.com/Sysforums/posts/list/1226.page - Adding your own company logo to SysAid's reports

https://www.sysaid.com/Sysforums/posts/list/1227.page - Removing the windows hot fixes from the "asset changes" report

https://www.sysaid.com/Sysforums/posts/list/1228.page - Creating a basic report "service request list"

https://www.sysaid.com/Sysforums/posts/list/1229.page - Changing the reports page size

https://www.sysaid.com/Sysforums/posts/list/1230.page - Add grouping by admin group to the "Service Quality By Timer" report

https://www.sysaid.com/Sysforums/posts/list/1231.page - Running the "activities by administrator" report for all administrators at the same time

https://www.sysaid.com/Sysforums/posts/list/1232.page - Create a report "Opened/Closed Requests Per Department"

https://www.sysaid.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 Jul. 02, 2009 08:23 AM

Pushing IT forward
Elite SysAider
134
 
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
Elite SysAider
134
 
Actually, I had misread one of the report descriptions... I still am looking for Report #3 as well.

Thanks!
SysAider
1
 
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?
department.txt
SysAid Wiz
2449
 
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@sysaid.com and we will be glad to assist you in using this report.

Best regards.
Haim
Pushing IT forward
SysAider
44
 
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
SysAid Wiz
2449
 
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
Super SysAider
96
 
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?
SysAid Customer Relations
1092
 
Hi lwyatt,

You can put it for a vote if you want to add more Reports.

Regards,
Itay
Best Regards,
Itay
SysAider
2
 
Please update this forum with more custom reports!
SysAid Customer Relations
1092
 
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 Jul. 25, 2010 08:20 AM

Best Regards,
Itay
SysAider
7
 
We are looking for a report that shows all active SRs by company and tabulated beneath each company a note of the SRs outstanding for the company and the status for these SRs.

I'm at a real loss as far as creating reports goes.

Any help much appreciated.