The CMDBGroupAPI provides methods for performing actions on Configuration Management Database (CMDB) groups.

This API is a scoped static class. To use this class you must include the sn_cmdbgroup namespace identifier before the CMDBGroupAPI object. For example:
var response = sn_cmdbgroup.CMDBGroupAPI.getManualCIList(groupSysId, false);

To access this API you must have the itil or asset role.

CMDBGroupAPI - getAllCI(String groupId, Boolean requireCompleteSet, Boolean requireAllQueryNodesCis)

Returns all configuration items (CIs) for the specified group. The results include all manual CIs and the list of CIs from the query builder's saved query.

Table 1. Parameters
Name Type Description
groupId String Sys_id of the Configuration Management Database (CMDB) group.
requireCompleteSet Boolean Optional, but must be passed if requireAllQueryNodesCis is passed.

Flag that indicates whether an empty string is returned if any CIs are filtered out by access control list (ACL) restrictions.

Valid values:
  • true: Return empty string.
  • false: Don't return value.

Default: false
requireAllQueryNodesCis Boolean Optional. Flag that indicates whether to return CIs from all CMDB classes of the query.
Valid values:
  • true: Return CIs from all columns.
  • false: Only return CIs from the starting node of the query builder query.

Default: false
Table 2. Returns
TypeDescription
errors List of errors for a failed operation.

Data type: Array

"errors": [ 
  {
    "message": "String",
    "error": "String"
  } 
]
errors.error Error name.
Possible values:
  • GROUP_SYS_ID_IS_NOT_FOUND
  • GROUP_SYS_ID_IS_EMPTY
  • FAIL_TO_INSERT_GROUP_CI_PAIR
  • FAIL_TO_INSERT_GROUP_QUERY_ID_PAIR
  • CI_CAN_NOT_FOUND
  • SAVED_QUERY_ID_NOT_FOUND
  • ERROR_DURING_QUERY_BUILDER_PROCESS_QUERY
  • TIMEOUT_DURING_QUERY_BUILDER_PROCESS_QUERY
  • NOT_COMPLETE_DURING_QUERY_BUILDER_PROCESS_QUERY
  • MAX_LIMIT_DURING_QUERY_BUILDER_PROCESS_QUERY
  • GROUP_API_TIMEOUT
  • EXCEPTION_FROM_EXECUTE_QUERY
  • SOME_CI_NOT_VISIBLE_DUE_TO_SECURITY_CONSTRAINT

Data type: String
errors.message Brief description of the error message.

Data type: String
idList List of CMDB CI sys_ids.

Data type: Array
partialCIListDueToACLFlag Flag that indicates if the list of returned CIs is incomplete due to ACL restrictions.
Note: This is not considered an error condition, and no corresponding error information is returned.

Data type: Boolean

Valid values:
  • true: idList is incomplete.
  • false: idList is complete.
result Flag that indicates whether the method completed successfully.
Possible values:
  • true: Success
  • false: Error

Example

// Script example: 
var getAllCIFunc = function(groupSysId) {
  var parser = new JSONParser();
  var response = sn_cmdbgroup.CMDBGroupAPI.getAllCI(groupSysId, false);
  var parsed = parser.parse(response);
  if (parsed.result) {
    gs.info("succeed to retrieve ci list: " + parsed.idList);
  } else {
    gs.info("fail to retrieve list, errors: " + JSON.stringify(parsed.errors));
  }
}
var groupExists = "d0d2d25113152200eef2dd828144b0e4";
var groupContainsInvalidSavedQuery = "e685a2c3d7012200de92a5f75e610387";
getAllCIFunc(groupExists);
getAllCIFunc(groupContainsInvalidSavedQuery);

Output:

// Successful response
{
  'result':true, 
  'partialCIListDueToACLFlag': false,
  'idList':[
    '3a5dd3dbc0a8ce0100655f1ec66ed42c',
    '6b43105c37301000deeabfc8bcbe5db2'
  ] 
}

// Error response
{ 
  'result':false, 
  'errors':[ 
    {
      'message':'Group does not exist',
      'error':'GROUP_SYS_ID_IS_NOT_FOUND'
    } 
  ], 
  'partialCIListDueToACLFlag':false,
  'idList':[] 
}

CMDBGroupAPI - getAllCIFromQueryBuilder(String groupId, Boolean requireCompleteSet, Boolean requireAllQueryNodesCis)

