Thanks for the quick help. I did check this and created a extension with
new profile for licence manager, but receving an error when user assigned
to this new profile and tried to login.
It is working when I used along with document manager. But if we need to
give only license link for Ci's profile do you advice to have any default
groups or classes or actions we need to give?
Fatal error, iTop cannot continue.
Error: No result for the single row query: 'SELECT DISTINCT Contact.id
AS Contactid, Contact.name AS Contactname, Contact.status AS Contactstatus, Contact.org_id AS Contactorg_id, Organization_org_id.name AS Contactorg_name, Contact.email AS Contactemail, Contact.phone AS Contactphone, Contact.notify AS Contactnotify, Contact.function AS Contactfunction, Contact.finalclass AS Contactfinalclass, IF((Contact.finalclass
IN ('Team', 'Contact')), CAST(CONCAT(COALESCE(Contact.name, '')) AS
CHAR), CAST(CONCAT(COALESCE(Contact_poly_Person.first_name, ''),
COALESCE(' ', ''), COALESCE(Contact.name, '')) AS CHAR)) AS Contactfriendlyname, COALESCE((Contact.status = 'inactive'), 0) AS Contactobsolescence_flag, Contact.obsolescence_date AS Contactobsolescence_date,
CAST(CONCAT(COALESCE(Organization_org_id.name, '')) AS CHAR) AS Contactorg_id_friendlyname, COALESCE((Organization_org_id.status =
'inactive'), 0) AS Contactorg_id_obsolescence_flag FROM contact AS Contact INNER JOIN organization AS Organization_org_id ON Contact.org_id = Organization_org_id.id LEFT JOIN person AS Contact_poly_Person ON Contact.id = Contact_poly_Person.id WHERE
((Contact.id = 31) AND 0) '.
Thanks for the quick help. I did check this and created a extension with new profile for licence manager, but receiving an error when user assigned to this new profile and tried to login.
It is working when I used along with document manager. But if we need to give only license link for Ci's profile do you advice to have any default groups or classes or actions we need to give?
Fatal error, iTop cannot continue.
Error: No result for the single row query: 'SELECT DISTINCT Contact.id AS Contactid, Contact.name AS Contactname, Contact.status AS Contactstatus, Contact.org_id AS Contactorg_id, Organization_org_id.name AS Contactorg_name, Contact.email AS Contactemail, Contact.phone AS Contactphone, Contact.notify AS Contactnotify, Contact.function AS Contactfunction, Contact.finalclass AS Contactfinalclass, IF((Contact.finalclass IN ('Team', 'Contact')), CAST(CONCAT(COALESCE(Contact.name, '')) AS CHAR), CAST(CONCAT(COALESCE(Contact_poly_Person.first_name, ''), COALESCE(' ', ''), COALESCE(Contact.name, '')) AS CHAR)) AS Contactfriendlyname, COALESCE((Contact.status = 'inactive'), 0) AS Contactobsolescence_flag, Contact.obsolescence_date AS Contactobsolescence_date, CAST(CONCAT(COALESCE(Organization_org_id.name, '')) AS CHAR) AS Contactorg_id_friendlyname, COALESCE((Organization_org_id.status = 'inactive'), 0) AS Contactorg_id_obsolescence_flag FROM contact AS Contact INNER JOIN organization AS Organization_org_id ON Contact.org_id = Organization_org_id.id LEFT JOIN person AS Contact_poly_Person ON Contact.id = Contact_poly_Person.id WHERE ((Contact.id = 31) AND 0) '.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
Can someone guide me on how to create security profiles to create separate groups in maintaining separate CI's(Configuration items) in CMBD.
Example:
Servers Create/Edit and delete should be handled by one user
Licenses create/edit and delete should be another user
Currently we only have configuration manager who can create/edit all CI's.
Can someone guide me if this is possible to create/edit particluar CI of CMBD by security profiles.
Thanks
Hello Karthik,
Take a look at this tutorial, it should help you :)
Cheers,
Guillaume
Hi,
Thanks for the quick help. I did check this and created a extension with
new profile for licence manager, but receving an error when user assigned
to this new profile and tried to login.
It is working when I used along with document manager. But if we need to
give only license link for Ci's profile do you advice to have any default
groups or classes or actions we need to give?
<itop_design xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1.0">
<group id="user-content-LICENCEMGR" _delta="define"> <classes> <class id="user-content-Licence"> </class></classes> </group><classes>
<menus>
<user_rights>
<groups></groups></user_rights></menus></classes></itop_design>
licenses
<groups>
<group id="user-content-LICENCEMGR">
<actions>
<action id="user-content-action:write">allow</action>
<action id="user-content-action:bulk write">allow</action>
<action id="user-content-action:delete">allow</action>
</actions>
</group>
</groups>
Fatal error, iTop cannot continue.
Error: No result for the single row query: 'SELECT DISTINCT
Contact
.id
AS
Contactid
,Contact
.name
ASContactname
,Contact
.status
ASContactstatus
,Contact
.org_id
ASContactorg_id
,Organization_org_id
.name
ASContactorg_name
,Contact
.email
ASContactemail
,Contact
.phone
ASContactphone
,Contact
.notify
ASContactnotify
,Contact
.function
ASContactfunction
,Contact
.finalclass
ASContactfinalclass
, IF((Contact
.finalclass
IN ('Team', 'Contact')), CAST(CONCAT(COALESCE(
Contact
.name
, '')) ASCHAR), CAST(CONCAT(COALESCE(
Contact_poly_Person
.first_name
, ''),COALESCE(' ', ''), COALESCE(
Contact
.name
, '')) AS CHAR)) ASContactfriendlyname
, COALESCE((Contact
.status
= 'inactive'), 0) ASContactobsolescence_flag
,Contact
.obsolescence_date
ASContactobsolescence_date
,CAST(CONCAT(COALESCE(
Organization_org_id
.name
, '')) AS CHAR) ASContactorg_id_friendlyname
, COALESCE((Organization_org_id
.status
='inactive'), 0) AS
Contactorg_id_obsolescence_flag
FROMcontact
ASContact
INNER JOINorganization
ASOrganization_org_id
ONContact
.org_id
=Organization_org_id
.id
LEFT JOINperson
ASContact_poly_Person
ONContact
.id
=Contact_poly_Person
.id
WHERE((
Contact
.id
= 31) AND 0) '.On Thu, Mar 4, 2021 at 3:44 PM Guillaume Lajarige glajarige@users.sourceforge.net wrote:
Hi Guillaume,
Thanks for the quick help. I did check this and created a extension with new profile for licence manager, but receiving an error when user assigned to this new profile and tried to login.
It is working when I used along with document manager. But if we need to give only license link for Ci's profile do you advice to have any default groups or classes or actions we need to give?
<itop_design xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1.0">
<group id="user-content-LICENCEMGR" _delta="define"> <classes> <class id="user-content-Licence"> </class></classes> </group><classes>
<menus>
<user_rights>
<groups></groups></user_rights></menus></classes></itop_design>
Error when user tried to login with new profile
Fatal error, iTop cannot continue.
Error: No result for the single row query: 'SELECT DISTINCT
Contact
.id
ASContactid
,Contact
.name
ASContactname
,Contact
.status
ASContactstatus
,Contact
.org_id
ASContactorg_id
,Organization_org_id
.name
ASContactorg_name
,Contact
.email
ASContactemail
,Contact
.phone
ASContactphone
,Contact
.notify
ASContactnotify
,Contact
.function
ASContactfunction
,Contact
.finalclass
ASContactfinalclass
, IF((Contact
.finalclass
IN ('Team', 'Contact')), CAST(CONCAT(COALESCE(Contact
.name
, '')) AS CHAR), CAST(CONCAT(COALESCE(Contact_poly_Person
.first_name
, ''), COALESCE(' ', ''), COALESCE(Contact
.name
, '')) AS CHAR)) ASContactfriendlyname
, COALESCE((Contact
.status
= 'inactive'), 0) ASContactobsolescence_flag
,Contact
.obsolescence_date
ASContactobsolescence_date
, CAST(CONCAT(COALESCE(Organization_org_id
.name
, '')) AS CHAR) ASContactorg_id_friendlyname
, COALESCE((Organization_org_id
.status
= 'inactive'), 0) ASContactorg_id_obsolescence_flag
FROMcontact
ASContact
INNER JOINorganization
ASOrganization_org_id
ONContact
.org_id
=Organization_org_id
.id
LEFT JOINperson
ASContact_poly_Person
ONContact
.id
=Contact_poly_Person
.id
WHERE ((Contact
.id
= 31) AND 0) '.