{"id":130,"date":"2021-03-21T08:33:45","date_gmt":"2021-03-21T07:33:45","guid":{"rendered":"http:\/\/www.netexpertise.eu\/es\/?p=130"},"modified":"2021-03-21T08:33:47","modified_gmt":"2021-03-21T07:33:47","slug":"asignacion-automatica-del-grupo-de-usuarios-al-ticket-glpi","status":"publish","type":"post","link":"http:\/\/www.netexpertise.eu\/es\/diverso\/glpi\/asignacion-automatica-del-grupo-de-usuarios-al-ticket-glpi.html","title":{"rendered":"Asignaci\u00f3n autom\u00e1tica del grupo de usuarios al ticket GLPI"},"content":{"rendered":"\n<p>En <a href=\"http:\/\/www.glpi-project.org\/spip.php?lang=fr\">GLPI<\/a>, el solicitante debe seleccionar expl\u00edcitamente su grupo; de lo contrario, el campo se deja vac\u00edo.Este procedimiento almacenado asigna autom\u00e1ticamente el grupo del solicitante al ticket. Un trabajo cron permitir\u00e1 que se inicie a intervalos regulares.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">begin\nupdate base_de_datos_GLPI.glpi_tracking t\nset t.fk_group= (\nSELECT g.id\n   FROM base_de_datos_GLPI.glpi_users u,\n        base_de_datos_GLPI.glpi_groups g,\n        base_de_datos_GLPI.glpi_users_groups ug\n   WHERE u.id = ug.fk_users\n   AND g.id = ug.fk_groups\n   AND u.id=t.author\n   LIMIT 0 , 1)\nwhere t.fk_group is null or t.fk_group='' or t.FK_group=0;\nend<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>En GLPI, el solicitante debe seleccionar expl\u00edcitamente su grupo; de lo contrario, el campo se deja vac\u00edo.Este procedimiento almacenado asigna autom\u00e1ticamente el grupo del solicitante al ticket. Un trabajo cron permitir\u00e1 que se inicie a intervalos regulares.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[42],"tags":[43,44,45],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.13 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Netexpertise - Asignaci\u00f3n autom\u00e1tica del grupo de usuarios al ticket GLPI<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.netexpertise.eu\/es\/diverso\/glpi\/asignacion-automatica-del-grupo-de-usuarios-al-ticket-glpi.html\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Netexpertise - Asignaci\u00f3n autom\u00e1tica del grupo de usuarios al ticket GLPI\" \/>\n<meta property=\"og:description\" content=\"En GLPI, el solicitante debe seleccionar expl\u00edcitamente su grupo; de lo contrario, el campo se deja vac\u00edo.Este procedimiento almacenado asigna autom\u00e1ticamente el grupo del solicitante al ticket. Un trabajo cron permitir\u00e1 que se inicie a intervalos regulares.\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.netexpertise.eu\/es\/diverso\/glpi\/asignacion-automatica-del-grupo-de-usuarios-al-ticket-glpi.html\" \/>\n<meta property=\"og:site_name\" content=\"Netexpertise\" \/>\n<meta property=\"article:published_time\" content=\"2021-03-21T07:33:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-03-21T07:33:47+00:00\" \/>\n<meta name=\"author\" content=\"dave\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@netexpertise\" \/>\n<meta name=\"twitter:site\" content=\"@netexpertise\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/www.netexpertise.eu\/es\/diverso\/glpi\/asignacion-automatica-del-grupo-de-usuarios-al-ticket-glpi.html\",\"url\":\"http:\/\/www.netexpertise.eu\/es\/diverso\/glpi\/asignacion-automatica-del-grupo-de-usuarios-al-ticket-glpi.html\",\"name\":\"Netexpertise - Asignaci\u00f3n autom\u00e1tica del grupo de usuarios al ticket GLPI\",\"isPartOf\":{\"@id\":\"http:\/\/www.netexpertise.eu\/es\/#website\"},\"datePublished\":\"2021-03-21T07:33:45+00:00\",\"dateModified\":\"2021-03-21T07:33:47+00:00\",\"author\":{\"@id\":\"http:\/\/www.netexpertise.eu\/es\/#\/schema\/person\/27ec923be6625ac4b4bb86c8f0b12abf\"},\"breadcrumb\":{\"@id\":\"http:\/\/www.netexpertise.eu\/es\/diverso\/glpi\/asignacion-automatica-del-grupo-de-usuarios-al-ticket-glpi.html#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/www.netexpertise.eu\/es\/diverso\/glpi\/asignacion-automatica-del-grupo-de-usuarios-al-ticket-glpi.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/www.netexpertise.eu\/es\/diverso\/glpi\/asignacion-automatica-del-grupo-de-usuarios-al-ticket-glpi.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"http:\/\/www.netexpertise.eu\/es\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Asignaci\u00f3n autom\u00e1tica del grupo de usuarios al ticket GLPI\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/www.netexpertise.eu\/es\/#website\",\"url\":\"http:\/\/www.netexpertise.eu\/es\/\",\"name\":\"Netexpertise\",\"description\":\"Sistemas \/ Redes \/ DevOps\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/www.netexpertise.eu\/es\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"http:\/\/www.netexpertise.eu\/es\/#\/schema\/person\/27ec923be6625ac4b4bb86c8f0b12abf\",\"name\":\"dave\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"http:\/\/www.netexpertise.eu\/es\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/1.gravatar.com\/avatar\/1129916e1f4955bd632f27f836f64e55?s=96&d=mm&r=g\",\"contentUrl\":\"http:\/\/1.gravatar.com\/avatar\/1129916e1f4955bd632f27f836f64e55?s=96&d=mm&r=g\",\"caption\":\"dave\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Netexpertise - Asignaci\u00f3n autom\u00e1tica del grupo de usuarios al ticket GLPI","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/www.netexpertise.eu\/es\/diverso\/glpi\/asignacion-automatica-del-grupo-de-usuarios-al-ticket-glpi.html","og_locale":"es_ES","og_type":"article","og_title":"Netexpertise - Asignaci\u00f3n autom\u00e1tica del grupo de usuarios al ticket GLPI","og_description":"En GLPI, el solicitante debe seleccionar expl\u00edcitamente su grupo; de lo contrario, el campo se deja vac\u00edo.Este procedimiento almacenado asigna autom\u00e1ticamente el grupo del solicitante al ticket. Un trabajo cron permitir\u00e1 que se inicie a intervalos regulares.","og_url":"http:\/\/www.netexpertise.eu\/es\/diverso\/glpi\/asignacion-automatica-del-grupo-de-usuarios-al-ticket-glpi.html","og_site_name":"Netexpertise","article_published_time":"2021-03-21T07:33:45+00:00","article_modified_time":"2021-03-21T07:33:47+00:00","author":"dave","twitter_card":"summary_large_image","twitter_creator":"@netexpertise","twitter_site":"@netexpertise","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/www.netexpertise.eu\/es\/diverso\/glpi\/asignacion-automatica-del-grupo-de-usuarios-al-ticket-glpi.html","url":"http:\/\/www.netexpertise.eu\/es\/diverso\/glpi\/asignacion-automatica-del-grupo-de-usuarios-al-ticket-glpi.html","name":"Netexpertise - Asignaci\u00f3n autom\u00e1tica del grupo de usuarios al ticket GLPI","isPartOf":{"@id":"http:\/\/www.netexpertise.eu\/es\/#website"},"datePublished":"2021-03-21T07:33:45+00:00","dateModified":"2021-03-21T07:33:47+00:00","author":{"@id":"http:\/\/www.netexpertise.eu\/es\/#\/schema\/person\/27ec923be6625ac4b4bb86c8f0b12abf"},"breadcrumb":{"@id":"http:\/\/www.netexpertise.eu\/es\/diverso\/glpi\/asignacion-automatica-del-grupo-de-usuarios-al-ticket-glpi.html#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.netexpertise.eu\/es\/diverso\/glpi\/asignacion-automatica-del-grupo-de-usuarios-al-ticket-glpi.html"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/www.netexpertise.eu\/es\/diverso\/glpi\/asignacion-automatica-del-grupo-de-usuarios-al-ticket-glpi.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"http:\/\/www.netexpertise.eu\/es"},{"@type":"ListItem","position":2,"name":"Asignaci\u00f3n autom\u00e1tica del grupo de usuarios al ticket GLPI"}]},{"@type":"WebSite","@id":"http:\/\/www.netexpertise.eu\/es\/#website","url":"http:\/\/www.netexpertise.eu\/es\/","name":"Netexpertise","description":"Sistemas \/ Redes \/ DevOps","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/www.netexpertise.eu\/es\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"es"},{"@type":"Person","@id":"http:\/\/www.netexpertise.eu\/es\/#\/schema\/person\/27ec923be6625ac4b4bb86c8f0b12abf","name":"dave","image":{"@type":"ImageObject","inLanguage":"es","@id":"http:\/\/www.netexpertise.eu\/es\/#\/schema\/person\/image\/","url":"http:\/\/1.gravatar.com\/avatar\/1129916e1f4955bd632f27f836f64e55?s=96&d=mm&r=g","contentUrl":"http:\/\/1.gravatar.com\/avatar\/1129916e1f4955bd632f27f836f64e55?s=96&d=mm&r=g","caption":"dave"}}]}},"_links":{"self":[{"href":"http:\/\/www.netexpertise.eu\/es\/wp-json\/wp\/v2\/posts\/130"}],"collection":[{"href":"http:\/\/www.netexpertise.eu\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.netexpertise.eu\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.netexpertise.eu\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.netexpertise.eu\/es\/wp-json\/wp\/v2\/comments?post=130"}],"version-history":[{"count":2,"href":"http:\/\/www.netexpertise.eu\/es\/wp-json\/wp\/v2\/posts\/130\/revisions"}],"predecessor-version":[{"id":132,"href":"http:\/\/www.netexpertise.eu\/es\/wp-json\/wp\/v2\/posts\/130\/revisions\/132"}],"wp:attachment":[{"href":"http:\/\/www.netexpertise.eu\/es\/wp-json\/wp\/v2\/media?parent=130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.netexpertise.eu\/es\/wp-json\/wp\/v2\/categories?post=130"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.netexpertise.eu\/es\/wp-json\/wp\/v2\/tags?post=130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}