Returns all configuration items (CIs) returned from all saved query builders' query IDs for the specified group.

Table 3. Parameters
Name Type Description
groupId String Sys_id of the Configuration Management Database (CMDB) group.
requireCompleteSet Boolean Optional, but must be passed if requireAllQueryNodesCis is passed.

Flag that indicates whether an empty string is returned if any CIs are filtered out by access control list (ACL) restrictions.

Valid values:
  • true: Return empty string.
  • false: Don't return value.

Default: false
requireAllQueryNodesCis Boolean Optional. Flag that indicates whether to return CIs from all CMDB classes of the query.
Valid values:
  • true: Return CIs from all columns.
  • false: Only return CIs from the starting node of the query builder query.

Default: false
Table 4. Returns
TypeDescription
errors List of errors for a failed operation.

Data type: Array

"errors": [ 
  {
    "message": "String",
    "error": "String"
  } 
]
errors.error Error name.
Possible values:
  • GROUP_SYS_ID_IS_NOT_FOUND
  • GROUP_SYS_ID_IS_EMPTY
  • FAIL_TO_INSERT_GROUP_CI_PAIR
  • FAIL_TO_INSERT_GROUP_QUERY_ID_PAIR
  • CI_CAN_NOT_FOUND
  • SAVED_QUERY_ID_NOT_FOUND
  • ERROR_DURING_QUERY_BUILDER_PROCESS_QUERY
  • TIMEOUT_DURING_QUERY_BUILDER_PROCESS_QUERY
  • NOT_COMPLETE_DURING_QUERY_BUILDER_PROCESS_QUERY
  • MAX_LIMIT_DURING_QUERY_BUILDER_PROCESS_QUERY
  • GROUP_API_TIMEOUT
  • EXCEPTION_FROM_EXECUTE_QUERY
  • SOME_CI_NOT_VISIBLE_DUE_TO_SECURITY_CONSTRAINT

Data type: String
errors.message Brief description of the error message.

Data type: String
idList List of CMDB CI sys_ids.

Data type: Array
partialCIListDueToACLFlag Flag that indicates if the list of returned CIs is incomplete due to ACL restrictions.
Note: This is not considered an error condition, and no corresponding error information is returned.

Data type: Boolean

Valid values:
  • true: idList is incomplete.
  • false: idList is complete.
result Flag that indicates whether the method completed successfully.
Possible values:
  • true: Success
  • false: Error

Example

// Script example:
var getAllCIFromQueryBuilderFunc = function(groupSysId) {
  var parser = new JSONParser();
  var response = sn_cmdbgroup.CMDBGroupAPI.getAllCIFromQueryBuilder(groupSysId, false);
  var parsed = parser.parse(response);
  if (parsed.result) {
    gs.info("succeed to retrieve ci list: " + parsed.idList);
  } else {
    gs.info("fail to retrieve list, errors: " + JSON.stringify(parsed.errors));
  }
}
var groupExists = "d0d2d25113152200eef2dd828144b0e4";
var groupContainsInvalidSavedQuery = "e685a2c3d7012200de92a5f75e610387";
getAllCIFromQueryBuilderFunc(groupExists);
getAllCIFromQueryBuilderFunc(groupContainsInvalidSavedQuery);

Output:

// Successful response
{
  'result':true, 
  'partialCIListDueToACLFlag': false,
  'idList':[
    '3a5dd3dbc0a8ce0100655f1ec66ed42c',
    '6b43105c37301000deeabfc8bcbe5db2'
  ] 
}

// Error response
{ 
  'result':false, 
  'errors':[ 
    {'message':'Group does not exist',
    'error':'GROUP_SYS_ID_IS_NOT_FOUND'} 
  ], 
  'partialCIListDueToACLFlag':false,
  'idList':[] 
}

CMDBGroupAPI - getManualCIList(String groupId, Boolean requireCompleteSet)

Returns the CMDB group's manual CI list.

