2 Questions in regards to a SQL Script.
I created the following Script in MSSQL and it is working. SELECT Change_fields.UDF_CHAR1 ,ltrim(dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (CREATEDTIME/1000),'1970-01-01 00:00:00')) 'Open Date' ,changedetails.CHANGEID ,INITIATORID ,TECHNICIANID ,STAGEID ,PRIORITYID ,CATEGORYID ,SUBCATEGORYID ,ITEMID ,APPR_STATUSID ,CHANGETYPEID ,URGENCYID ,TITLE ,DESCRIPTION ,SCHEDULEDSTARTTIME ,SCHEDULEDENDTIME ,COMPLETEDTIME ,NOTESPRESENT ,SITEID FROM ChangeDetails, Change_Fields where ChangeDetails.CHANGEID
deleted table is not restoring after backup.
I removed a table from database, and after a made restore a backup. Why a deleted table is not restroing?
Creating Requests in Resolved State do not Close
Hi Guys, I think I have discovered a problem in SD+ using build 7605 If I create a new request, fill it out and set it immediately to a statues of Resolved, the request remains in a status of resolved and does not close after 5 days which is our rule. In fact it never automatically closes However, if we create a call, save the request in Open Status and then reenter the Request and set it to Resolved, the request does close after 5 days. Is this a known issue ? The reason why we create
Operational Hours
Hello, I would like to know that if i worked in SQL server with the datatables below, i would manage to configure diferent operational hours for different days. OperationalHoursDef HoursOfOperation DaysOfOperation I really need configure the hours of Friday with different operational hours from the rest of the week. Thanks & Regards
Report for requesters
Is there anyway I can have a report that is viewable by certain requesters, its mean to show statistical information on changes that they have requested. I currently do not see an obvious way in the application functionality to do this.
SLA's totally confused
Okay. So I've read the documentation back to front but I'm utterly confused with the SLA timing... INFO: Our internal Service Desk has the following operational hours: Monday-Friday 09:00-18:00 (9 working hours per day) We have the following SLA's QUESTIONS: Q1. If I set a 1 working day response/resolution does SD+ take into account our working day is made up of 9 hours and not 24? I want to ensure that a request raised on a Friday at 14:00 doesn't reach the 1 working day SLA until Monday at 14:00
A way to remove incident list filters
How can I remove preset filters from the Filter drop-down in the Incidents list? Most are irrelevant to my team and make it difficult to select the one we want.
Automatic entrance in Service Desk Plus 8.0
Hi, how to make an automatic entrance in Service Desk Plus with login and the password with which the user entered into windows?
\setcommonevn.bat is not recognized
Hi guys I am running this script: net stop servicedesk call C:\ManageEngine\ServiceDesk\bin\backupData.bat net start servicedesk I am getting the following error message: \setcommonevn.bat is not recognized as an internal or external operable program or batch file java is not recognized as internal or external command
ServiceDesk Plus Hotfix 8026 Released
Dear Users, Hotfix over 8000 is released ( 8026 ). And you can refer to the enhancement / issues fix included into this hotfix from the blow link. http://www.manageengine.com/products/service-desk/readme-8.0.html#8.7 README content : Enhancements in 8026 : Request SDF-44926 An SDP API reference implementation is provided to generate tickets in SDP via API. Custom implementations can be written to perform specific tasks and API implementation can be invoked to create tickets in SDP. An SDP server
Requester is able to see worklog using request print preview!
Correct me if i'm wrong - requester should not be able to see worklog details? I've already wrote that in other topic, but still no support request.
After Upgrading User List
Hi, Sometimes, my coworkers ask me to upgrade users list from AD to SD+; but the thing is that 3-4 user are upgraded but it only says "added users: 3". It could be very useful that after the upgrading it says the name or account added and those with errors. Regards.
Wish to import MS AD values accountExpires and lastLogon
Hi I try using the "Import from Active Directory" to import "accountExpires" and "lastLogon" from our MS AD but have no values from imports. Any idea what could be wrong? Regards Per Nilsson
Change 'Last Week' from Sunday-Saturday to Monday-Sunday
I've noticed that the predefined date filter for Last Week starts on a Sunday and finishes on a Saturday, unfortunately our working week starts on a Monday. Is there a way to change Last Week to start on a Monday and end on a Saturday instead?
Asset scan airwalled
Hi, I have Service Desk Plus installed on a production server which is airwalled so it can't see UAT versions of the servers, this is obviously causing an issue with Asset scanning, scans fail. Is there any way to get round this, can I just have the asset scan performed from a server which isn't airwalled which then pushes the information to the production server that has the Service Desk installation? Any help would be appreciated. Thanks Jonny
After 8024: My users cannot open request
Hi, After I applied the lastest version 8024 my users cant open request!! I Need help, my operation stoped!!!!! They click on Add Request but nothing happens.
Manual Installation of Assets
Hi, We need to scan our Assets through SDP, so we are going to use Manual Installation. The following files was downloaded from our SDP: 1* ManageEngineAssetExplorerAgent.msi 2* scan_setup.vbs 3* ae_scan.vbs And then we are install these files in the remote workstation, also please note that we open the 2nd and 3rd files with command prompt. But we the SDP fails to perform the scan. Could you please help us to solve this issue soon. Thanks in advance Regards
ServiceDesk Plus Hotfix 8025 Released
Dear Users, Hotfix over 8000 got released, this contains the fix for the below issue. (README) SD-44937 : Unable to add request by requester from self-service portal using the template where text additional field with default value and restriction for the requester to view alone has been fixed. Hotfix upgrade pack can be downloaded from the below link. http://www.manageengine.com/products/service-desk/service-packs.html Please refer to the below link on the instruction to apply the hotfix ppm. http://www.manageengine.com/products/service-desk/service-packs.html#sp
Changing web server port to 80 stops fetching mail anymore.
Hi, SDP linux version was running on port 8080 initially. I could successfully configure mail fetching then and it was creating requests automatically from the mails received on the email configured. Now, when I changed web server port to 80, it stopped fetching emails completely. I think I tried all permutations in Admin page. Every time I try to save configuration in Mail Server Settings Admin page, it takes lot of time to save without any successfull notification on top. When I try start fetching
Available Date Templates
Is there a plan to add "this year"? Today - <from_today> - <to_today> This week - <from_thisweek> - <to_thisweek> Last week - <from_lastweek> - <to_lastweek> This month - <from_thismonth> - <to_thismonth> Last month - <from_lastmonth> - <to_lastmonth> This quarter - <from_thisquarter> - <to_thisquarter> Last quarter - <from_lastquarter> - <to_lastquarter> Yesterday - <from_yesterday> - <to_yesterday>
Integration between SD+ & Password Manager Pro
Hi Having been looking at PMPro, I think that a way of integrating Change Management with Password Manager would be good. An example of why this would be useful, is if you have a 3rd party in to do some work on your infrastructure. The Change has been planned and agreed for 21:00 next Tuesday. Password Manager Pro should only release the admin level password at 21:00 and revoke access at the time the chnage is due to be completed. It could also then chnage the password, as PMPro allows. This
Scheduled Backup
Hi Can I suggest that the scheduled backup task would also be able to set how many rolling backups you want to keep, rather than just keep backing up and manually having to remove the old jobs. Most IT techie's would also be running this along side tape backups etc. Cheers
How to disable scan schedule scanning and how does it actually work?
Hey guys, I once enabled a scan schedule, and now disabled it. For some reason SDP keeps on scanning, but adds in all found pc's with it's IP address... Things going awkward here: if i scan my domain, works perfect, all pc's are found and scanned with succes. Scanning through the scan schedule does not work, and i cannot choose what i want to scan with a scan schedule (i have multiple networks and domains)... Turning scan schedule off, doesn't seem to work either. Each morning i'm confronted with
How can i do that "Default request" will include to Common Incidents in Requester view?
May be i should do some changes in DB?
Licensing and upgrade SDP
Hi, i have a question about SDP licensing. We are currently own a license (5 tech\250 nodes) but we are planning to upgrade service in our firm. When we ask to local distributor (we are based in europe) the answer was at least confused. is it correct that i could not merge license without active maintenance on it? On the old one we do not need it and it seems a little bit odd that we had to pay thousands for use what we already paid. I am looking on the site but i could not find a clear answer about
Ticket closure rules
Hi We work closely with other service desks and have set SD+ to not email back when we receive emails from then, as otherwise we end up in a loop. However, when we come to closing tickets, we send a survey email, asking for feedback. If this goes to another servuice desk, they just email back with their call ref. This is counter-productive. Is there anyway that I can exclude certain email addresses from being sent survey emails?
Approvals
Hi I have discovered today that when a technician sends a job for approval to the manager, they type further information around what they are asking for approval on, in the email. This is good. However the manager does not always read the email, but checks their Home screen regularly and actions approvals from there. This does not show the email content. There was a heated discussion this morning where the manager was complaining that the team were not telling him what they wanted approval on,
RPC server not available for TMG server
I am under to see the hardware details for my TMG server after doing a scan. it says RPC server not available. Do I need to create a policy to permit servicedesk to poll the TMG server. I have already allowed port 9000 to go through. what other port number must I permit ?
Reattaching requests to a user
Hi. I had to delete a user, and import him again from AD. Now he can only find the five or so requests that he has put in since I imported him again when he looks at his cases. The old cases lies there with his name on them, but he must now look for them instead of them just being there. Is there any way I can "reattach" the requests to him? Hope somebody can help!
Requester Can't add a new incident after upgrade to Build 8024
I have have upgraded our system from Build 8016 to 8024 and then discovered that no requester can add a request, technicians can adde requests. The user can fill in the template buit as soon as they hit add request it doesn't work, the page just sits there. Anyone any ideas?????
how to track desktop or any asset location connected in a LAN
how to track desktop or any asset location connected in a LAN
service request approval
Hello, I have a question concerning approval for service request. It work fine, but the user cannot see the status of the approval. So if the service request is not approved, no way for the user to see that. So my question is : is it possible for the user to see the status of the approval? And if yes, where should i go to allow that?
How to mark leave and count number of present technicians
We have 10 technicians at a particular site. However, the number of separate logins for technicians is 5. We want to monitor the attendance of all the ten technicians using SDP. By attendance, we mean that the presence of each technician would be marked once in the morning each day. If any one out of 10 technicians is not present on any day, he is marked absent. the total number of technicians present on any day and the monthly & quarterly report of number of technicians present on each day is also
Request Incident Status via Email Command
Is it possible to send an email command to request the status of a specific incident if "e-Mail Command" feature is enabled? I see that we can change the ticket, but I just want to be able to get the status of a specific incident after hours. -Les
An Apple agent yet?
Has anyone been working on a agent to manage Apple desktops and laptops yet? Thanks
Unable to close Incidents
I am unable to close any of our open Incidents. When I click on the "close" button, nothing happens. I'm using the latest version of Firefox.
disable Reporting in SD+
Is there any chances that help me to disable the reports? besides oF the ones that are on scheduled?
Modify and Remove Fields in a PO form
Is there in any way we can customize and edit or remove fields in the PO form? Like the way Incident Templates are customized? Like drag and drop fields?
Integration with Device Expert & SD+
Hi I think integration between Change Management in SD+ and Device Expert, so that the two tools can work together and compare changes made with changes approved. James Gander Gander Service Management IT Operations and Service Management Consultancy
CMDB Integration with OpManager
Hi I understand that the next version of SD+ includes improved CMDB with the ability to build the relationships between different CIs to create a service view. Now I have already built that in OpManager when creating Business Views, so a way to export those business views into the SD+ CMDB would make life an awful lot easier. I don't want my clients to need to recreate the information already within a ManageEngine product, in another ME product. James Gander Gander Service Management IT Operations
Next Page