[Free e-book] Guide to data democratization
Hello folks, We're delighted to bring you our latest e-book, Guide to data democratization. In this e-book, we discuss the challenges faced by enterprises in handling the deluge of data coming in and suggest several helpful frameworks for democratizing data to facilitate data-driven decision-making.
Asset first assign report
Hello to all, is it possible to obtein first asset assignment (asset and user detail) in a report? Our installation uses SQL. Thanks in advance
Is it possible to run a report to search for a specific local user on all systems in the domain?
cmdb>workstations>system>user accounts. In a nutshell.. When new systems are unpackaged and before they are joined to the domain the system is logged on to the first time with a user admin with no password. Windows and oem updates are applied and the local administrator account is enabled and set with our in house password. At this time the computer would be restarted and the setup account would be deleted. Last week I was troubleshooting a computer that had been in service for a little over a year
Add Request Detail
HI, Would it be possible to add the request information to this MS SQL query (request ID, description, Requester, etc) SELECT TOP 10000000 qd.QUEUENAME AS 'Group', ti.FIRST_NAME AS 'Technician', dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (wo.createdtime/1000),'01-01-1970 00:00:00') as 'Date', count (wo.WORKORDERID) AS 'Inbound', count(case when (std.ispending='1') THEN 1 ELSE NULL END) 'Total Pending', count(case when (std.ispending='0') THEN 1 ELSE NULL END) 'Total Completed', count(case when
Query to list Asset ordered by date of add to asset inventory
Hi, i need a list where can i find the whole asset inventory ordered by date of add to the system. Thanks to all for the help
Worklog/timespent report (with changes and projects)
Hello, we have a time spent report, but only show the worklogs from workorders. We want to show also the worklogs from changes and projects. I have seen this report but don't work in my environment: https://pitstop.manageengine.com/portal/community/topic/timespent-report-requests-project-and-changes We have SDP 11.0 and SQL Server. This is our query now: SELECT "ct"."TS_ENDTIME" AS "Hora de finalización del tiempo empleado", "wo"."WORKORDERID" AS "ID de la solicitud", "wo"."TITLE" AS "Asunto", "ct"."TS_STARTTIME"
Matrix Report
Is this even possible to do with the MAtrix? In order to help track the team’s metrics in tracker, we need a report(s) that will accurately capture our daily work load. Please see the data we need to capture per associate. Associate Name Starting Ticket Inventory New Tickets Received Processed Closed Tickets Ending Ticket Inventory Ashaki 0 0 0 0 Duy 0 0 0 0 Kevin F 0 0 0 0 Lacy H 0 0 0 0 Liz R 0 0 0 0 Prasath S 0 0 0 0 Jennifer R 0 0 0 0 Not Assigned 0 0 N/A 0 Morning Report · Starting
Query to show user with no email address
Hi how do i create a query to show a list of requester accounts that do not have an email address? i am using ServiceDesk Plus 11.1 Build 11115 regards Graham
Monthly Count of Request, Ave. Time to Respond and Ave. Time to Resolve
Hi guys, Any idea how can I create this custom query/report? Monthly (or previous month) Count of Request, Ave. Time to Respond and Ave. Time to Resolve Criteria: Support Group Technicians Product: ME ServiceDesk Plus (Standard) Version: 11.1 Build 11115 Database: PGSQL Thanks in advance for your help.
sort project report on "Task Order" field
I run a custom project report and sort by Milestone's and Task's (sql query at end of post). In the Project > Kilestone > Task window you can reorder the tasks, is it possible to sort Task's column by the "Task Order" field. See image below. I have looked at all the fields in the taskdet table and cannot find anything. I'm running 11.1 Build 11117 Database is MS SQL Thanks Sal SELECT projectdet .PROJECTID "Project Id", projectdet.TITLE "Project Title", projectowner.FIRST_NAME "Project Owner",
Need a report on how many requests were assigned per day per technician
Hello, I need to be able to find out how many tickets are assigned per day to each technicnian. Is this possible? Thanks Edd...
Can I get this in SQL
Hi This post is what I need to do in Analytics plus - but it is in postgresql Can I get the query in MS SQL? https://pitstop.manageengine.com/portal/community/topic/create-rport-to-track-current-open-requests-for-each-day SELECT aau.first_name AS "Technician", now() AS "Date", Count(wo.WORKORDERID) AS "Requests" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser sdu ON wos.OwnerID = sdu.UserID LEFT JOIN AaaUser aau ON sdu.UserID = aau.User_ID LEFT JOIN
CREATE A QUERY REPORT
I would like to create a report that allows me to see all the ticket data, such as the tasks, notes and responses that have been added to a request
Asset Explorer - Install Location of Scanned Software
Does AssetExplorer collect the location that scanned software is installed to? If so, how do I query for that? Thanks
Query for Completed Request
I'm not able to create a report for what I need but I'm hoping a query can. I'd like to be able to see request that have been completed either with Resolved and/or Closed. But then at some point those request changed Technician after it was already completed. And I'd like to see what technician it was with and then who it went to.
Custom Report Access to Department
Hi, We have created custom report, we need to give access to generate respective department data. How can achieve this, could you please help on this. Regards Vajram Gajengi
IT analytics in 90 seconds: Boost ROI by tracking the life cycle of help desk assets
Discover cost-effective ways to manage your assets, and increase ROI by tracking your assets' life cycles with Analytics Plus reports. If you're not already using Analytics Plus, download your free 30-day trial today.
Subscription query with dynamic dating
Hello, I am trying to create a scheduled report that runs every morning and dynamically updates the date to the last 24 hour period. I've got the query running from "yesterday" at 0600 through "today" at 0559. Is the a way to set it so I don't need to manually update the date on the query? I am running ServiceDesk Plus 11 build 11004 with MSSQL SELECT "wo"."WORKORDERID" AS "Request ID", "aau"."FIRST_NAME" AS "Requester", "cd"."CATEGORYNAME" AS "Category", "scd"."NAME" AS "Subcategory", "wo"."TITLE"
Report for time to categorize request (or time to assign request to a tech)
Need report for all requests to see time to assign technician to a request. Because of call-center technicians, they are to slow to work with the requests, I want to create an SLA for them, but I need to see a time needed them to assign a tech to a request
Time Elapsed Analysis
I would like to create a report for all tickets for the last months with how much time the Techninian spent on each ticket status for all groups The time spent on Open The time spent on In Progrss The time spent on Assigned The time spent on Resolved When I open the ticket the tab "Time Analiysis" shows that I want it in a report. for all groups Thanks in advance,
Custom Contract Report - include "Users to be Notified" column
I would like to create a report for the Contracts module and include "Users to be Notified" as a column. Below is information from the Health Meter: Build Information 10.5 Build 10513] Database Properties: Database Server SQL Server Database Host AURSQL01
Report - See requests that were not CLOSED automatically after resolved
Hi all. We currently have Automatic Request Closing configured. The closing is made after 2 days of resolved the request. I want to see what a report would look like that allows me to view the requests that, for some reason, were not or could be closed automatically. From the report wizard I did not find how to do it and I do not have much experience in queries to the database. The SDP version we have is 10.0 Build 10015 Thanks in advanced. Best Regards. Facundo Caballe
Report Query
I have a query report that doesnt deliver the expected result. Depending on "Order by" i get different results. If i set order by 'Acquisition Date' asc i get 200 results in report If i set order by 'Requester' asc i get 100 results in report If i set order by 'Request ID' asc i get 300 results in report This report should give me 379 results Any Ideas out there? select WO.WORKORDERID as 'Request ID', AU.FIRST_NAME as 'Requester', SCF.GUDF_CHAR3 as "Ansvar", SCF.GUDF_CHAR4 as "Verksamhet", SCF.GUDF_CHAR5
Reports not working after update to 11.1
Hi guys, Anyone with similar issues about reports after updating ServiceDesk? We recently update our ServiceDesk Plus to 11.1 and right after, the Reports are not working: Product- ManageEngine ServiceDesk Plus Version: 11.1 Build 11115 OS: Linux Database Postgresql Please see screenshots when opening a report. It's happening to all report created.
Tracking Time for request that have been forward and request is changed of status from Open to Assigned
How i create a query that track or retrieve data time related with the forward request and request that its status is changed from Open to Assign?
Query to see unused categories in servicedesk plus?
We currently are looking at cleaning our categories in service desk plus and I was wondering if it's possible to produce a report that would show you the categories that haven't been used or have been used the least within the last year?
Service Desk Plus MSSQL query Last Update Time - Blank Last Update Time Field
I'm writing today to see if I can get some help with a MSSQL query that is working pretty well. You guys helped me with this awhile back. I having a bit of trouble that I'm hoping you can fix really quick. In the query below how do I change it so that if the last update time field is blank to be the created date instead of the '19700101' I know that I'm close with dateadd create date but can't quite get the syntax right. Thanks Tony Blandin SELECT ti.FIRST_NAME "Technician", wo.WORKORDERID "Request
How create ticket report that contains temporary value ("wait for" status)
Does anyone could give me a tip about how create report that shows tickets with "wait for" status ? I mean, status that was assigned in process of resolution but then was changed to any different status that appropriate for closed ticket. On attached screenshot u can see working history section that has Time Elapsed Analysis section where able to see - does ticket has ""wait for"status and how long.
Seeking help writing a sql query to locate a technician record (using technicianid equals 47105) and changing the technician name from "Monkey, Puppy" to "Shoop, Brian".
Hi. I would like all historical tickets and notes associated with technician by ID 47105 to come up in incident reports with the tech named Shoop, Brian". Currently the history is reporting them as "Monkey, Puppy". The ID for Monkey, Puppy is an inactive technician account. I have validated the technicianid 47105 has the technician name Monkey, Puppy. I would like issue a SQL command that will locate the ID and rename Monkey, Puppy to a valid technician name (Shoop, Brian). I appreciate your help.
Is there anyway to track the time between value changes?
I'm trying to track how long a ticket stays assigned to a specific value through the life-cycle of the ticket. For example: - 20/05 - Ticket01 Created - Technician Unassigned 21/05 - Ticked01 Under Investigation - Technician Assigned to A 22/05 - Ticked01 Under Investigation - Technician Assigned to B 22/05 - Ticked01 Closed I'm trying to track the time (preferably in minutes) between Ticket01 moving from an Unassigned State to an Assigned state and then additional how long A had it before it was
How create asset report that contains hardware datail
Hello, Is it possible to run a query report that includes hardware details? especially the type of hard disk. thank's for your help Fabiana
Seeking sql query to pull incidents and notes where technicianid is specifig (for example 47105).
I am seeking sql query HELP to pull incidents and notes where technicianid is specifig (for example 47105). I appreciate your assistance in advance! Thanks, Scott
Custom report
Hi I'm trying to run some reports that will show me all of the tickets that exist where a custom Request - Additional field is not empty so that I can determine how often the field is used. Let's say we have a custom multi-line field called "Phone". I have tried running a report that filters the Phone field by: Phone Is Not 'None' (I've also tried without the single quotes.) When this report is run, it still shows me tickets where Phone is "Not Assigned". I've encountered this issue with both
Report about requests reopen time
Hello to all, we need a report about reopen time of requests in a specific period of time. Could be possible in SDP Plus? Thanks in advance
query reports error log
Where the errors from query reports are stored? So many times I run the query with no result and no error and I can't debug the query.
SDP - User Access report
We expanded our SDP ESM on-site to additional Departments. We would like to be able to track user engagement by reporting on user logins to the site. Is it possible to build a report tracking user logins?
IP Address Change Report
I would like to schedule a report which will run once a week to show me the names of any assets which have changed their IP address, showing name of asset new IP address and date/time of change of address. I am not sure how to do this, can somebody help me please?
Query report all requests per technician
Hello I'm looking for a report showing created requests per technician per day the last 7 days. I found this https://pitstop.manageengine.com/portal/community/topic/query-report-all-requests-per-technician but I'm using version : 10.5 Build 10500 Database : postgres so the quarry isn't working for me. Any help would be helpful. TIA Daniel
Delete Scheduled Report for Terminated Technician
One of our technicians took a position with another company, so I deleted him from the "Technician List". Then I realized he had some "Scheduled Reports" that are still being generated. 1.) How can I disable his scheuled reports? 2.) Why didn't the scheduled reports go away with the account, when deleted? Thanks!
All tickets assigned to a group even if they were then assigned to another
I have a group that is assigned tickets but then may assign them out to another group. I am looking to report on all tickets assigned to this group even if they were assigned back out to another group.
Next Page