Table 5. Parameters
Name Type Description
groupId String The sysId of the CMDB group.
requireCompleteSet Boolean When true, returns an error string if any CIs are filtered out by ACL restrictions.
Table 6. Returns
Type Description
String A JSON formated string in the format 
{ 'result':false, 
'errors':[ {'message':'Group does not exist',
            'error':'GROUP_SYS_ID_IS_NOT_FOUND'},
 { } // another error if it exists 
 ], 
'partialCIListDueToACLFlag':false,
'idList':['sys_id_1', 'sys_id2'] }
Where
  • result - a boolean flag. When true the method was successful.
  • errors - a list of errors with a message and error code.
  • partialCIListDueToACLFlag -  a Boolean flag. When true, the idList is incomplete due to an ACL restriction. When false, the idList is complete.
  • idList - an array of cmdb_ci sys_ids

When not successful, returns one of the errors GROUP_SYS_ID_IS_NOT_FOUND, GROUP_SYS_ID_IS_EMPTY, FAIL_TO_INSERT_GROUP_CI_PAIR, FAIL_TO_INSERT_GROUP_QUERY_ID_PAIR, CI_CAN_NOT_FOUND, SAVED_QUERY_ID_NOT_FOUND, ERROR_DURING_QUERY_BUILDER_PROCESS_QUERY, TIMEOUT_DURING_QUERY_BUILDER_PROCESS_QUERY, NOT_COMPLETE_DURING_QUERY_BUILDER_PROCESS_QUERY, MAX_LIMIT_DURING_QUERY_BUILDER_PROCESS_QUERY, GROUP_API_TIMEOUT, EXCEPTION_FROM_EXECUTE_QUERY, SOME_CI_NOT_VISIBLE_DUE_TO_SECURITY_CONSTRAINT

Example

// Script example for requireCompleteSet being false:
    var getManualCIList = function(groupSysId) {
    var parser = new JSONParser();
    var response = sn_cmdbgroup.CMDBGroupAPI.getManualCIList(groupSysId, false);
    var parsed = parser.parse(response);
    if (parsed.result) {
        gs.info("succeed to retrieve ci list: " + parsed.idList);
    } else {
        gs.info("fail to retrieve list, errors: " + JSON.stringify(parsed.errors));
    }
}
// create a group in cmdb_group, and add CIs to this group in Edit Manual CI form
var groupExists = "d0d2d25113152200eef2dd828144b0e4";
// use a non-exist group
var groupDoesNotExists = "d0d2d25113152200eef2dd828144b0e4111";
getManualCIList(groupExists);
getManualCIList(groupDoesNotExists);

Output: (Line breaks added for formatting.)

succeed to retrieve ci 
list: 6b43105c37301000deeabfc8bcbe5db2,2dfd7c8437201000deeabfc8bcbe5d56
fail to retrieve list, errors: 
[{"message":"Group does not exist","error":"GROUP_SYS_ID_IS_NOT_FOUND"}]

Example

// Script example for requireCompleteSet being true
    var getManualCIList = function(groupSysId) {
    var parser = new JSONParser();
    var response = sn_cmdbgroup.CMDBGroupAPI.getManualCIList(groupSysId, true);
    var parsed = parser.parse(response);
    if (parsed.result) {
        gs.info("succeed to retrieve ci list: " + parsed.idList);
    } else {
        gs.info("fail to retrieve list, errors: " + JSON.stringify(parsed.errors));
    }
}
// create a group in cmdb_group, and add CIs to this group in Edit Manual CI form
var groupExists = "d0d2d25113152200eef2dd828144b0e4";
getManualCIList(groupExists);

Output: (Line breaks added for formatting.)

fail to retrieve list, errors: 
[{"message":"Some CI(s) not visible due to security constraint",
"error":"SOME_CI_NOT_VISIBLE_DUE_TO_SECURITY_CONSTRAINT"}]

CMDBGroupAPI - getSavedQueryIdList(String groupId, Boolean requireCompleteSet)

Returns the query builder's query IDs for the specified CMDB group.

Table 7. Parameters
Name Type Description
groupId String The sysId of the CMDB group.
requireCompleteSet Boolean When true, returns an empty string if any CIs are filtered out by ACL restrictions.
Table 8. Returns
Type Description
String A JSON formated string in the format 
{ 'result':false, 
'errors':[ {'message':'Group does not exist',
            'error':'GROUP_SYS_ID_IS_NOT_FOUND'},
 { } // another error if it exists 
 ], 
'partialCIListDueToACLFlag':false,
'idList':['sys_id_1', 'sys_id2'] }
Where
  • result - a boolean flag. When true the method was successful.
  • errors - a list of errors with a message and error code.
  • partialCIListDueToACLFlag -  a Boolean flag. When true, the idList is incomplete due to an ACL restriction. When false, the idList is complete.
  • idList - an array of cmdb_ci sys_ids

