You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2013-08-26 22:05:23

joao.deon
Guest
Registered: 2013-08-26
Posts: 6

Possible bug in the software category

Dear gentlemen, good afternoon!

I'm living with a problem in the new version of GLPI and believe you can help me.

1 - I am creating a category of software to be able to better indentificar my inventory software, however for software already imported by OCS when I use the action "recalculate category" which serves to apply the criteria of category software already imported, however the it returns me the "operation failed".

2 - Gosgaria wonder if there is a way to control the tags of computers imported from OCS so automatically. Or another way to automatically control ID.

I hope you help me.

Offline

#2 2013-08-26 23:00:15

joao.deon
Guest
Registered: 2013-08-26
Posts: 6

Re: Possible bug in the software category

Correcting

2 - I wonder if there is a way to control the tags of computers imported from OCS so automatically. Or another way to automatically control ID.

Offline

#3 2013-08-27 07:53:06

MoYo
GLPI - Lead
From: Poitiers
Registered: 2004-09-13
Posts: 14,513
Website

Re: Possible bug in the software category

1 - have you rules to apply category ?
2 - I do not understand


MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI :    Support     Contribute     References     Freshmeat

Offline

#4 2013-08-27 14:59:18

joao.deon
Guest
Registered: 2013-08-26
Posts: 6

Re: Possible bug in the software category

Good Morning Moyo,

1- Yes I have created the rules, but when I perform the action "recalculate the category" the operation fails. I'll explain, I created a rule that categorizes a type of software, by the time I apply the rule to computers that have been imported from OCS, it pop's an error: "Operation Failed", however for new computers imported it applies normally.

2 - You can disregard it

Offline

#5 2013-08-27 15:03:47

MoYo
GLPI - Lead
From: Poitiers
Registered: 2004-09-13
Posts: 14,513
Website

Re: Possible bug in the software category

1 - in mode debug do you have errors ? and errors in log files ?


MoYo - Julien Dombre - Association INDEPNET
Contribute to GLPI :    Support     Contribute     References     Freshmeat

Offline

#6 2013-08-27 15:24:15

joao.deon
Guest
Registered: 2013-08-26
Posts: 6

Re: Possible bug in the software category

Moyo, see below What do Debug mode and logs reported, I believe that is free of errors.

__________________________________________________________________________________________________

Debug

