@name, firstname doesn't resolve in notes
sometimes technician's names are not resolved to mailadres in notes although the name was listed in the dropdown. There is only one user in de database with that name.
Add Date Filter Criteria in Custom Reports
We need to be able to run reports based on date fields less than, greater than, etc. compared to a dynamic date (ex. current date). The Data Filter options does not have Less Than, Greater Than options but Advanced Filter does. Advanced Filter does not
Help producing a report
Hi, I need help producing a report similar to the dashboard widget "Request Summary". The report need to show amount of incoming and resolved requests for a specific support group , and any requests with expired SLA. Preferrably with a similar graph
Query results not complete
Hi, This query (once received from you) gives results till 2022. Newer requests are not displayed. Can you provide me a new working one? Thank you SELECT wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",dpt.DEPTNAME "Department",wo.TITLE "Subject",ti.FIRST_NAME
Request status times report
I was asked to set up a report that shows the amount of time that a ticket was in each status. Open: How long was the ticket Open until it was set to "In Progress" In Progress: How long was the ticket In Progress until it was set to "Resolved/closed"
Report - Tickets older than X time and tickets with no replies
Good afternoon friends, Our COO asked we devise separate reports which will show him two things. 1. Any open/assigned/unassigned tickets which are older than 10 days 2. Any tickets that are open/assigned/unassigned that have no response. I'm fairly certain
Exporting Requests to PDF
I want to export my request to PDF so I can print them and show them to my manger.
Problem with the chat section of the software
Hi, when some users, but not all of them, try to use chat, they get an "Internal error" error on the user page.
Group By for Query Reports
Is is possible do Group By Query Reports like you can on Custom Reports? I have wrote a Query Report to replace an existing Custom Report for Pending Requests to give more control over how the data is formatted. For example only displaying a portion of
Report on Notes
Hello. Could you tell me if there's a way to generate a report to track open tickets that don't have a note? We'd like to create a dashboard that displays tickets transferred from one support line to another without a note added.
Custom Reports for Service Request Resources... When?
Are there any plans to add the ability to customize reports with questions related to Service Request resources?
Report Not
Dear ME SDP Team, I generate a report and export it as .xlsx. why did it always saved as .zip file. and everytime i tried to extract the zip file, it would return an error right now i couldn't export any kind of report. it is always exported as .zip Can
Query Report for Asset Change History
Dear Support, I need report for asset change history for tracking of Asset Movement, I have report which only displays the first user and assigned date. I need the report for complete asset tracking from first user towards current user. (Ex: 1st assigned,
Can you make the figures in a Chart by Summary Type or is it only by count of records?
It looks like the values in the Charts are based on the number of records and not the summary type. Is there a way to get the Summary Type values to be displayed on the Charts? For example, if I create a report based on Time Spent, and I want to Summarize
Online/offline technicia report
Hi, can anybody tell me is there any way to check whether technician being online manualy changed to offline by button in user profile? Maybe report or sql query with name, last name, login, time from to online, and time from to offline best regards,
SDP User assets history
Hi, I wonder how can i generate a report of user's assets history, including assets that are re-assigned, expired, disposed? including Asset name, Product, Product Type, date of assignment/ unassignment? Thank you. Drason
On Behalf of field
Hi - in the reporting module of SDP there is a field that you can report on called 'on behalf of user', however we are unsure how this field is used as we are unable to find anything where you can log a ticket on someone else's behalf. We also saw (see screen shot attached) that there was a field called 'onbefalfofVIPuser', but since logging out and back in again, the field has gone. We are using 9.1 9120 Please advise. Thanks Lynne
[Free e-book] Get started on AIOps without spending the big bucks
Hi there, Is your IT drowning in siloed tools, sluggish responses, and constant firefighting? It's time to break that vicious cycle and expedite IT outcomes with AIOps. Download our latest e-book and discover how analytics-driven AIOps eliminates silos,
Expedite IT outcomes with GenAI and AI capabilities [Free webinar]
Hi there, Still relying on gut instincts for IT decisions? You need GenAI-driven analytics. GenAI is reshaping the way IT teams work. From smarter forecasting to anomaly detection, it helps organizations forecast service disruptions, find an outage's
Asset Report with Firmware
Hello, I can see that some of the assets we scan have an entry for firmware, but I can't figure out where that's stored in the database. I have this query report, which pulls everything I need except the firmware. Any idea what I need to add to it? Thanks!
[Mastering Analytics Plus 6.0 webinar series] Explore IT’s first decision intelligence platform
Hi there, We are thrilled to kick off the first session of our upcoming five-part webinar series, where we walk through Analytics Plus 6.0—IT’s first-ever decision intelligence platform. While traditional analytics stop at telling you what happened, decision
Schedule Reports issue
Dear Sir, I have set a schedule report. it works good. If the schedule report doesn't have any data, may I set the system don't send mail ? Thanks. Finley
Unable to connect to mail server. Check configurations and try again.
REPORT ON CHANGE SHOWING CHANGE IMPLEMENTER
How can we generate a report on a change implemented by a particular user? We tried with custom reports but there is no column like change implementer. A query can work as well
DueBy Date Report
Hi ALL I need custom report based by next rules: 1) Request age: => 12 Hours 2) Request Status: Not Closed and Not Resolved 3) Field "DueBy Date" is empty / Not Assigned Report must contains next Columns: Request ID Request Status Approval Status Request
report from requesters and than email requesters
Dear All, We would like to have a SQL Query report with below columns: a) Request ID b) Subcategory c) Region d) Requester c) Email requester d) login requester and also add filters: groups, service category, service request, request status, subcate
AI and ML: The ultimate solution to IT’s greatest challenges [Free e-book]
Hi there, Repetitive incidents, outages, and security gaps often drain your team's productivity. But what if you could establish a proactive ITSM landscape where AI and ML proactively predict, prevent, and resolve issues before they strike? Our new e-book
Cost of service - reports
Hi, I am interested to understand where we can use Service cost attribute: There is an option to define cost per each service. Is there any report that can show us total cost per closed requests?
History in the reports.
Hi. Please tell me how to view the change history in the reports. Someone deleted the report and now the running task is triggered, emails arrive, but they are empty and the task is not displayed in the scheduler. The report is also not in the list of
Useful MSSQL queries for additional fields
Since i was not able to find the queries i needed i made my own and decided to share them in case they could be useful for someone else. Tested on build 14.9 Build 14920 MSSQL database Show additional fields and what templates (if any) they are used in:
Report for Marked Tasks
Would it be possible to get a report made for open Tasks that are marked and not yet assigned? It's difficult to keep track of these so sometimes if a task does not correctly change to assigned when it should it'll go untouched for a while until we accidentally
Reporting on Assets - DB growth
We want to get a report out of our SDP's CMDB to detail the growth in the number of servers for the last 3 weeks. Next step would be to correlate with previous periods to estimate how fast that number grows, so we can then order the correct number of
[Free e-book] 5 hidden IT correlations you’re overlooking
Hi there, Is your IT team stuck in the constant loop of reacting to issues instead of preventing them? Fragmented data and siloed operations are the likely culprits! Uncover hidden dependencies and build proactive operations with the power of AI-driven
Extract all requests/changes in .csv
Hi, greentings We need to extract a complete report of all requests and changes registered in the on-premise SDP What is the recommended procedure?
Looking for how to see the time tickets are in a specific request status on closed tickets for each month to compare data over time.
Hello, I am trying to see how I can run a report on all tickets that were created in a specific month, such as January 1-January 31st. I'd like to be able to get the average time those tickets were sitting in a specific status, such as "on hold", or "awaiting
Report column not available in summary
I must report mileage in my client worklog report but although the Mileage field (added as additional field) is not available in summary. Report was added in Custom / worklog module.
Reporting by combining request status columns
I am getting a category based report. In this report, I want to combine the columns of open, pending and some others in the request status under a different name Open + Pending => OPEN 3 + 2 =5 Closed + Resolved => CLOSED 2 + 2 = 4
The “Enterprise” field is not displayed in the ESM catalog in ServiceDesk
While working with the ESM catalog in the ServiceDesk system, I encountered an issue: the “Enterprise” field is displayed on one instance of the system but is missing on another. P.S. In English, the word “Enterprise” translates to “Компания” in Russian.
Requester allowed to view - need report
Hi ALL We use SDP 14840 with MS SQL DB I need report about data of setting "Requester allowed to view" of each user - how to ?
ServiceDesk Plus
Hello, We would like to run reports, sorted by technician, of open tickets (incidents and requests) that a technician has had assigned to them for over 3, 7, and 14 days. Three separate reports would be fine. Is there an existing report template in ServiceDesk
Next Page