When not successful, returns one of the errors GROUP_SYS_ID_IS_NOT_FOUND, GROUP_SYS_ID_IS_EMPTY, FAIL_TO_INSERT_GROUP_CI_PAIR, FAIL_TO_INSERT_GROUP_QUERY_ID_PAIR, CI_CAN_NOT_FOUND, SAVED_QUERY_ID_NOT_FOUND, ERROR_DURING_QUERY_BUILDER_PROCESS_QUERY, TIMEOUT_DURING_QUERY_BUILDER_PROCESS_QUERY, NOT_COMPLETE_DURING_QUERY_BUILDER_PROCESS_QUERY, MAX_LIMIT_DURING_QUERY_BUILDER_PROCESS_QUERY, GROUP_API_TIMEOUT, EXCEPTION_FROM_EXECUTE_QUERY, SOME_CI_NOT_VISIBLE_DUE_TO_SECURITY_CONSTRAINT

Example

// Script example:
var getSavedQueryIdList = function(groupSysId) {
    var parser = new JSONParser();
    var response = sn_cmdbgroup.CMDBGroupAPI.getSavedQueryIdList(groupSysId, false);
    var parsed = parser.parse(response);
    if (parsed.result) {
        gs.info("succeed to retrieve saved query id list: " + parsed.idList);
    } else {
        gs.info("fail to retrieve list, errors: " + JSON.stringify(parsed.errors));
    }
}
var groupExists = "d0d2d25113152200eef2dd828144b0e4";
var groupDoesNotExists = "d0d2d25113152200eef2dd828144b0e4111";
getSavedQueryIdList(groupExists);
getSavedQueryIdList(groupDoesNotExists);

Output: (Line breaks added for formatting.)

succeed to retrieve saved query id list: 5d498532d7c12200de92a5f75e6103ce
fail to retrieve list, errors:
 [{"message":"Group does not exist","error":"GROUP_SYS_ID_IS_NOT_FOUND"}]

CMDBGroupAPI - setManualCIList(String groupId, String ciSysIds)

Sets the manual CI list for the specified group. The existing manual CI list is overwritten. CI sysIds not found in the cmdb_ci table are ignored.

Table 9. Parameters
Name Type Description
groupId String The sysId of the CMDB group.
ciSysIds String Comma separated list of CI sysIds.
Table 10. Returns
Type Description
String A JSON formated string in the format 
{ 'result':false, 
'errors':[ {'message':'Group does not exist',
            'error':'GROUP_SYS_ID_IS_NOT_FOUND'},
 { } // another error if it exists 
 ], 
'partialCIListDueToACLFlag':false,
'idList':['sys_id_1', 'sys_id2'] }
Where
  • result - a boolean flag. When true the method was successful.
  • errors - a list of errors with a message and error code.
  • partialCIListDueToACLFlag -  a Boolean flag. When true, the idList is incomplete due to an ACL restriction. When false, the idList is complete.
  • idList - an array of cmdb_ci sys_ids

When not successful, returns one of the errors GROUP_SYS_ID_IS_NOT_FOUND, GROUP_SYS_ID_IS_EMPTY, FAIL_TO_INSERT_GROUP_CI_PAIR, FAIL_TO_INSERT_GROUP_QUERY_ID_PAIR, CI_CAN_NOT_FOUND, SAVED_QUERY_ID_NOT_FOUND, ERROR_DURING_QUERY_BUILDER_PROCESS_QUERY, TIMEOUT_DURING_QUERY_BUILDER_PROCESS_QUERY, NOT_COMPLETE_DURING_QUERY_BUILDER_PROCESS_QUERY, MAX_LIMIT_DURING_QUERY_BUILDER_PROCESS_QUERY, GROUP_API_TIMEOUT, EXCEPTION_FROM_EXECUTE_QUERY, SOME_CI_NOT_VISIBLE_DUE_TO_SECURITY_CONSTRAINT

Example