SQL REQUEST : 26 Queries took 0.003s
N°    Queries    Time    Errors
1    SELECT `glpi_users`.*
FROM `glpi_users`
WHERE `glpi_users`.`id` = '2' LIMIT 1    0.000    
2    SELECT DISTINCT `entities_id`, `is_recursive`
FROM `glpi_profiles_users`
WHERE `users_id` = '2'    0.000    
3    SHOW COLUMNS
FROM `glpi_entities`    0.002    
4    SELECT `id`
FROM `glpi_entities`
WHERE `entities_id` = '0'
ORDER BY `name`    0.000    
5    SELECT COUNT(*) AS cpt
FROM `glpi_entities`    0.000    
6    SELECT DISTINCT `entities_id`, `is_recursive`
FROM `glpi_profiles_users`
WHERE `users_id` = '2'    0.000    
7    SELECT COUNT(*) AS cpt
FROM `glpi_entities`    0.000    
8    SELECT DISTINCT `entities_id`, `is_recursive`
FROM `glpi_profiles_users`
WHERE `users_id` = '2'    0.000    
9    SELECT `id`
FROM `glpi_entities`
WHERE `entities_id` = '0'
ORDER BY `name`    0.000    
10    SELECT COUNT(*) AS cpt
FROM `glpi_entities`    0.000    
11    SELECT DISTINCT `entities_id`, `is_recursive`
FROM `glpi_profiles_users`
WHERE `users_id` = '2'    0.000    
12    SELECT COUNT(*) AS cpt
FROM `glpi_entities`    0.000    
13    SELECT DISTINCT `entities_id`, `is_recursive`
FROM `glpi_profiles_users`
WHERE `users_id` = '2'    0.000    
14    SELECT `id`
FROM `glpi_entities`
WHERE `entities_id` = '0'
ORDER BY `name`    0.000    
15    SELECT COUNT(*) AS cpt
FROM `glpi_entities`    0.000    
16    SELECT DISTINCT `entities_id`, `is_recursive`
FROM `glpi_profiles_users`
WHERE `users_id` = '2'    0.000    
17    SELECT COUNT(*) AS cpt
FROM `glpi_entities`    0.000    
18    SHOW COLUMNS
FROM `glpi_useremails`    0.000    
19    SELECT *
FROM `glpi_useremails`
WHERE `users_id` = '2'    0.000    
20    SELECT DISTINCT `entities_id`, `is_recursive`
FROM `glpi_profiles_users`
WHERE `users_id` = '2'    0.000    
21    SELECT `id`
FROM `glpi_entities`
WHERE `entities_id` = '0'
ORDER BY `name`    0.000    
22    SELECT DISTINCT `entities_id`, `is_recursive`
FROM `glpi_profiles_users`
WHERE `users_id` = '2'    0.000    
23    SELECT `id`
FROM `glpi_entities`
WHERE `entities_id` = '0'
ORDER BY `name`    0.000    
24    SHOW COLUMNS
FROM `glpi_locations`    0.001    
25    SELECT *
FROM `glpi_locations`
WHERE 1 AND `glpi_locations`.`id` NOT IN ('0') AND ( `glpi_locations`.`entities_id` IN ('0') )
ORDER BY `entities_id`, `completename`    0.000    
26    SELECT *
FROM `glpi_locations`
WHERE `id` = '0'    0.000    
AUTOLOAD
PluginOcsinventoryngOcsServer, CommonITILObject, Dropdown, Bookmark, CronTask, Preference, User, Auth, CommonDBConnexity, CommonDBChild, UserEmail, CommonDBRelation, Profile_User, Log, CommonDropdown, CommonTreeDropdown, Location, Ajax
POST VARIABLE
KEY    =>    VALUE
full_page_tab    =>    full_page_tab
target    =>    /glpi-84/front/preference.php
itemtype    =>    Preference
glpi_tab    =>    User$1
id    =>    0
sort    =>   
order    =>   
withtemplate    =>   
_glpi_csrf_token    =>    6a3cedea2b899bbe24310b203b085aaa
_glpi_simple_form    =>    1
GET VARIABLE
KEY    =>    VALUE
_dc    =>    1377609593710
SESSION VARIABLE
KEY    =>    VALUE
glpi_plugins    =>   
KEY    =>    VALUE
1    =>    ocsinventoryng
glpicookietest    =>    testcookie
glpicsrftokens    =>   
KEY    =>    VALUE
3b4b9f416e6c5281191acba4a4e5b776    =>    1377616114
02023bd6f97749e082f5ffe606712625    =>    1377616135
f892059dda2506c727d0aee475c03d61    =>    1377616141
de76cfd0f98f134022e1bb203c6a8391    =>    1377616171
0e1605c6cda699415abff05107fb2291    =>    1377616176
1c7f443d846b030baebe19b72d7e6c1f    =>    1377616188
674b3c1957beffdf32961daf8967bbbf    =>    1377616189
4632dfd944d479112ba91dc2dbd0d540    =>    1377616195
5df6a3fe8a6938ded044000f9df7ff18    =>    1377616430
125939b7aa1aa338741da2c8aa59aff5    =>    1377616437
517cb25be2be1da294afc2f8bd995be8    =>    1377616438
04342a68b0a75289e61c2205a4bd5bf5    =>    1377616445
5c50ca0b34565f1096a16bc00763c6ec    =>    1377616451
4e4858a087c73acac1b58e6188556e0f    =>    1377616453
6af10f996978275bab970db1a928dbf9    =>    1377616471
aa4afc4d2ffbc39a48b0de891f1c468a    =>    1377616477
731b1f4402459d83ffc73abe148af418    =>    1377616478
7cf38df17e892562e3c9d648c2707ae6    =>    1377616479
03f4a3b423108660d8d5112a406ecefe    =>    1377616484
aad1cbaa24f08a1e097dbeefa571fa4f    =>    1377616640
ac17d391804c4f8646433739f2a01cb8    =>    1377616642
1888e698e93ce777b64c47274f2b8040    =>    1377616643
887e757309aa1c3149ea5e650ab2d805    =>    1377616653
870a5b520bb469ba392bdd04a3cb0e63    =>    1377616661
f11f1935657f742600539261829e6a71    =>    1377616665
3f45712e8f0aa892af5b8a7925c2823c    =>    1377616666
6a3cedea2b899bbe24310b203b085aaa    =>    1377616787
8aeed4e05830632761c40e082a71f78a    =>    1377616805
glpi_currenttime    =>    2013-08-27 10:20:05
glpi_use_mode    =>    2
glpi_table_of    =>   
KEY    =>    VALUE
User    =>    glpi_users
Profile    =>    glpi_profiles
PluginOcsinventoryngProfile    =>    glpi_plugin_ocsinventoryng_profiles
Config    =>    glpi_configs
ProblemTask    =>    glpi_problemtasks
Problem    =>    glpi_problems
TicketTask    =>    glpi_tickettasks
Ticket    =>    glpi_tickets
UserEmail    =>    glpi_useremails
Location    =>    glpi_locations
Event    =>    glpi_events
CronTask    =>    glpi_crontasks
CronTaskLog    =>    glpi_crontasklogs
RequestType    =>    glpi_requesttypes
SoftwareCategory    =>    glpi_softwarecategories
DocumentCategory    =>    glpi_documentcategories
Plugin    =>    glpi_plugins
glpiID    =>    2
glpiname    =>    glpi
glpirealname    =>   
glpifirstname    =>   
glpidefault_entity    =>    0
glpiusers_idisation    =>    1
glpiextauth    =>    0
glpiauthtype    =>    1
glpiroot    =>    /glpi-84
glpicrontimer    =>    1377609587
glpi_tabs    =>   
KEY    =>    VALUE
central    =>    Central$1
preference    =>    User%241
config    =>    Config$1
glpicsv_delimiter    =>    ;
glpidate_format    =>    0
glpidefault_requesttypes_id    =>    1
glpidisplay_count_on_home    =>    5
glpidropdown_chars_limit    =>    50
glpiduedatecritical_color    =>    #ff0000
glpiduedatecritical_less    =>    5
glpiduedatecritical_unit    =>    %
glpiduedateok_color    =>    #06ff00
glpiduedatewarning_color    =>    #ffb800
glpiduedatewarning_less    =>    20
glpiduedatewarning_unit    =>    %
glpifollowup_private    =>    0
glpiis_categorized_soft_expanded    =>    1
glpiis_ids_visible    =>    0
glpiis_not_categorized_soft_expanded    =>    1
glpilanguage    =>    pt_BR
glpilist_limit    =>    20
glpinames_format    =>    1
glpinotification_to_myself    =>    0
glpinumber_format    =>    0
glpipriority_1    =>    #fff2f2
glpipriority_2    =>    #ffe0e0
glpipriority_3    =>    #ffcece
glpipriority_4    =>    #ffbfbf
glpipriority_5    =>    #ffadad
glpipriority_6    =>    #ff5555
glpirefresh_ticket_list    =>    0
glpiset_default_tech    =>    1
glpishow_count_on_tabs    =>    1
glpishow_jobs_at_login    =>    0
glpitask_private    =>    0
glpiuse_flat_dropdowntree    =>    0
glpiprofiles    =>   
KEY    =>    VALUE
4    =>   
KEY    =>    VALUE
name    =>    Super-Admin
entities    =>   
KEY    =>    VALUE
0    =>   
KEY    =>    VALUE
id    =>    0
name    =>    Entité racine
is_recursive    =>    1
glpiactiveprofile    =>   
KEY    =>    VALUE
id    =>    4
name    =>    Super-Admin
interface    =>    central
is_default    =>    0
computer    =>    w
monitor    =>    w
software    =>    w
networking    =>    w
internet    =>    w
printer    =>    w
peripheral    =>    w
cartridge    =>    w
consumable    =>    w
phone    =>    w
notes    =>    w
contact_enterprise    =>    w
document    =>    w
contract    =>    w
infocom    =>    w
knowbase    =>    w
knowbase_admin    =>    1
faq    =>    w
reservation_helpdesk    =>    1
reservation_central    =>    w
reports    =>    r
dropdown    =>    w
entity_dropdown    =>    w
device    =>    w
typedoc    =>    w
link    =>    w
config    =>    w
rule_ticket    =>    r
entity_rule_ticket    =>    w
rule_import    =>    w
rule_ldap    =>    w
rule_softwarecategories    =>    w
search_config    =>    w
search_config_global    =>    w
check_update    =>    r
profile    =>    w
user    =>    w
user_authtype    =>    w
group    =>    w
entity    =>    w
transfer    =>    w
logs    =>    r
reminder_public    =>    w
rssfeed_public    =>    w
bookmark_public    =>    w
backup    =>    w
create_ticket    =>    1
delete_ticket    =>    1
add_followups    =>    1
group_add_followups    =>    1
global_add_followups    =>    1
global_add_tasks    =>    1
update_ticket    =>    1
update_priority    =>    1
own_ticket    =>    1
steal_ticket    =>    1
assign_ticket    =>    1
show_all_ticket    =>    1
show_assign_ticket    =>    1
show_full_ticket    =>    1
observe_ticket    =>    1
update_followups    =>    1
update_tasks    =>    1
show_planning    =>    1
show_group_planning    =>    1
show_all_planning    =>    1
statistic    =>    1
password_update    =>    1
helpdesk_hardware    =>    3
helpdesk_item_type    =>   
KEY    =>    VALUE
0    =>    Computer
1    =>    Monitor
2    =>    NetworkEquipment
3    =>    Peripheral
4    =>    Phone
5    =>    Printer
6    =>    Software
ticket_status    =>   
show_group_ticket    =>    0
show_group_hardware    =>    0
rule_dictionnary_software    =>    w
rule_dictionnary_dropdown    =>    w
budget    =>    w
import_externalauth_users    =>    w
notification    =>    w
rule_mailcollector    =>    w
date_mod    =>   
comment    =>   
validate_request    =>    1
create_request_validation    =>    1
calendar    =>    w
sla    =>    w
rule_dictionnary_printer    =>    w
update_own_followups    =>    1
delete_followups    =>    1
entity_helpdesk    =>    w
show_my_problem    =>    1
show_all_problem    =>    1
edit_all_problem    =>    1
problem_status    =>   
create_ticket_on_login    =>    0
tickettemplate    =>    w
ticketrecurrent    =>    w
ticketcost    =>    w
validate_incident    =>    1
create_incident_validation    =>    1
delete_validations    =>    1
tickettemplates_id    =>    0
entities    =>   
KEY    =>    VALUE
0    =>   
KEY    =>    VALUE
id    =>    0
name    =>    Entité racine
is_recursive    =>    1
glpiactiveentities    =>   
KEY    =>    VALUE
0    =>    0
glpisearch    =>   
glpisearchcount    =>   
glpisearchcount2    =>   
glpiactiveentities_string    =>    '0'
glpiparententities    =>   
glpiparententities_string    =>   
glpiactive_entity    =>    0
glpiactive_entity_recursive    =>    1
glpiactive_entity_name    =>    Entité racine (estrutura de árvore)
glpiactive_entity_shortname    =>    Entité racine (estrutura de árvore)
glpishowallentities    =>    0
glpigroups    =>   
glpi_plugin_ocsinventoryng_profile    =>   
KEY    =>    VALUE
id    =>    1
profiles_id    =>    4
ocsng    =>    w
sync_ocsng    =>    w
view_ocsng    =>    r
clean_ocsng    =>    w
rule_ocs    =>    w
MESSAGE_AFTER_REDIRECT    =>   
glpishowmigrationcleaner    =>   
glpi_multientitiesmode    =>    0
glpi_foreign_key_field_of    =>   
KEY    =>    VALUE
Problem    =>    problems_id
Ticket    =>    tickets_id
Location    =>    locations_id
RequestType    =>    requesttypes_id
SoftwareCategory    =>    softwarecategories_id
DocumentCategory    =>    documentcategories_id
glpi_maxhistory    =>    7041
glpicronuserrunning    =>   
glpi_warned_about_full_page_tab    =>    1

