asimpkin

<?
require_once('class.Record.php');
require_once('Class.SoapClient.php');

/* 
# Happy Kitty
$clientOptions = array(
        'login' => 'admin',
        'password' => 'admin',
        'instance' => 'demo013',

asimpkin

<?php
include("../common.inc.php"); // Contains definitions for INSTANCE, USER, PASS

$query=urlencode('active=true^stateNOT IN6,^priorityIN1,2'); // Active, NOT Resolved, Hi Priority INC

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'https://'.INSTANCE.'.service-now.com/incident_list.do?XML&useUnloadFormat=true&sysparm_query='.$query);
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);

asimpkin

<?php
include('../common.inc.php'); // Contains defintions for INSTANCE, USER, PASS

//////////////////////////////////
// GET THE RACK FROM sys_id in URL
$q='sys_id='.$_GET[sys_id];
$query=urlencode($q);

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'https://'.INSTANCE.'.service-now.com/cmdb_ci_rack_list.do?XML&useUnloadFormat=true&sysparm_query='.$query);

asimpkin

<?xml version="1.0" encoding="utf-8" ?>
<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">

<g:ui_form>
<input type="hidden" name="sysparm_task_id" value="${sysparm_task_id}" />
<input type="hidden" name="sysparm_task_number" value="${sysparm_task_number}" />
<input type="hidden" name="issue_type_id" value="1" />
<h1>Creating Jira Bug from ${sysparm_task_number}</h1>

<g:evaluate>

asimpkin

function Waiting() {
   
   var x = document.getElementById('short_description').value ;
   if (x==null || x=="")   {
      alert("Short Description - Required");
      return false;
   }
   var y = document.getElementById('description').value ;
   if (y==null || y=="")   {
      alert("Detailed Description - Required");

asimpkin

// CREATE JIRA ISSUE
var r = new RESTMessage('Jira - Issue', 'post') ;
r.setStringParameter('description', description ) ;
r.setStringParameter('issue_type_id', issue_type_id ) ; // BUG
r.setStringParameter('sysparm_task_id' , sysparm_task_id ) ; // ServiceNow Task # in Jira
r.setStringParameter('sysparm_task_number' , sysparm_task_number ) ; // ServiceNow Task # in Jira
r.setStringParameter('sysparm_task_url' , 'https://[INSTANCE].service-now.com/nav_to.do?uri=task.do?sys_id=' + sysparm_task_id ) ; // ServiceNow URL in Jira
r.setStringParameter('project_id', project_id ) ;
r.setStringParameter('short_description', short_description ) ;
r.setStringParameter('issue_severity', issue_severity ); 

asimpkin

<?xml version="1.0" encoding="utf-8" ?>    
<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">    

<!-- This script include is required for DUBLIN and later - Simon Morris -->
<script language="javascript" src="/scripts/prototype-adapter.jsx" />   

<!-- This script include is required for EUREKA and later - Jay Ford -->
<script language="javascript" src="/scripts/GlideV2ChartingIncludes.jsx" />   

asimpkin

<?xml version="1.0" encoding="utf-8" ?>    
<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">    
<script language="javascript" src="/scripts/prototype-adapter.jsx" />   
<script language="javascript" src="/scripts/GlideV2ChartingIncludes.jsx" />   
<script>  
document.observe("dom:loaded", function() {    
    var chart1 = new Highcharts.Chart({    
        chart: {
            renderTo: 'newchart',
            type: 'bubble',

asimpkin

<?xml version="1.0" encoding="utf-8" ?>
<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">

<g:evaluate>
    var R = new GlideRecord('grc_risk');
    R.orderBy('likelihood.weighting');
    R.query();
</g:evaluate>

<h1>Inherent Risk Summary</h1>

asimpkin

<?php
include("../common.inc.php");

start_page("Linux Servers without Provides Production For :: Applications");

// get stuff
$arr = getXML('cmdb_ci_linux_server','operational_status=1');

// query for a production relationship where the parent is the application
foreach($arr as $k => $v) {