// Script example:
var setManualCIListFunc = function(groupSysId, manualCIList) {
    var parser = new JSONParser();
    var response = sn_cmdbgroup.CMDBGroupAPI.setManualCIList(groupSysId, manualCIList);
    var parsed = parser.parse(response);
    if (parsed.result) {
        gs.info("succeed to set manual ci list");
    } else {
        gs.info("fail to set manual ci list, errors: " + JSON.stringify(parsed.errors));
    }
}
var group = "d0d2d25113152200eef2dd828144b0e4";
var groupDoesNotExist = "1234";
var manualCIList = "b4fd7c8437201000deeabfc8bcbe5dc1, affd3c8437201000deeabfc8bcbe5dc3";
setManualCIListFunc(group, manualCIList);
setManualCIListFunc(groupDoesNotExist, manualCIList);

Output: (Line breaks added for formatting.)

succeed to set manual ci list
fail to set manual ci list, errors: [{"message":"Group does not exist","error":
"GROUP_SYS_ID_IS_NOT_FOUND"}]

CMDBGroupAPI - setSavedQueryIdList(String groupId, String queryIds)

Sets the saved query ID list for the specified group. The existing query ID list is overwritten. Query sysIds not found in the qb_saved_query table are ignored.

Table 11. Parameters
Name Type Description
groupId String The sysId of the CMDB group.
queryIds String Comma separated list of saved query sysIds.
Table 12. Returns
Type Description
String A JSON formated string in the format 
{ 'result':false, 
'errors':[ {'message':'Group does not exist',
            'error':'GROUP_SYS_ID_IS_NOT_FOUND'},
 { } // another error if it exists 
 ], 
'partialCIListDueToACLFlag':false,
'idList':['sys_id_1', 'sys_id2'] }
Where
  • result - a boolean flag. When true the method was successful.
  • errors - a list of errors with a message and error code.
  • partialCIListDueToACLFlag -  a Boolean flag. When true, the idList is incomplete due to an ACL restriction. When false, the idList is complete.
  • idList - an array of cmdb_ci sys_ids

When not successful, returns one of the errors GROUP_SYS_ID_IS_NOT_FOUND, GROUP_SYS_ID_IS_EMPTY, FAIL_TO_INSERT_GROUP_CI_PAIR, FAIL_TO_INSERT_GROUP_QUERY_ID_PAIR, CI_CAN_NOT_FOUND, SAVED_QUERY_ID_NOT_FOUND, ERROR_DURING_QUERY_BUILDER_PROCESS_QUERY, TIMEOUT_DURING_QUERY_BUILDER_PROCESS_QUERY, NOT_COMPLETE_DURING_QUERY_BUILDER_PROCESS_QUERY, MAX_LIMIT_DURING_QUERY_BUILDER_PROCESS_QUERY, GROUP_API_TIMEOUT, EXCEPTION_FROM_EXECUTE_QUERY, SOME_CI_NOT_VISIBLE_DUE_TO_SECURITY_CONSTRAINT

Example

// Script example:
var setSavedQueryIdListFunc = function(groupSysId, queryIdList) {
    var parser = new JSONParser();
    var response = sn_cmdbgroup.CMDBGroupAPI.setSavedQueryIdList(groupSysId, queryIdList);
    var parsed = parser.parse(response);
    if (parsed.result) {
        gs.info("succeed to set saved query id list");
    } else {
        gs.info("fail to set saved query id list, errors: " + JSON.stringify(parsed.errors));
    }
}
var group = "d0d2d25113152200eef2dd828144b0e4";
var savedQueryBuilderIdList = "394585fed7812200de92a5f75e6103e8";
var savedQueryBuilderIdNotExistList = "b4fd7c8437201000deeabfc8bcbe5dc1,
   affd3c8437201000deeabfc8bcbe5dc3";
 
setSavedQueryIdListFunc(group, savedQueryBuilderIdList);
setSavedQueryIdListFunc(group, savedQueryBuilderIdNotExistList);

Output: (Line breaks added for formatting.)

succeed to set saved query id list
fail to set saved query id list, errors: [{"message":
"Saved query id(b4fd7c8437201000deeabfc8bcbe5dc1) is not found for 
group(d0d2d25113152200eef2dd828144b0e4)","error":
"SAVED_QUERY_ID_NOT_FOUND"},{"message":
"Saved query id(affd3c8437201000deeabfc8bcbe5dc3) is not found for 
group(d0d2d25113152200eef2dd828144b0e4)","error":"SAVED_QUERY_ID_NOT_FOUND"}]