Inventory Reporting
We are in the process of restructuring our IT budget and am thinking about leasing assets to departments, charging them a flat fee per month per asset. My question(s) are as follows... 1) What is the best way to run the report on what assets belong to what department? and 2) Is there a way to implement the internal lease cost in asset management to calculate the total charges to each department per month? If these tasks are not currently feasible to do in SDP, could this be an enhancement for a
custom query postgres
Hi, I'm trying to extract the number of times than particular words apper in the Subject attribut, I wrote this query: SELECT to_char(to_timestamp(wo.createdtime/ 1000) AT TIME ZONE 'UTC-1', 'YYYY-MM-dd') as "Created date",count(*) as "Count" FROM workorder wo WHERE wo.title LIKE '%lent%' and wo.title like '%easy%' or wo.title LIKE '%blocc%' and wo.title like '%easy%' or wo.title LIKE '%rallent%' and wo.title like '%easy%' group by to_char(to_timestamp(wo.createdtime/ 1000) AT
Report to Capture Work Log Details
Can you send me the SQL query to generate this report: - Request ID - Subject - Description - Status - Created Date - Resolved Date - Work Log Details under the Tasks Tab - Owner - Time Taken - Start Time - End Time - Description where I can put in the value for a custom field called "Project" Thanks. Build version: 8.2.0 Build 8217 Database: MSSQL
Need report for total laptop and desktop where asset state is "IN USE"
Dear Support, I have a report that generates all laptop and desktop present in Asset category, I need to specify only in use computers for the report SELECT CASE WHEN (compDefLaptop.ISLAPTOP IS NULL) THEN 'Desktop' ELSE 'Laptop' END AS "Type", COUNT(workstation.WORKSTATIONNAME) "Number" FROM SystemInfo workstation LEFT JOIN Resources res ON workstation.WORKSTATIONID=res.RESOURCEID LEFT JOIN ComponentDefinition product ON res.COMPONENTID=product.COMPONENTID LEFT JOIN ComponentDefinitionLaptop
Reports to Dashboards
How do I go about converting an existing report into a dashboard widget? Also am i able to generate a report graph by itself and exclude the date without needing to manually remove the data?
running reports ERROR
Hello. When I try to run a report I get the following error: we are sorry. The report can not be run, since a report generation is already running for this logon. Because of that I can not make new reports. I have closed the session and rebooted machine. Is there any way to cancel this report generation?
Eport information of Requester
Dear All, Can I export information of Requester: LoginName, Password on old instance to import into new instance. If yes. Could you please give me the script to execute? Regards, NAM.
Stop reports from old manager
One of our management team had created some daily reports in ServiceDesk Plus for himself. He has since left, and we recently disabled his email and now his reports are bouncing back to the helpdesk email account. I've looked though and been unable to find the report to delete it. I have a similar issue with Desktop Central, but will open another question in that forum as well. Any help is appreciated.
Tickets Over 100 Days Old Report
Please can you supply a MS SQL Report that will allow me to list all tickets over 100 Days old? It would need to be the same as this report which shows 25 oldest tickets but showing ALL tickets over 100 Days old :- select Top 25 wo.WORKORDERID"Request ID", LONGTODATE(wo.CREATEDTIME) "Created Time", aau.FIRST_NAME "Requester", wo.TITLE "Subject", qd.QUEUENAME "Group", ti.FIRST_NAME "Technician", std.STATUSNAME "Request Status", DATEDIFF(day, dateadd(s,datediff(s,GETUTCDATE() ,getdate()) +(wo.createdtime/1000),'1970-01-01
Report of the form and field rules for my service request templates
I have been able to get reports that list all my service requests grouped by category, but now I want to take that one further and list various template attributes. In this case, I want to list all the field and form rules defined for each template. Thanks in advance. Dave
How to create custom charts in the Dashboard
Hello everyone, I am trying to create a new dashboard in order to set my custom views with charts & tables. As I have checked the only type of custom report that can be inserted to the dashboard is the matrix type. Please, correct me if I am wrong. Is there any way to insert different types of reports such as charts? For example I have created a matrix report that I wish to convert it into a chart type. The report is correctly inserted as a table to my dashboard but if it could be displayed as a
Need Query for all tickets to see month wise in one specific year
Dear team, I need a query to see all the tickets created in 1 year, and it should be in monthly bases. Please if any one can help. Thank you. Sid
Report Request
Our company is trying out ServiceDesk Plus. I have looked at the canned and custom report settings but can't find what I'm looking for. I have used Remedy for many years. I have setup Categories, Subs, and Items. I would like to run/schedule the below report weekly: 1. A Summary report showing the top 5, 10 or 20 CSI types of requests. I want this to be a high level executive summary/graph report. I don't need to see a summary which includes low volume problem types. Ideally only showing problem
Custom Reports From Manage Engine
Hi there, Just wanted to ask if it is possible for manage engine to automatically save a custom report generated into a folder ? Thanks Niyi
Report with Employee ID
Dear Support, Please help me out in generating this report. which includes Technician, Request ID, Employee ID Requester, Department, subject, created time, completed time resolution as there is no employee id section to select in custom reports.
Reporting a certain hour within a day
Can I create a report that can; Report on tickets created in Service Desk Plus within 5:30 PM to 6 PM (30 min duration) I can't seem to able to create this. Hope someone can help me out.
Custom Report - Technician wise open/closed/WIP requests
Can we have customer report for the following requirements? We would like to have bar-chart report which should represent that Technician wise Open/Closed/WIP requests. When I use 'Tabular Reports' with chart options, it has been grouped by either Tecchnician or 'Open' request only. I cannot able to view the report as I wish to have. Am I missing anything here to build that report? Can we achieve this requirement? Please suggests. Regards, Bala
Incident detail report with Notes?
Hi I need to generate a weekly report on Incidents with their respective Notes. Fields for report: Request ID Requestor Department Subject Notes + Some Custom incident fields. Ive created a Custom Report but the Notes field simply states "Not Assigned" for every incident (bar one) even though I now there notes for quite a few of them. The one that does have something states on word which isnt what the actual incident Notes states. Version of ME: 9.3 Build 9308 Thanks!
9.3 Build 9307 on chrome Version 58.0.3029.110
about 3-5 times a day ME ServiceDesk just freezes, the entire chrome tab becomes unresponsive. all other tabs work perfectly fine, even the ME Desktop Central V10.0.73 works perfectly. eventually about once or twice a day not even a refresh (f5) will work and get the following
Service Request - Asset Details
Can you help me to create a query that will show all service requests with their's data from "Asset Details"block? Thanks you Best Regards
Single 1 year report grouped by month of created time.
Dear Support team, I want to Generate Report of all the tickets of 1 year group by months on basis of Created time. Can you please help me. Thank you.
Need query to show all support groups that have a group e-mail address
I currently have this query but it brings up a report that is 342 pages long. I only have 20 support groups so the report shouldn't be this long SELECT qd.QUEUENAME as 'Support Group',qe.EMAIL as 'Support Group E-mail',qd.SENDERNAME as ' Support Group NAme', qd.REPLYADDRESS as 'Support Group Reply E-mail' FROM QueueDefinition as QD LEFT JOIN Queue_Email AS qe on qd.QUEUEID=qe.QUEUEID Can the query be modified to show all support groups that use a group e-mail address? I am using SDP 9.3 build 9309
reporting on service catalogue custom field
hi i have built a standard report but i wish to add into it a custom field that was set up on the service request when i view query i get the below sql statement, what i would like to add to this is the custom column UDF_CHAR2 but have no idea how to do this. i assume i can add it to the select statement. SELECT `aau`.`FIRST_NAME` AS `Requester`,`wo`.`WORKORDERID` AS `Request ID`,`aau`.`FIRST_NAME` AS `Requester`,`wo`.`TITLE` AS `Subject`,`wo`.`CREATEDTIME` AS `Created Time` FROM `WorkOrder` `wo`
Keep receiving Ajax error when running reports ' Cannot read property of document NULL'
Since we first installed Service Desk plus the reports have not worked correctly. I opened a support ticket and they had me remove the reports directory and restart the services. When I did that it recreated the directory and one report worked one time. Shortly afterwards, it continued to generate the error repeatedly. Has anyone else encountered this problem? I just trying to pull a worklog ( hours) report. Adam
Query to Check Online Users
Hi, May I ask for assistance for a query to check how many users are currently logged-on to the system? We are using a PostGres DB. I want to use this to check if there are logged on users before I restart the server. Thanks!
Report Columns
I have to create task reports which will include data from comments and description fields. These options are not available in the column selection. How do I add these columns to the report templates. Thank you.
Query Assistance - Support Group
Hi Can you please assist with creating a query for (active) Support Groups with the following fields: Name Owned By Business Impact Description, Technicians interested in this group Send notification to group technician(s) when a new request is added to this group (Notify To) Send notification to technician(s) when a request in this group is left unpicked (Notify To and Notify After)We are on Version 9.3 Build 9303, MSSQL. Many thanks.
Asset and Software Reports
Hi Is it possible for SDP to generate reports for: Computers by Age Soon to expire Warranty Expired Warranty Software Product Keys Software License Compliance Software Licenses to be Renewed Regards inamuddle
First Time Response in business hours
Good afternoon, I am considering migrating to servicedesk plus due to the possibility of setting up business hours, but I have not found a report that can inform me the average time of the first response and close time, based on business hours. Is there such a report? Is it possible to develop one?
Problem with the Servicedesk+ App for IPhone and Android.
Hello together We have a Problem with the Servicedesk+ App for IPhone and Android. The Problem is that we can only opening our Incidents but not our Tasks and approval. On my IPhone i have the following Error Message: Request failed unauthorized (401) On the Android Phone we become only a message with ERROR. I have Admin rights in Servicedesk+. What can we do to solve the problem? Thank you and kind regards
KB Query Report
Dears , i Need a Query Report showing all KB installed on All Assests , I am Using Latest Version & MSSQL 2008. Thank You
Report showing Business rules activity
Is there a way to report on the activity of business rules? As we automate and set up business rules, we want to track all tickets for the previous months, and which one has a business rule modify them. If possible, it would be great to identify which business rule triggered. We are using the latest version of ServiceDesk with MSSQL database. Thank you.
Get tech members of group via SQL
Hello! how can I get members of tech specs group via SQL query? thank you!
Scheduling Report - Share to other Technician
Hello Partners, how can I share my scheduled reports for other technician ? Rgds Bart Warsaw/Poland LUXMED Company BUPA Group
Report links show old server
Hello, We recently migrated our Servicedesk Plus install to a new server. Today I ran a Requests report. The links to the requests in the report pointed to the old server's URL/port. What can be done to update this?
Pre-Defined Report
Hi, Can I change some filter criteria of a pre-defined reports, and save these changes for the next use, without redoing the criteria again? Thanks
CMDB Report RelationShip
Hi, It's possible to make a report that list all relationships related to "Bussiness Services" by hand? i wanna know how much Business Services are related to one server. My CMDB schema is BService-->APP-->Server-->Datacenter and i have support groups for APP and SERVER, is it possible to create a report with this information? Regards.
Modify Query Report
SELECT (SoftwareList.SOFTWARENAME) "Software_Name", MAX(aaov.NAME) "Site", MAX(SystemInfo.WORKSTATIONNAME) "Workstation" FROM SoftwareInfo LEFT JOIN SoftwareList ON SoftwareInfo.SOFTWAREID=SoftwareList.SOFTWAREID LEFT JOIN SoftwareType ON SoftwareList.SOFTWARETYPEID=SoftwareType.SOFTWARETYPEID LEFT JOIN Systeminfo ON SoftwareInfo.WORKSTATIONID=SystemInfo.WORKSTATIONID LEFT JOIN Resources resource ON systeminfo.WORKSTATIONID=resource.RESOURCEID LEFT JOIN ResourceLocation resLocation ON resource.RESOURCEID=resLocation.RESOURCEID
Query or Report: Report of workstations without a "ABC" software
Hello, looking for a report or query that produces a tabular report listing the following information. Workstation/Computer name | User | Service Tag | Last person to login of all computers WITHOUT a specific software Software = ABC software. Thank you in advance
Can you provide me with a query to report how many computer workstations have a specific software installed and how many do not?
I need to query for a specific software named "Sophos" installed on workstation and site location of the workstation and how many do not have "Sophos" installed Thank You!
Next Page