Constant font change in notifications
Is there a reason why we cannot set a default for the system? Notifications in the system are wildly inconsistent ranging from roboto to time new roman. If you set the font to arial it will randomly change between both roboto and times new roman.
Creating a request - Paste Image in Description
When creating a new request Copying an image from an other software Pasting the image in the description of the request. The image appears in the Resolution section of the request instead of the Description section. Note: when Editing an existing request this behavior does not happen the image is in the Description. ME MSP Version : 9.4 Build 9421 Database : postgres
Asset Management - report to get the list of inventoried workstations/servers along with their details
SELECT Max(workstation.workstationname) "Workstation", Max(workstation.model) "Model", Max(workstation.servicetag) "Service Tag", Max(state.displaystate) "Asset State", Max(osinfo.osname) "OS", Max(aaauser.first_name) "User", Max(deptDef.deptname) "Department", Max(aaov.NAME) "Site" FROM systeminfo workstation LEFT JOIN resources resource ON
Asset Management - report to fetch the list of detected workstations/servers along with their details
SELECT Max(workstation.workstationname) "Workstation", Max(workstation.model) "Model", Max(workstation.servicetag) "Service Tag", Max(state.displaystate) "Asset State", Max(osinfo.osname) "OS", Max(aaauser.first_name) "User", Max(deptDef.deptname) "Department", Max(aaov.NAME) "Site" FROM systeminfo workstation LEFT JOIN resources resource ON workstation.workstationid = resource.resourceid
Asset Management - report to find the last scanned time of assets and their scan status
SELECT resource.resourcename "Asset Name", Max(net.ipaddress) "IP Address", Longtodate(Max(LASTSUCCESSAUDIT.audittime)) "Last success Scan Date", Longtodate(Max(audithistory.audittime)) "Last Scan Date", Max(audithistory.auditstatus) "Audit Status", Max(aaauser.first_name) "User" FROM resources resource LEFT JOIN resourceowner rOwner ON resource.resourceid
Asset Management - report to find the user accounts of workstations
SELECT workstation.workstationname "Workstation", ua.username "User Name", ua.domainname "Domain Name", ua.description "Description", ua.status "Status", state.displaystate "Asset State" FROM usersaccountinfo ua LEFT JOIN systeminfo workstation ON ua.workstationid = workstation.workstationid LEFT JOIN resources resource ON workstation.workstationid = resource.resourceid
Issues restoring backup to new MSSQL2017 server.
Having issues restoring backup to a new MSSQL2017 server. We're getting the message below when restoring. I left the restore process on for 4-5 hrs and still haven't completed. Please wait extracting backup file Please wait extracting backup file Please wait extracting backup file java.io.IOException: invalid CRC (MAC) for file: fileAttachments/PurchaseOrder/May2019/10599/MicroAge 2058053 05 12 19 $423.00.pdf at net.lingala.zip4j.io.ZipInputStream.close(ZipInputStream.java:77) at
Change Management - count of change requests based on template
SELECT ct.NAME "Template", Count(chdt.changeid) "count" FROM changedetails chdt LEFT JOIN changetemplate ct ON chdt.templateid=ct.templateid WHERE chdt.createdtime >= <from_lastmonth> AND chdt.createdtime <= <to_lastmonth> GROUP BY ct.NAME ORDER BY 1 Click this link to navigate to the next report.
Change Management - report on change roles associated to users on a given change
PGSQL: SELECT chdt.changeid "Change ID", chdt.title "Title", orgaaa.first_name "Change Requester", ownaaa.first_name "Change Owner", cmDef.first_name "Change Manager", stageDef.displayname
Change Management - report on change stages history
SELECT chdt.changeid "Change ID", chdt.title "Title", orgaaa.first_name "Requested by", ownaaa.first_name "Technician", Longtodate(chdt.createdtime) "Created Time", Longtodate(chdt.scheduledstarttime) "Scheduled Start Time", Longtodate(chdt.scheduledendtime) "Scheduled End", Longtodate(chdt.completedtime) "Completed Time", stagedef.NAME
Change Management - changes that have assets involved
SELECT chdt.changeid AS "Change ID", chdt.title AS "Title", orgaaa.first_name AS "Change Requester", ownaaa.first_name AS "Change Owner", catadef.categoryname AS "Category", subcatadef.NAME AS "Subcategory", itemdef1.NAME AS "Item", res.ciname "Asset" FROM changedetails chdt LEFT JOIN sduser orgsd ON chdt.initiatorid = orgsd.userid LEFT JOIN aaauser orgaaa ON orgsd.userid = orgaaa.user_id
Change Management - changes that were caused by incidents
SELECT chdt.changeid "Change ID", chdt.title "Change Title", Longtodate(chdt.createdtime) "Change Created Time", Longtodate(chdt.completedtime) "Change Completed Time", orgaaa.first_name "Change Requested by", ownaaa.first_name "Change Technician", stagedef.NAME "Change Status", wo.workorderid "Request ID", aau.first_name
Change Management - incidents caused by change
SELECT chdt.changeid "Change ID", chdt.title "Change Title", Longtodate(chdt.createdtime) "Change Created Time", Longtodate(chdt.completedtime) "Change Completed Time", orgaaa.first_name "Change Requested by", ownaaa.first_name "Change Technician", stagedef.NAME "Change Status", wo.workorderid "Request ID", aau.first_name
Configuration Management - department head
This report returns the complete list of Department and the department head configured in the application SELECT dept.deptid "Department ID",
dept.deptname "Department Name",
dept.phoneno "Phone No",
dept.fax "Fax",
sdorg.name "Site Name",
aa.first_name "Department Head",
dept.deptdesc "Department Description",
da.first_name "Approver" FROM departmentdefinition dept
LEFT JOIN sduser sd ON sd.userid=dept.deptheadid
LEFT JOIN aaauser aa ON aa.user_id=sd.userid
LEFT
Patch reboot require value incorrect
Hi, Some patches I've seen (e.g. 2019-07 Cumulative Update for Windows 10 Version 1809 for x64-based Systems (KB4505658) ) have the "Reboot required" value as "No" -- but this is incorrect, and after it's deployed it has a status of 'The requested operation is complete. Changes will not be applied until after the system is rebooted'. Is it possible for me to manually change the reboot required value for these patches, so that the reboot request prompt is shown to the user? Thanks!
Tableau reader 2019 2.2
I need to deploy tableau reader and noticed that under the software templates there is tableau reader Tableau Reader 2019.1 x64 (2019.1.3) but I see that there is a newer version 2019.2.2 out but it is not listed under the templates but yet i see Tableau Public 2019.2 x64 (2019.2.2) is there any way to get the deployment for the newer version 2019.2.2? When you run the 2019.1.3 version it says it is no longer supported and wants you to upgrade. Do you know if I have deploy the newer version to
Pre-Installation custom script status error message
Dear all, I am using several Powershell-Scripts as Pre-Installation Activities for a software deployment. I've followed the recommendations from https://www.manageengine.com/products/desktop-central/returning-error-code-on-scripts-how-to.html. The scripts run fine and results in an error code 1 if failed. DesktopCentral translates this error code in a windows sytem error code and return a "Incorrect function", instead of error code 1. (1 (0x1) --> Incorrect function, see https://docs.microsoft.com/en-us/windows/win32/debug/system-error-codes--0-499-)
Installing patch as part of software deploy
Hi! I have two software deployment tasks set up: the first installs version 8 of $SOFTWARE, and then the second installs the 8.2 update for it. At the moment I'm deploying this software using the first task, and then following it up with a deployment of the update task. What I'd like to know is if it's possible to include the installation of the update file into the initial deployment configuration? I've looked at the post-install tasks options but can't see one that looks relevant. Many thanks!
Exchange Reporter Plus' new build released with support to Exchange Server 2019, new standard time zones, and more.
Hello Everyone! We are glad to announce the release of the latest build of Exchange Reporter Plus. It comes with the following new features, and bug fixes: Highlights: Exchange Server 2019 support: Exchange Reporter Plus now audits, monitors, and reports on Exchange Server 2019. Advanced IIS logging: Supports IIS log parsing to identify the actual source IP address behind a given proxy server. SMS notification: In addition to email, you can now receive audit and monitoring profile alerts via SMS.
Purge CMDB
Hi We use ServiceDesk Plus and have been using it for a number of years. The CMDB has been abandoned for some years now and contains a lot of legacy data. I would like to start to use the CMDB again but dealing with all the old data will be a little bit complicated. Does anyone know if it is possible to purge the CMDB to start from scratch? Thanks JB
SDP 10013 - Problem with restore db
Hi. I have the problem. I need to move servicedesk DB to another MS SQL server and the problme is when I'm trying to restore db steps 1. Back up your application. 2. Create a new database using /changeDBServer.bat. 3. Start and stop the application once. 4. Restore your application into the new database. But during resrtore whe windows disapire after few sec. And I can't back to old server error occured OPEN_MASTER_KEY_FAILED I can't find any log files. so I can't check error why i can't restore
Field clearing is a resource.
Hi there. If I add an asset connection to users (requester), then when he creates an order, the asset is automatically added to the appropriate field - the resource. Is it possible to create a rule so that when creating an application the field - resources are cleared?
Auto populate Asset Info
I'm building several templates within ServiceDesk/ServiceCatalog. These will center around our Employee's moving from one physical location to another or to another Department altogether. Is there a Field & Form Rule I can create that will auto-populate the Asset field with the users assets? We will be using the On-Behalf-Of field for these forms since the submitters will almost always be the same group of people. We're on build 10508 and in an MSSQL environment.
How to incrementally backup AD objects using ADManager Plus?
Incremental backup is the process of backing up only the changes made since the last backup. In Active Directory, it is backing up only those objects whose attributes have been modified since the previous backup. Why should you perform incremental backups? Reduces usage of storage space. Faster to perform than full backups. Minimizes resource utilization. Incrementally backing up AD objects using native tools is not possible as they do not support incremental backups. ADManager Plus - the all-in-one
Migrating to sql failed login
Hello, I'm installing ServiceDesk Enterprise to a customer site. I try to migrate from postgres to SQL but when i testing it the connection failed with "login failed" error I tested the username password and it works, it is the same that i used to migrate desktop Central yesterday and it work (same SQL Istances, different DB name). I see that request a MasterKey password what is that?
Restrict a service category to specific group(s) of requesters
Is there a way to specify which groups of requester can see a specific service category? For example, I have a service category that is relevant only to the HR department. I selected the HR group from the Department list in the service category properties, but it is still visible to other users.
Unable to run reIndexData.bat
After migrating from Postgre to MSSQL database we've had issues with the search results. We've since upgraded to ServiceDesk Plus 10.5 Build 10504 running on Windows Server 2016. Our MSSQL database runs on a separate server. The following command has been run from an administrator elevated CMD window: I've gone to reindex the database with: C:\ManageEngine\ServiceDesk\bin\reIndexData.bat Allmodule but I get the following error: ******************************************************* * SEVERE : Server
[SD-78981] Search Not Working on SDP 10.5 Build 10500
I recently upgraded to Build 10500 and noticing search is not returning all results. I tried re-indexing using reIndexData.bat AllModule > 1.txt and it's not working. Here is the content of 1.txt file. Exception while checking server status.Connection refused: connect stopping DB Server >>>>> false I have setup up brand new server and it's also behaving the exactly same way. If anyone can point me to the right direction that would be great help. Thanks!
Views in Solutions
Hi there, did not find any info about this "issue" here. Just noticed that the counts on views in the solutions are all 0, even when someone viewed a solution. Seems to be since April 2018. Can someone explain this? Thanks Florian
[SD-80226] SECURITY Failure: https://Your_SDP_Server/workorder/RequesterDialog.jsp?woID=XXXXXX
Hello, A log-in user can grab all the requesters details registered on the portal either they are in the same dapartment or in other companies!!!!! using the url: https://Your_SDP_Server/workorder/RequesterDialog.jsp?woID=XXXXXX An iteration on the ID allow the user to collect VERY SENSITIVE data! We urge you to fix it asap. Regards, Vincent
High Disk Space Usage - Agent Logs
Hi All, I've been looking at disk usage by the ManageEngine agent, and found the log directory is between 300 and 700MB on most of my machines. Is there a way to clean these logs up? Thanks!
( SD-72081 ) Survey issue
Hello, Have customized my survey in spanish language and trying to change "Attend Survey" to spanish but I am not able to do it. Could you please help me out?. Attached you can see my problem. Thanks in advance.
IT analytics in 90 seconds: Leveraging asset change history to prepare for audits
Monitor every aspect of asset changes to ensure compliance during audits using Analytics Plus reports. If you're not already using Analytics Plus, download your free 30-day trial today.
IT analytics in 90 seconds: Leveraging asset change history to prepare for audits
Monitor every aspect of asset changes to ensure compliance during audits using Analytics Plus reports. If you're not already using Analytics Plus, download your free 30-day trial today.
Windows 10 64 - Freezes on Display Settings Screen
Reasons TO and NOT TO Buy Cheap Vacuum Cleaners How much money you should spend on vacuum cleaners is always a difficult question. You will see both premium and cheap models in the stores right now. They all seem popular and all the stores have the Best
share domain accounts for rdp login
Hi, im trying to puzzle my way through this requirement. I need to restrict domain admin access as part of tightening my firms security posture. So its a requirement now for admins to login to PMP with their domain user account and then use their shared domain admin account to remote connect to a server. Can someone suggest how i can accomplish this? I figure I need to share the DA account as a resource but i also need ot be able to hide the DA password from the administrator.
Cannot Customize Service Catalog
Hello, We just updated to the new requester page and noticed that when a requester clicks create an issue, the catalog page is blank - all it shows is ungrouped templates. When I go into the Settings > Templates & Forms, I have no option to edit the Service Categories (following instructions from here: https://help.sdpondemand.com/service-catalog). Does anyone have any suggestions? Below is a screenshot of what we see on the requestor side, and the admin/settings side. Thanks, Nick Requestor side:
Views
How can we remove some of the default views in Service Desk? I have attached an image of the views i want to remove. We have created views for our technicians and don't want all these default views cluttering up the interface.
How to select CAB for change management based on Change template
I need a script to select CAB based on change template :) Regards.
Ticket Pop-up Message
Hi, For some of my software or hardware tickets i would like to have a pop-up message to the users that the software or hardware will require approval and require a business case. I saw something to this effect in a video, but it didn't go into any description of what needs to be done to get it to work. Is there an action script i can enter in the "on form load" event that will pop up a note for the user? Thanks.
Next Page