__________________________________________________________________________________________________

Log

User Setup 5 2 08/27/2013 10:09 glpi updated an item
System Connection 3 08/27/2013 10:08 glpi logged in IP 10.10.10.34
Computer Assets 4 24 2013-08-26 17:39 glpi updated an item
Computer Assets 4 24 2013-08-26 17:33 glpi updated an item
Computer Assets 4 23 2013-08-26 17:29 glpi updated an item
System Connection 3 08/26/2013 16:49 glpi logged in IP 20.0.0.78
System Connection 3 08/26/2013 16:42 glpi logged in IP 10.10.10.34
08/26/2013 16:41 3 System Connection Login failed for glpi the IP 20.0.0.78
Rules Setup 4 15 2013-08-26 15:57 glpi updated an item
Software category 3 4 Setup 26/08/2013 15:54 glpi added the item adobe
Rules 15 2013-08-26 15:54 glpi added 4 Setup item 15
Rules 9 4 Setup 08/26/2013 15:38 glpi updated an item
Rules 9 4 Setup 08/26/2013 15:33 glpi updated an item
System Connection 3 08/26/2013 15:23 glpi logged in IP 20.0.0.78
System Connection 3 08/26/2013 09:07 glpi logged in IP 192.168.100.88
Problem 1 23/08/2013 11:00 4 Assistance glpi added a relationship with an item
System Connection 3 23/08/2013 09:26 glpi logged in IP 10.10.10.34
System Connection 3 08/22/2013 17:55 glpi logged in IP 10.10.10.154
Ticket 23 2013-08-22 17:54 4 Tickets joao.ferreira updated an item
Ticket 23 2013-08-22 17:54 4 Tickets joao.ferreira updated an item

