{"id":1642,"date":"2020-03-10T04:54:33","date_gmt":"2020-03-10T04:54:33","guid":{"rendered":"https:\/\/support.mpsoftwarecmms.com\/?page_id=1642"},"modified":"2023-11-18T19:14:59","modified_gmt":"2023-11-19T01:14:59","slug":"administracion-consulta-impresion-actualizacion-y-seguimiento-de-ordenes-de-trabajo","status":"publish","type":"page","link":"https:\/\/support.mpsoftwarecmms.com\/en_us\/administracion-consulta-impresion-actualizacion-y-seguimiento-de-ordenes-de-trabajo\/","title":{"rendered":"Management, query, print, update, and track work orders"},"content":{"rendered":"
<\/div><\/div>
<\/div><\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t\t
\n\t\t\t\t\r\n
\r\n\t
\r\n\t\t

Home<\/a> \/ Maintenance management<\/a><\/p>\n

Management, query, print, update, and track work orders<\/strong><\/h2>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

Index<\/strong>
\n<\/a><\/h4>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

Introduction to management, control and tracking of work orders<\/a>
\nState or cycle of a work order<\/a>
\nUpdate OT<\/a>
\nMark OT list to close<\/a>
\nClose OT<\/a>
\nAlert OTs expired<\/a>
\nCancel a work order<\/a>
\nPrint work order<\/a><\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

<\/div><\/div>\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n\n\t
\n\t\t
<\/span><\/span><\/span><\/span><\/span>
<\/div><\/div>\n\t\t\t
\n\t\t\t\t
<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t\r\n
\r\n\t
\r\n\t\t

Related topics<\/strong><\/h4>\n

\u25b8 Basic concepts on the generation of a work order (WO)<\/a>
\n\u25b8 Period of the OT (work order)<\/a>
\n\u25b8 Generate OTs from the module Jobs waiting to give you a work Order<\/a>
\n\u25b8 Select jobs and generate OT (work order)<\/a>
\n\u25b8 Advance or postpone activities<\/a>
\n\u25b8 Calculation of the duration of the work, assignment of responsible and distribution of work loads<\/a>
\n\u25b8 Generate OTs from the module Maintenance routine next<\/a>
\n\u25b8 Record routine activities to be carried out without OT<\/a>
\n\u25b8 Generate OTs from the module non-routine Work<\/a>
\n\u25b8 Register non-routine work carried out without OT<\/a>
\n\u25b8 Generate OTs from the module teams and locations<\/a>
\n\u25b8 Teams and locations outside of service<\/a>
\n\u25b8 Assign responsible to a work order<\/a><\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t

<\/div><\/div>
<\/div><\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t\t
\n\t\t\t\t\r\n
\r\n\t
\r\n\t\t

Introduction to management, control and tracking of work orders<\/strong><\/h4>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

Once\u00a0generated work orders<\/a>the administration, query, update, and track work orders generated is carried out in the module\u00a0<\/a>Work orders.<\/strong><\/p>\n

At the time\u00a0generate a work order<\/a>, the system assigns a folio number in a row for each work order is generated and concentrated in the module <\/a>Work orders<\/strong>so that in this module the user can view, print, update, cancel, and close work orders generated.<\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t
<\/div><\/div>
\r\n
\r\n
\r\n
\r\n \"\"\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>
<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t
<\/div><\/div>
\r\n
\r\n
\r\n
\r\n \"\"\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

WORK ORDERS<\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

When you enter the module, a list of all work orders generated and when you select one of them, in the bottom pane shows the detail of the activities that make up the work order is selected, and the dates for its realization. In the\u00a0panel information<\/span>\u00a0you can check more details of the OT selected.<\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

<\/div><\/div>
<\/span><\/span>

Use the tool to sort and filter to easily locate the work order you want to view, print, update, cancel, dial list to close or close.<\/h4><\/span><\/span>\n<\/div>
<\/div><\/div>
<\/span><\/span>

Use the tool to filter OTs to limit the query of the work orders for state-of-the OT (open, closed, cancelled) or responsible.<\/h4><\/span><\/span>\n<\/div>\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t
<\/div><\/div>
<\/div><\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t\t
\n\t\t\t\t\r\n
\r\n\t
\r\n\t\t

State or cycle of a work order<\/strong><\/h4>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t
<\/div><\/div>
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>
<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t
<\/div><\/div>
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

At the time of\u00a0generate a work order<\/a>, your status appears as the work order is open. A work order open is a OT waiting to be served by the maintenance staff.<\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t

<\/div><\/div>
<\/div><\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t\t
\n\t\t\t\t\r\n
\r\n\t
\r\n\t\t

Update OT<\/strong><\/h4>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n\r\n
\r\n\t
\r\n\t\t

According to performed physically the work contained in a work order, the maintenance manager should provide feedback on the system the progress of the OT, indicating or checking the work carried out. This process we call on the MP\u00a0<\/a>Update OT.<\/strong><\/p>\n

To update the work done, select the work order, and then press the tool\u00a0<\/a>Update OT<\/strong>. Immediately a window opens showing the activities contained in the work order.<\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

<\/div><\/div>
<\/span><\/span>

Mark with the pointer of the mouse to the dates when they performed each of the activities.<\/h4><\/span><\/span>\n<\/div>
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

For a better visual control, a column of the mesh of the module shows the progress or percentage taken for each OT.<\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t
<\/div><\/div>
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>
<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t
<\/div><\/div>
\r\n
\r\n
\r\n
\r\n \r\n \"\"\r\n <\/a>\r\n <\/div>\r\n <\/div>\r\n <\/div>\r\n <\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

UPDATE WORK ORDERS<\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

When updating a work order, the system allows to register measurements, include pictures of how it was in the computer before and after you conducted the work, record readings and record consumption of spare parts and external services.<\/p>\n

In the event that the\u00a0maintenance work requires it to take a measurement<\/a>, the system will automatically display a window for you to enter the measurement taken.<\/p>\n

When you update the order of a work is not routine in addition, you can include the procedure performed, the cause of the failure, images, and add the activities of routine maintenance that is performed as a result of a repair determined.<\/p>\n

A column of the mesh of the module shows in graphically the progress or progress percentage for each OT.<\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

<\/div><\/div>\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t
<\/div><\/div>
<\/div><\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t\t
\n\t\t\t\t\r\n
\r\n\t
\r\n\t\t

Mark OT list to close<\/strong><\/h4>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n\r\n
\r\n\t
\r\n\t\t

When you upgrade an OT and indicates that all the jobs contained in the OT were carried out, the system automatically marks the OT as a work order list to close, every time that there is more to work on it.<\/p>\n

However, in practice, it is common that for various reasons it is not possible physically performing the entirety of the work contained in the OT. In these cases, it is only updated or mark the work that physically it was possible to perform and manually mark the OT as a list to close, indicating that no work is more in the OT.<\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

<\/div><\/div>
<\/span><\/span>

Before you close an OT, it should be marked that the OT is "Ready to close".<\/h4><\/span><\/span>\n<\/div>
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

Use the tool to Mark OT list to close located in the toolbar or in the submenu of the module to manually mark several OTs selected as ready-to-close.<\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

<\/div><\/div>\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t
<\/div><\/div>
<\/div><\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t\t
\n\t\t\t\t\r\n
\r\n\t
\r\n\t\t

Close OT<\/strong><\/h4>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n\r\n
\r\n\t
\r\n\t\t

To overcome the\u00a0period of the OT<\/a>it should be closed, regardless of whether they were completed or not the jobs contained in it.<\/p>\n

At the close of the OT, the work performed routine to be re-programmed automatically according to your maintenance plan and the jobs that have not been made, re-appear in the list of pending jobs to give you an OT, so that you can\u00a0generate a new OT <\/a>containing the work that for some reason it was not possible to perform in the\u00a0period<\/a>.<\/p>\n

In a column of the mesh module\u00a0<\/a>Work orders<\/strong>\u00a0shows the work orders that have expired.<\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

<\/div><\/div>
<\/span><\/span>

Use the filter tool to select the work orders are due and ready to close.<\/h4><\/span><\/span>\n<\/div>
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

Select an OT, and then press the tool <\/a>Close OT the day<\/strong>\u00a0on the toolbar to close it.<\/p>\n

Close multiple work orders at the same time, select them and display the sub-menu of the module. Use the action\u00a0<\/a>Close to the day of today<\/strong>\u00a0from the submenu.<\/p>\n

In the event that the administrator wants to document observations regarding closed work orders without having completed the work, you can do it with the tool\u00a0<\/a>comments<\/strong>thus leaving a record of the reason for such a situation.<\/p>\n

All closed work orders are available for consultation. Use the options\u00a0filter<\/span>\u00a0to display the work orders of a\u00a0period\u00a0<\/a>determined.<\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

<\/div><\/div>\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t
<\/div><\/div>
<\/div><\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t\t
\n\t\t\t\t\r\n
\r\n\t
\r\n\t\t

Alert OTs expired<\/strong><\/h4>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n\r\n
\r\n\t
\r\n\t\t

In the module\u00a0<\/a>Alerts<\/strong>presents the work orders past due that have exceeded the tolerance in days to update them and close them. In settings the user sets the tolerance according to your own criteria.<\/p>\n

In the module\u00a0<\/a>Alerts<\/strong>the user will be able to mark these orders as ready-to-close and close, so as not to be carrying OTs overdue for far too long.<\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

<\/div><\/div>\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t
<\/div><\/div>
<\/div><\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t\t
\n\t\t\t\t\r\n
\r\n\t
\r\n\t\t

Cancel a work order<\/strong><\/h4>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n\r\n
\r\n\t
\r\n\t\t

To cancel a work order is generated, select it and press the tool\u00a0<\/a>Cancel OT.<\/strong><\/p>\n

At the time you cancel a work order, the system enables you to document observations regarding the reason for cancellation.<\/p>\n

Not be able to cancel the work orders that were already up to date, that is to say, when some of the activities that make up the order is already marked as completed in such a way that once work started on the work order, you must shut down in order to finish working with it.<\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

<\/div><\/div>\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t
<\/div><\/div>
<\/div><\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t\t
\n\t\t\t\t\r\n
\r\n\t
\r\n\t\t

Print work order<\/strong><\/h4>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n\r\n
\r\n\t
\r\n\t\t

In the module\u00a0<\/a>Work orders<\/strong>\u00a0we can print work orders using the tool to print\/to print work orders selected.<\/p>\n

In settings, the user can set the print settings to the default.<\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

<\/div><\/div>\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t
<\/div><\/div>
<\/div><\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t\t
\n\t\t\t\t
<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t\r\n
\r\n\t
\r\n\t\t

Can't find the answer to your doubts or questions?<\/h1>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
<\/div><\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t
<\/div><\/div>
<\/div><\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t\t
\n\t\t\t\t
<\/div> <\/div>
\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

Additionally, we offer training courses<\/strong><\/h2>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
<\/div><\/div>\r\n
\r\n\t
\r\n\t\t

Our flexible options of online training and face-to-face will provide you with all the knowledge necessary to understand and implement your software maintenance MP.<\/span><\/p>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

<\/div><\/div>\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n\n\t
\n\t\t
<\/div><\/div>\n\t\t
\n\t\t\t
<\/div><\/div>Contact us<\/span><\/a>\r\n
\r\n\t
\r\n\t\t


\n

\r\n \r\n
\u00d7<\/span>
\r\n \r\n

Consideration if you are going to use the engine for Firebird database<\/strong><\/h4>\r\n\t\t\t

\r\n

However, the excellent performance that this database engine provides, it is important to take into account that this database engine is only recommended for users that do NOT want to use the mobile applications MPsolicitudes or MPmobile, because these APPs ARE NOT COMPATIBLE WITH THE ENGINE FIREBIRD DATABASES.<\/p>\r\n \r\n <\/div>\r\n<\/div>
\n

\r\n \r\n
\u00d7<\/span>
\r\n \r\n

Name of the database and its location.<\/strong><\/h4>\r\n\t\t\t

\r\n

Regarding the name of the database: The name that you define can't wear white space, and the number of characters allowed maximum is 25, for example Maintenance Plant 1 instead use Hyphens or underscores this: Mantenimiento_Planta_1, in addition to it is not allowed that the name of your database-carry special characters such as these: \u00a1 " # , $ % & ( \u00bf ) ? } { The reason for this is that there are some rules or policies that the database engines prohibit the use of these characters.<\/p>\r\n\t\t\t\t\t\r\n\t\t\t

You'll have another field of up to 50 characters that will allow a broader description and complete database.<\/p>\r\n\t\t\t

Example:<\/p>\r\n\t\t\t\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Name of the database<\/strong><\/td>\r\nName of the access to the database<\/strong><\/td>\r\nLong description of the database<\/strong><\/td>\r\n<\/tr>\r\n
PLANTA_SPEREN_1<\/td>\r\nACCESS TO PLANTA_SPEREN_1<\/td>\r\nPLANT SPEREN PARQUE INDUSTRIAL EXPORTEC II<\/td>\r\n<\/tr>\r\n
PLANTA_SPEREN_2<\/td>\r\nACCESS TO PLANTA_SPEREN_2<\/td>\r\nPLANT SPEREN PARQUE INDUSTRIAL HUEHUETOCA<\/td>\r\n<\/tr>\r\n
PLANTA_SPEREN_3<\/td>\r\nACCESS TO PLANTA_SPEREN_3<\/td>\r\nPLANT SPEREN INDUSTRIAL PARK JILOTEPEC<\/td>\r\n<\/tr>\r\n
HOTEL_Mara_A<\/td>\r\nACCESS TO HOTEL_Mara_A<\/td>\r\nHotel All Inclusive Mara Place, Cancun, QR<\/td>\r\n<\/tr>\r\n
HOTEL_Mara_B<\/td>\r\nACCESS TO HOTEL_Mara_B<\/td>\r\nGran Executive Hotel Mara Place mexico City, Mexico<\/td>\r\n<\/tr>\r\n
HOSPITAL_TRAUMATOLOGIA<\/td>\r\nACCESS TO HOSPITAL_TRAUMATOLOGIA<\/td>\r\nHospital of Traumatology Loma Verdes, Naucalpan<\/td>\r\n<\/tr>\r\n
HOSPITAL_NEUROLOGIA<\/td>\r\nACCESS TO HOSPITAL_NEUROLOGIA<\/td>\r\nNational institute of Neurology and Neurosurgery, CDMX<\/td>\r\n<\/tr>\r\n
FLOTILLA_1<\/td>\r\nACCESS TO FLOTILLA_1<\/td>\r\nFleet Cars and trucks SPEREN EXPORTEC II<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n\t\t\t

After you've created your databases in the MP, these are hosted on the Database Server that you've chosen. For example, the databases created by the streamlined staying in your computer, the path in which you can find is C:\\Windows\\SysWow64 or C:\\Windows\\System32. Regularly are Files with the Extension.FDB<\/p>\r\n\t\t\t

The databases created in the following types of databases: MariaDB, MySQL, SQL-Server, MPcloud and Oracle does not generate Files. The information is stored in multiple tables of schema information, or in special environments of your server.<\/p>\r\n\t\t\t

Regardless of the type of database Server that you manage, we recommend to make backups of your information frequently so that you get a receipt of your information as a preventive measure in case of an emergency, see the section Backup and restore a database.<\/p>\r\n \r\n <\/div>\r\n<\/div>
\n

\r\n \r\n
\u00d7<\/span>
\r\n \r\n\t\t

Server IP, user name and password of the database engine<\/strong><\/h3>\r\n\t\t

\r\n\r\n

Today, virtually all companies have at least one IT professional who is responsible for, among many other functions to manage the data and servers of the company. Among their functions include the administration of a database engine, which, for security reasons, has access by means of a user name and a password. If not, any person could enter the network, and provide high-databases, query, modify and even delete confidential information of the company.<\/p>\r\n\r\n

For example:<\/p>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
DATABASE ENGINE<\/strong><\/td>\r\nADMINISTRATOR USER BY DEFAULT<\/strong><\/td>\r\nPASSWORD\r\n<\/strong>(Known only to the manager of IT)<\/strong><\/td>\r\n<\/tr>\r\n
MySQL<\/td>\r\nroot<\/td>\r\n******<\/td>\r\n<\/tr>\r\n
Microsoft SQL-Server<\/td>\r\nsa<\/td>\r\n******<\/td>\r\n<\/tr>\r\n
Oracle<\/td>\r\nSystem<\/td>\r\n******<\/td>\r\n<\/tr>\r\n
MariaDB<\/td>\r\nroot<\/td>\r\n******<\/td>\r\n<\/tr>\r\n
Firebird<\/td>\r\nSYSDBA<\/td>\r\n******<\/td>\r\n<\/tr>\r\n<\/table>\r\n

When you create a database, or a new connection on the MP, the program prompts you for the server name or IP where you will create or is the database to which you want to connect to, as well as a user name and password.<\/p>\r\n

The username and password that here we ask, are precisely those that allow access to the <\/em>database engine <\/em>permissions privileges to create the database. <\/em><\/h4>\r\n

\r\n\t\t\t\r\n

\r\n

Now, the administrator of the database can also create different user accounts to allow access to more people by giving them privileges and permissions custom.<\/p>\r\n\r\n

With the aim of not to use the administrator user of IT and its respective password each time that the department of maintenance required to create a database or a connection to an existing database, it is recommended that the IT administrator create a user account specifically for the maintenance department.<\/em><\/h4>\r\n

A single user account to the database engine is sufficient for the creation and connection of multiple databases.<\/p>\r\n\r\n

The username and password that here is requested, you do not have any relationship with the licenses of use are acquired or the amount of users that can access the database, so that a single user account can be enough, because in this case it refers specifically to the user and password of the database engine.<\/p>\r\n\t\t \r\n <\/div>\r\n<\/div>
\n

\r\n \r\n
\u00d7<\/span>
\r\n \r\n\t\t

What is a access to the database?<\/strong><\/h3>\r\n\t\t

\r\n\r\n

When you create a database, it automatically creates an access to the database. Access is a file that contains encoded all information regarding the IP address or name of the server where the database resides. This information is also recorded in a QR code, which will facilitate the connection of mobile devices to the database.<\/p>\r\n\t\t \r\n <\/div>\r\n<\/div>\n\t<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n\n\t\t<\/div> \n\t<\/div>\n\t<\/div> \n<\/div><\/div>\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n<\/div><\/div>","protected":false},"excerpt":{"rendered":"Inicio \/ Gesti\u00f3n de mantenimiento Administraci\u00f3n, consulta, impresi\u00f3n, actualizaci\u00f3n y seguimiento de \u00f3rdenes de trabajo...","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/support.mpsoftwarecmms.com\/en_us\/wp-json\/wp\/v2\/pages\/1642"}],"collection":[{"href":"https:\/\/support.mpsoftwarecmms.com\/en_us\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/support.mpsoftwarecmms.com\/en_us\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/support.mpsoftwarecmms.com\/en_us\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/support.mpsoftwarecmms.com\/en_us\/wp-json\/wp\/v2\/comments?post=1642"}],"version-history":[{"count":22,"href":"https:\/\/support.mpsoftwarecmms.com\/en_us\/wp-json\/wp\/v2\/pages\/1642\/revisions"}],"predecessor-version":[{"id":7176,"href":"https:\/\/support.mpsoftwarecmms.com\/en_us\/wp-json\/wp\/v2\/pages\/1642\/revisions\/7176"}],"wp:attachment":[{"href":"https:\/\/support.mpsoftwarecmms.com\/en_us\/wp-json\/wp\/v2\/media?parent=1642"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}