Exporting Assets with Software Info
I have service desk pro on multiple networks and need to centralize all the assets into one location. I have been able to import some asset information by using the reports feature and saving as a csv. However, I have not found a way to export assets (workstations) with software information. Is this possible?
Date range for reports
We have a custom report that is running to look at tasks and the technician scheduled to the task. Is there any way to have it allow for a date range selection prior to running the report? Looking for a way to show only what is assigned for tomorrow, or 5 days out, etc...
Top 10 Departments Report
Is there a way to create a MSSQL report that shows the top 10 departments that created tickets in the previous month? We would want to show the number of tickets as well. This would be a very valuable monthly status report to determine where the problem areas are. Thanks, David
Can someone help me with building a report?
Hello, I have got to run a report on the asset module for the following items: Computer Name Computer Manufacturer Operating System Operating System Version Computer Model Serial Number BIOS date Device Type (Desktop/Laptop/Server) Physical/Virtual Most Frequent User/Last Logged on User distinguishedName operatingSystem pwdLastSet lastlogonTimestamp cn givenName sn CN userPrincipalName samAccountName DN distinguishedName whenCreated whenChanged userAccountControl lockoutTime pwdLastSet lastLogon
Report based on postgresssql on asset list *URGENT*
Hello, I have the following report doien for me: SELECT workstation.WORKSTATIONNAME "Workstation", workstation.MANUFACTURER "Manufacturer", osInfo.OSNAME "OS", osInfo.VERSION "Version", workstation.MODEL "Model", workstation.SERVICETAG "Service Tag", resource.SERIALNO "Serial Number", osInfo.SYSTEMTYPE "System Type", product.COMPONENTNAME "Product", CASE WHEN CAST(compDefLaptop.ISLAPTOP AS CHAR(5)) IS NULL THEN 0 WHEN CAST(compDefLaptop.ISLAPTOP AS CHAR(5)) = '0' THEN 0 ELSE 1 END "Is Laptop",
Report Filtering Based on Service Catalog Custom Fields
Good day, I'm trying to build a report that filters Service Catalog requests based on some custom fields, however the fields do not show up in my column filter list. Is there some other place they show up, or do I need to build a custom SQL query for my report? Thank you, Mike Taylor
how to sort report by name etc?
Hi there, Stupid question: is there a way to sort a report by name? we put our custom report on a custom folder, but it doesn't sort it by name - see image Thanks in advance!
Outline query for Audit Hist - computers that changed name in last 3 weeks
Can anyone advise the tables I need to use to produce a query that shows the Workstations that have been picked up during a scan that have changed thier name in the last 3 weeks . Time line isn't that important, just want to be able to constrain the query to a timeframe. Can't work out if/which of the audit tables hold the info If anyone wants to produce the report that's even better :-) Thanks, Andy
"others" on graph
Boa Tarde! Estamos realizando um piloto com a ferramenta de Service Desk e esta tem se comportado muito bem. Atendendo os KPIs estabelecidos, robusta, completa, e customizável. Estamos bem satisfeitos com a solução! Quando gero determinados relatórios, no gráfico, os resultados menos representativos são agrupados gerando uma fatia grande de "outros" que prejudica a plotagem do gráfico. É possível remover isto do gráfico ou evitar que as informações sejam agrupadas? Anexei uma print para que entendam
Internet Explorer 10 query
Hi I need to know the number of computers with Internet Explorer 10 installed. Is it posible? Thank you Maria
why are the costs (in hours and money) not exposed to the PROJECTS report?
I want to build a report that takes all the projects in a status of SCHEDULED and tells me the estimated hours and estimated costs for budgeting and planning. But for some reason those fields are not exposed in the report wizard, nor is the project schema available in the query report section. How would I go about doing this? (and why is there not sub-forms in support for projects or Query Report-Projects?)
Projects: Time spent report
Hi team Is there any plans to allow "time spent" reporting from the projects module? Can this be prioritised as it is leaving a major whole in my teams KPI's for time recording. Cheers. Ronekzus
Report: Open Tasks on Active Projects
Anyway to link not just the Projuct ID and name but also the Project STATUS, so I can run a report of open tasks relevant to projects in a certain set of Status' (such as OPEN vs. Scheduled)?
Report on number(count) of assinged requests to each technician for a purticular day/period
Hi Is it possible to extract the above report. In our process we have a coordinator who picks all request and then assign to technicians. This report could help us prepare the report for technician workload Thanks
Queries on postgresql-creation
Can you share knowledge :) What program do you use to create queries in PostgreSQL? Regards
Can't find asset description field in asset schema
Hi, I'm trying to add the description field from the asset module to my report. I tried to find this field in the different shema without any success. Can you please help me Thanks !
Problem on exporting report to PDF format
Dear Support Team, I found this error while trying to export the report which has Thai language to pdf format. In the pdf file, there aren't display all Thai font in the report as you can see in the attach file.
Reports custom queries, multiple SQL-Statements
Hi, can i generate a custom report containing multiple SQL-Statements, i.e.: select * from xxx; select * from yyy;
Reports based on resource values
I need to pull a report that shows all service requests with resource values that match criteria. Is there a way to do this?
Create work log details report
Is there anyway to create a report which lists all of the work logs for each request?
SLA report for a specific department compared to all departments
Can you help me generate a MSSQL report showing a specific department's SLA % compared to the SLA % average for all departments? Time period = prior full month SLA % = (SLA Met / Open) * 100 Is there any way to generate both graphical and tabular information in the same report? I've attached an example image of what I'm thinking. Thanks in advance.
Reporting to department heads and management
Does anyone report metrics out to your department heads or management? If so, I'd be curious to find out what you are reporting, how, and how often. I'm thinking more of an executive style report for each department head that would show open/closed calls broken down by category, SLA in/out, top 5 requesters per department, etc., comparison from the last reporting period. If anyone is doing this please feel free to share! Thanks-Erik
unauditted workstations report
hello how can i generate a report showing unaudited workstations for the last 30 days thank you
Report: average time between two different ticket's status
hello, we would need to generate 2 custom reports. the first one is: average time between template change from "default request" to a custome one (named "gestione rda"). the custom template has two task. the second report we need is: average time between single task completion. thank you, mario zelaschi italian institute of technology
Report with specialist missing data
Helow! Please tell me how generate report by specialist with missing reason field?
Cannot Find SiteID Descriptions / Name Field
Hi, I'm sure i'm probably just overlooking something but i am unable to find the table that links the SiteID field to the SiteName. I'm pulling the data via a SQL load into another program but cannot seem to find the descriptions for the SiteID field from servicedesk.workorder. I've looked under servicedesk.sitedefinition but i am only seeing the following fields SITEID, REGIONID ISDELETED, TIMEZONEID am i missing the NAME field or is it located elsewhere? Thanks, Lee
Issue with SLA Report - MSSQL
Hi We have used below report to show us the Response and Resolution SLA this Quarter as per a previous forum post. After the latest upgrade to 8211 we get some weird figures that I believe is not correct. Both Response SLA and Resolution % is the same and it keeps on being the same everyday. Priority % Resolution Overdue % Response Overdue % Resolution Met % Response Met Low 1.709401 1.709401 98.290598 98.290598 select pd.priorityname "Priority",CAST((sum(case(isoverdue) when 1 then 1.0 else 0.0
Querying history of Servicedesk from database using T-SQL in SQL Server
HI Team We use ManageEngine Servicedesk as our ticketing tool. I want to get a report out of the service desk in which I need to know any request on which I have ever worked upon. Whenever a request is assigned to us or we forward it to other group, each activity is stored in database and is available under history tab of the request. Can you please let me know what is the name of this history tab table in database and which columns are used to store information of technician who worked on the request.
Work Log Report
Hi to all, I was wondering how to create a report for Work Log (By Technician and By Group) having work logs from Requests, Problems, Changes, and Projects (that are open or closed) for a particular date range. The reports available are taking into consideration only requests. As I understand this could be possible with a custom report. My problem is I do not have the necessary programming skills to create one. I am using Servicedesk Plus Enterprise 8.2.0 Build 8207 with the integrated MySQL
SDP - Report Features - Generate a report of ticket "History"
Is it possible to generate a report to include changes that have taken place in a ticket such as a change to "Status", "Priority", "Group"........? Is there a query that has already been created? If not, can one be created? Thanks
Report time spent including projects
How can I create a report that will include time spent on projects as well as changes, requests, problems?
IPhone app
A few issues, in the iPhone app version 2.0.2 1. The Work Log does not insert a date, if I run reports based on work log dates these are missed. 2. There is no way to close a ticket with any modified closure status (we use closed - Maint and closed - Support)
Report based on requester
Hi How can we get a report based on requesters, basically we want to send auto emails every month to the requesters with the status on there incidents and services request. Is it possible to generate the auto emails, and shoot emails.
custom report for current asset value
Looking for a little help creating a report every month to see the asset name, asset tag, current state initial cost, current value and reaming life any help would be great
Software usage function
We are evaluating ManageEngine Service Desk plus Professional 8.2. One of the function we need is the software usage. We like to know how many times a user use a particular application, when is the last time access and average daily use. It is for per user, per application base. We need to justify if a user really needsa application However, after we did the agent or agentless software inventory, the "Usage" shows unknown. How does this work? Thanks, Jimmy
Status Report - Query
1) Dear Support, Please assist with the below mentioned query. We can take individual reports,but would like to take them in one report. SUMMARY HELP DESK REPORT IN A PERIOD (date to date) TITLE VALUE TOTAL HELP DESK LOG / INCIDENT NUMBER OF LOGS AVERAGE RESPONSE TIME TIME AVERAGE RESOLVE TIME (TIME ELAPSED) TIME MOST SUPPORT AS PER CATEGORY NAME OF CATEGORY TASK COMPLETION PERCENTAGE PENDING REQUEST PERCENTAGE MAXIMUM REQUESTS FROM NAME OF REQUESTER
Report Request - all assetts assigned to users
im looking for a report that shows all the assetts that are assigned to users if a users leaves the company i would like to run a report which shows the assetts mobile phone laptops desktop docking station etc that they have assigned to them thanks Russ
Replies to Ticket Report
Is there a way to query tickets to get a report of the replies that are sent under by the technician? I would also need to be able to specify a technician.
Report to Show Customer Interactions
Hi, I'm looking for a report that will show me each update, either a 'Reply' / 'Forward' or 'Note' added to a ticket. We need it as we have a KPI to keepthe customer informed in the ticket process x times a week. It would be the same details as you'd effectively see if you goto a ticket and select Print. Can this be done ? Ian
Reports: show a report with assigning technicians
I need report show assigning technicians. can you help me please??
Next Page