Offline

#7 2013-08-27 15:32:48

joao.deon
Guest
Registered: 2013-08-26
Posts: 6

Re: Possible bug in the software category

Moyo, sorry I sent the debug mode generated the wrong page. Generated in the following debug time to "recalculate the category."

____________________________________________________________________________________________________

SQL REQUEST : 9 Queries took 0.006s
N°    Queries    Time    Errors
1    SHOW COLUMNS
FROM `glpi_softwares`    0.001    
2    SELECT *
FROM `glpi_displaypreferences`
WHERE `itemtype` = 'Software' AND `users_id` = '2'
ORDER BY `rank`    0.000    
3    SELECT *
FROM `glpi_displaypreferences`
WHERE `itemtype` = 'Software' AND `users_id` = '0'
ORDER BY `rank`    0.000    
4    SELECT count(*), 'glpi' AS currentuser
FROM `glpi_softwares`
WHERE `glpi_softwares`.`is_deleted` = '0' AND `glpi_softwares`.`is_template` = '0' AND ( `glpi_softwares`.`entities_id` IN ('0') )    0.000    
5    SET SESSION group_concat_max_len = 4096;    0.000    
6    SELECT 'glpi' AS currentuser, `glpi_softwares`.`entities_id`, `glpi_softwares`.`is_recursive`, `glpi_softwares`.`name` AS ITEM_0, `glpi_softwares`.`id` AS ITEM_0_2, `glpi_manufacturers`.`name` AS ITEM_1, GROUP_CONCAT(DISTINCT CONCAT(`glpi_softwareversions`.`name`,'$$',`glpi_softwareversions`.`id`) SEPARATOR '$$$$') AS ITEM_2, GROUP_CONCAT(DISTINCT CONCAT(`glpi_operatingsystems_0a35c270152be19b5c8a485502badcd7`.`name`,'$$',`glpi_operatingsystems_0a35c270152be19b5c8a485502badcd7`.`id`) SEPARATOR '$$$$') AS ITEM_3, COUNT(DISTINCT `glpi_computers_softwareversions_f10ca49241194f17cdf5770bd87f151b`.`id`) AS ITEM_4, FLOOR(SUM(`glpi_softwarelicenses_081fb23b27a61884519aeec1bb55e891`.`number`) * COUNT(DISTINCT `glpi_softwarelicenses_081fb23b27a61884519aeec1bb55e891`.`id`) / COUNT(`glpi_softwarelicenses_081fb23b27a61884519aeec1bb55e891`.`id`)) AS ITEM_5, MIN(`glpi_softwarelicenses_081fb23b27a61884519aeec1bb55e891`.`number`) AS ITEM_5_2, `glpi_softwarecategories`.`name` AS ITEM_6, `glpi_softwares`.`id` AS id
FROM `glpi_softwares`
LEFT JOIN `glpi_manufacturers` ON (`glpi_softwares`.`manufacturers_id` = `glpi_manufacturers`.`id` )
LEFT JOIN `glpi_softwareversions` ON (`glpi_softwares`.`id` = `glpi_softwareversions`.`softwares_id` )
LEFT JOIN `glpi_operatingsystems` AS glpi_operatingsystems_0a35c270152be19b5c8a485502badcd7 ON (`glpi_softwareversions`.`operatingsystems_id` = `glpi_operatingsystems_0a35c270152be19b5c8a485502badcd7`.`id` )
LEFT JOIN `glpi_computers_softwareversions` AS glpi_computers_softwareversions_f10ca49241194f17cdf5770bd87f151b ON (`glpi_softwareversions`.`id` = `glpi_computers_softwareversions_f10ca49241194f17cdf5770bd87f151b`.`softwareversions_id` AND `glpi_computers_softwareversions_f10ca49241194f17cdf5770bd87f151b`.`is_deleted_computer` = '0' AND `glpi_computers_softwareversions_f10ca49241194f17cdf5770bd87f151b`.`is_template_computer` = '0' AND ( `glpi_computers_softwareversions_f10ca49241194f17cdf5770bd87f151b`.`entities_id` IN ('0') ) )
LEFT JOIN `glpi_softwarelicenses` AS glpi_softwarelicenses_081fb23b27a61884519aeec1bb55e891 ON (`glpi_softwares`.`id` = `glpi_softwarelicenses_081fb23b27a61884519aeec1bb55e891`.`softwares_id` AND ( `glpi_softwarelicenses_081fb23b27a61884519aeec1bb55e891`.`entities_id` IN ('0') ) AND (`glpi_softwarelicenses_081fb23b27a61884519aeec1bb55e891`.`expire` IS NULL OR `glpi_softwarelicenses_081fb23b27a61884519aeec1bb55e891`.`expire` > NOW()) )
LEFT JOIN `glpi_softwarecategories` ON (`glpi_softwares`.`softwarecategories_id` = `glpi_softwarecategories`.`id` )
WHERE `glpi_softwares`.`is_deleted` = '0' AND `glpi_softwares`.`is_template` = '0' AND ( `glpi_softwares`.`entities_id` IN ('0') ) GROUP BY `glpi_softwares`.`id`
ORDER BY ITEM_0 ASC LIMIT 0, 20    0.005    
7    SHOW WARNINGS    0.000    
8    SELECT COUNT(*) AS cpt
FROM `glpi_rules`
WHERE sub_type='RuleSoftwareCategory'    0.000    
9    SELECT COUNT(*) AS cpt
FROM `glpi_rules`
WHERE sub_type='RuleDictionnarySoftware'    0.000    
AUTOLOAD
PluginOcsinventoryngOcsServer, Software, CommonITILObject, Dropdown, Bookmark, CronTask, Search, CommonDropdown, CommonTreeDropdown, Location, Contract, Document, CommonDBConnexity, CommonDBChild, Infocom, Ajax, DisplayPreference, Log, Lock, Manufacturer, Softwarecategory
POST VARIABLE
KEY    =>    VALUE
itemtype    =>    Software
num    =>    0
field    =>    1
searchtype    =>    contains
value    =>   
meta    =>    0
searchopt    =>   
KEY    =>    VALUE
table    =>    glpi_softwares
field    =>    name
datatype    =>    itemlink
massiveaction    =>   
linkfield    =>    name
joinparams    =>   
GET VARIABLE
KEY    =>    VALUE
start    =>    0
order    =>    ASC
is_deleted    =>    0
distinct    =>    N
link    =>   
field    =>   
contains    =>   
KEY    =>    VALUE
0    =>   
searchtype    =>   
KEY    =>    VALUE
0    =>    contains
link2    =>   
field2    =>   
KEY    =>    VALUE
0    =>    view
contains2    =>   
KEY    =>    VALUE
0    =>   
itemtype2    =>   
searchtype2    =>   
sort    =>    1
SESSION VARIABLE
KEY    =>    VALUE
glpi_plugins    =>   
KEY    =>    VALUE
1    =>    ocsinventoryng
glpicookietest    =>    testcookie
glpicsrftokens    =>   
KEY    =>    VALUE
3b4b9f416e6c5281191acba4a4e5b776    =>    1377616114
02023bd6f97749e082f5ffe606712625    =>    1377616135
f892059dda2506c727d0aee475c03d61    =>    1377616141
de76cfd0f98f134022e1bb203c6a8391    =>    1377616171
0e1605c6cda699415abff05107fb2291    =>    1377616176
1c7f443d846b030baebe19b72d7e6c1f    =>    1377616188
674b3c1957beffdf32961daf8967bbbf    =>    1377616189
4632dfd944d479112ba91dc2dbd0d540    =>    1377616195
5df6a3fe8a6938ded044000f9df7ff18    =>    1377616430
125939b7aa1aa338741da2c8aa59aff5    =>    1377616437
517cb25be2be1da294afc2f8bd995be8    =>    1377616438
04342a68b0a75289e61c2205a4bd5bf5    =>    1377616445
5c50ca0b34565f1096a16bc00763c6ec    =>    1377616451
4e4858a087c73acac1b58e6188556e0f    =>    1377616453
6af10f996978275bab970db1a928dbf9    =>    1377616471
aa4afc4d2ffbc39a48b0de891f1c468a    =>    1377616477
731b1f4402459d83ffc73abe148af418    =>    1377616478
7cf38df17e892562e3c9d648c2707ae6    =>    1377616479
03f4a3b423108660d8d5112a406ecefe    =>    1377616484
aad1cbaa24f08a1e097dbeefa571fa4f    =>    1377616640
ac17d391804c4f8646433739f2a01cb8    =>    1377616642
1888e698e93ce777b64c47274f2b8040    =>    1377616643
887e757309aa1c3149ea5e650ab2d805    =>    1377616653
870a5b520bb469ba392bdd04a3cb0e63    =>    1377616661
f11f1935657f742600539261829e6a71    =>    1377616665
3f45712e8f0aa892af5b8a7925c2823c    =>    1377616666
6a3cedea2b899bbe24310b203b085aaa    =>    1377616787
4f610c08395cd0db6fc121fb4a1c9085    =>    1377617297
2a38f4f4072f8f5bd16bc3077cd80e0f    =>    1377617309
5d5bd661f383b3d26f8942c3aa07f894    =>    1377617345
6dd9ab6737baa7c296733fb64a4461c6    =>    1377617345
glpi_currenttime    =>    2013-08-27 10:29:05
glpi_use_mode    =>    2
glpi_table_of    =>   
KEY    =>    VALUE
User    =>    glpi_users
Profile    =>    glpi_profiles
PluginOcsinventoryngProfile    =>    glpi_plugin_ocsinventoryng_profiles
Config    =>    glpi_configs
ProblemTask    =>    glpi_problemtasks
Problem    =>    glpi_problems
TicketTask    =>    glpi_tickettasks
Ticket    =>    glpi_tickets
UserEmail    =>    glpi_useremails
Location    =>    glpi_locations
Event    =>    glpi_events
CronTask    =>    glpi_crontasks
CronTaskLog    =>    glpi_crontasklogs
RequestType    =>    glpi_requesttypes
SoftwareCategory    =>    glpi_softwarecategories
DocumentCategory    =>    glpi_documentcategories
Plugin    =>    glpi_plugins
Entity    =>    glpi_entities
Computer    =>    glpi_computers
Software    =>    glpi_softwares
RuleAction    =>    glpi_ruleactions
RuleCriteria    =>    glpi_rulecriterias
glpiID    =>    2
glpiname    =>    glpi
glpirealname    =>   
glpifirstname    =>   
glpidefault_entity    =>    0
glpiusers_idisation    =>    1
glpiextauth    =>    0
glpiauthtype    =>    1
glpiroot    =>    /glpi-84
glpicrontimer    =>    1377610082
glpi_tabs    =>   
KEY    =>    VALUE
central    =>    Central$1
preference    =>    User%241
config    =>    Config$1
glpicsv_delimiter    =>    ;
glpidate_format    =>    0
glpidefault_requesttypes_id    =>    1
glpidisplay_count_on_home    =>    5
glpidropdown_chars_limit    =>    50
glpiduedatecritical_color    =>    #ff0000
glpiduedatecritical_less    =>    5
glpiduedatecritical_unit    =>    %
glpiduedateok_color    =>    #06ff00
glpiduedatewarning_color    =>    #ffb800
glpiduedatewarning_less    =>    20
glpiduedatewarning_unit    =>    %
glpifollowup_private    =>    0
glpiis_categorized_soft_expanded    =>    1
glpiis_ids_visible    =>    0
glpiis_not_categorized_soft_expanded    =>    1
glpilanguage    =>    pt_BR
glpilist_limit    =>    20
glpinames_format    =>    1
glpinotification_to_myself    =>    0
glpinumber_format    =>    0
glpipriority_1    =>    #fff2f2
glpipriority_2    =>    #ffe0e0
glpipriority_3    =>    #ffcece
glpipriority_4    =>    #ffbfbf
glpipriority_5    =>    #ffadad
glpipriority_6    =>    #ff5555
glpirefresh_ticket_list    =>    0
glpiset_default_tech    =>    1
glpishow_count_on_tabs    =>    1
glpishow_jobs_at_login    =>    0
glpitask_private    =>    0
glpiuse_flat_dropdowntree    =>    0
glpiprofiles    =>   
KEY    =>    VALUE
4    =>   
KEY    =>    VALUE
name    =>    Super-Admin
entities    =>   
KEY    =>    VALUE
0    =>   
KEY    =>    VALUE
id    =>    0
name    =>    Entité racine
is_recursive    =>    1
glpiactiveprofile    =>   
KEY    =>    VALUE
id    =>    4
name    =>    Super-Admin
interface    =>    central
is_default    =>    0
computer    =>    w
monitor    =>    w
software    =>    w
networking    =>    w
internet    =>    w
printer    =>    w
peripheral    =>    w
cartridge    =>    w
consumable    =>    w
phone    =>    w
notes    =>    w
contact_enterprise    =>    w
document    =>    w
contract    =>    w
infocom    =>    w
knowbase    =>    w
knowbase_admin    =>    1
faq    =>    w
reservation_helpdesk    =>    1
reservation_central    =>    w
reports    =>    r
dropdown    =>    w
entity_dropdown    =>    w
device    =>    w
typedoc    =>    w
link    =>    w
config    =>    w
rule_ticket    =>    r
entity_rule_ticket    =>    w
rule_import    =>    w
rule_ldap    =>    w
rule_softwarecategories    =>    w
search_config    =>    w
search_config_global    =>    w
check_update    =>    r
profile    =>    w
user    =>    w
user_authtype    =>    w
group    =>    w
entity    =>    w
transfer    =>    w
logs    =>    r
reminder_public    =>    w
rssfeed_public    =>    w
bookmark_public    =>    w
backup    =>    w
create_ticket    =>    1
delete_ticket    =>    1
add_followups    =>    1
group_add_followups    =>    1
global_add_followups    =>    1
global_add_tasks    =>    1
update_ticket    =>    1
update_priority    =>    1
own_ticket    =>    1
steal_ticket    =>    1
assign_ticket    =>    1
show_all_ticket    =>    1
show_assign_ticket    =>    1
show_full_ticket    =>    1
observe_ticket    =>    1
update_followups    =>    1
update_tasks    =>    1
show_planning    =>    1
show_group_planning    =>    1
show_all_planning    =>    1
statistic    =>    1
password_update    =>    1
helpdesk_hardware    =>    3
helpdesk_item_type    =>   
KEY    =>    VALUE
0    =>    Computer
1    =>    Monitor
2    =>    NetworkEquipment
3    =>    Peripheral
4    =>    Phone
5    =>    Printer
6    =>    Software
ticket_status    =>   
show_group_ticket    =>    0
show_group_hardware    =>    0
rule_dictionnary_software    =>    w
rule_dictionnary_dropdown    =>    w
budget    =>    w
import_externalauth_users    =>    w
notification    =>    w
rule_mailcollector    =>    w
date_mod    =>   
comment    =>   
validate_request    =>    1
create_request_validation    =>    1
calendar    =>    w
sla    =>    w
rule_dictionnary_printer    =>    w
update_own_followups    =>    1
delete_followups    =>    1
entity_helpdesk    =>    w
show_my_problem    =>    1
show_all_problem    =>    1
edit_all_problem    =>    1
problem_status    =>   
create_ticket_on_login    =>    0
tickettemplate    =>    w
ticketrecurrent    =>    w
ticketcost    =>    w
validate_incident    =>    1
create_incident_validation    =>    1
delete_validations    =>    1
tickettemplates_id    =>    0
entities    =>   
KEY    =>    VALUE
0    =>   
KEY    =>    VALUE
id    =>    0
name    =>    Entité racine
is_recursive    =>    1
glpiactiveentities    =>   
KEY    =>    VALUE
0    =>    0
glpisearch    =>   
KEY    =>    VALUE
Computer    =>   
KEY    =>    VALUE
start    =>    0
order    =>    ASC
is_deleted    =>    0
distinct    =>    N
link    =>   
field    =>   
contains    =>   
KEY    =>    VALUE
0    =>   
searchtype    =>   
KEY    =>    VALUE
0    =>    contains
link2    =>   
field2    =>   
KEY    =>    VALUE
0    =>    view
contains2    =>   
KEY    =>    VALUE
0    =>   
itemtype2    =>   
searchtype2    =>   
sort    =>    1
Software    =>   
KEY    =>    VALUE
start    =>    0
order    =>    ASC
is_deleted    =>    0
distinct    =>    N
link    =>   
field    =>   
contains    =>   
KEY    =>    VALUE
0    =>   
searchtype    =>   
KEY    =>    VALUE
0    =>    contains
link2    =>   
field2    =>   
KEY    =>    VALUE
0    =>    view
contains2    =>   
KEY    =>    VALUE
0    =>   
itemtype2    =>   
searchtype2    =>   
sort    =>    1
glpisearchcount    =>   
KEY    =>    VALUE
Computer    =>    1
Software    =>    1
glpisearchcount2    =>   
KEY    =>    VALUE
Computer    =>    0
Software    =>    0
glpiactiveentities_string    =>    '0'
glpiparententities    =>   
glpiparententities_string    =>   
glpiactive_entity    =>    0
glpiactive_entity_recursive    =>    1
glpiactive_entity_name    =>    Entité racine (estrutura de árvore)
glpiactive_entity_shortname    =>    Entité racine (estrutura de árvore)
glpishowallentities    =>    0
glpigroups    =>   
glpi_plugin_ocsinventoryng_profile    =>   
KEY    =>    VALUE
id    =>    1
profiles_id    =>    4
ocsng    =>    w
sync_ocsng    =>    w
view_ocsng    =>    r
clean_ocsng    =>    w
rule_ocs    =>    w
MESSAGE_AFTER_REDIRECT    =>   
glpishowmigrationcleaner    =>   
glpi_multientitiesmode    =>    0
glpi_foreign_key_field_of    =>   
KEY    =>    VALUE
Problem    =>    problems_id
Ticket    =>    tickets_id
Location    =>    locations_id
RequestType    =>    requesttypes_id
SoftwareCategory    =>    softwarecategories_id
DocumentCategory    =>    documentcategories_id
glpi_maxhistory    =>    7041
glpicronuserrunning    =>   
glpi_warned_about_full_page_tab    =>    1
glpilisttitle    =>   
KEY    =>    VALUE
Computer    =>    Lista
Software    =>    Lista
glpilistitems    =>   
KEY    =>    VALUE
Computer    =>   
KEY    =>    VALUE
0    =>    24
Software    =>   
KEY    =>    VALUE
0    =>    1376
1    =>    1378
2    =>    1292
3    =>    1418
4    =>    1359
5    =>    1358
6    =>    1293
7    =>    1421
8    =>    1420
9    =>    1348
10    =>    1330
11    =>    1343
12    =>    1377
13    =>    1294
14    =>    1346
15    =>    1360
16    =>    1367
17    =>    1423
18    =>    1379
19    =>    1334
glpilisturl    =>   
KEY    =>    VALUE
Computer    =>    /glpi-84/front/computer.php
Software    =>    /glpi-84/front/software.php
glpimassiveactionselected    =>   
KEY    =>    VALUE
Computer    =>   
Software    =>

Offline

Board footer

Powered by FluxBB