Script Include is not trigger for non-itil users

[Lisa Goldman]

Hello,

I have a script includes that query 'alm_asset' table to retrieve asset tag. It's working fine as an admin or ITIL user, but when I impersonate an end user with no roles, no data is returned."

Could someone please help?  Here is the script include for your review.  Thank you

[Lisa Goldman]

Hi @Swamy Malluri 

This is how you would add a log in the script include? After adding gs.log, login as the user, then run it is that right?

getDetails: function() {

        gs.log("Start");

        var arr = [];

        var sysId = this.getParameter('sysparm_sysId');

        var gr = new GlideRecord('alm_asset');

        gr.addQuery('assigned_to', sysId);

        gr.addQuery('asset_tag', '!=', '');

        gr.query();

        while (gr.next()) {

            arr.push(gr.asset_tag.toString());

        }

        if (arr.length >= 2)

            return arr.toString();

      //  else

        //    return '';

    },

    type: 'getAssetTag'

});

[Swamy Malluri]

Hi @Lisa Goldman ,

Try adding more logs and see what result you are getting. And make sure you have valid asset assigned to logged in user in Asset table. 

getDetails: function() {

        gs.log("Start");

        var arr = [];

        var sysId = this.getParameter('sysparm_sysId');

        var gr = new GlideRecord('alm_asset');

        gr.addQuery('assigned_to', sysId);

        gr.addQuery('asset_tag', '!=', '');

        gr.query();

    gs.log("Query "+ gr.getEncodedQuery());

        while (gr.next()) {

            arr.push(gr.asset_tag.toString());

        }

gs.log("array is "+ arr);

gs.log("arr length "+ arr.length);

        if (arr.length >= 2)

            return arr.toString();

       else

         return '';

    },

    type: 'getAssetTag'

});

Thanks,

Swamy Malluri

[Ankur Bawiskar]

@Lisa Goldman 

Please add the isPublic function so that it works for end user with no roles

I included this function inside the script include

isPublic:function(){
return true;
},

var getAssetTag = Class.create();
getAssetTag.prototype = Object.extendsObject(AbstractAjaxProcessor, {

isPublic:function(){
return true;
},

getDetails: function() {
var arr = [];
var sysId = this.getParameter('sysparm_sysId');
var gr = new GlideRecord('alm_asset');
gr.addQuery('assigned_to', sysId);
gr.addQuery('asset_tag', '!=', '');
gr.query();
while (gr.next()) {
arr.push(gr.asset_tag.toString());
}
if (arr.length >= 2)
return arr.toString();
// else
// return '';
},

type: 'getAssetTag'
});

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Lisa Goldman]

Thank you @Ankur Bawiskar 

I would like to try what you have suggested, but encountering an error in the code:

[Ankur Bawiskar · Accepted solution]

@Lisa Goldman 

it should be simply this

var getAssetTag = Class.create();
getAssetTag.prototype = Object.extendsObject(AbstractAjaxProcessor, {

 

isPublic:function(){
return true;
},

getDetails: function() {
var arr = [];
var sysId = this.getParameter('sysparm_sysId');
var gr = new GlideRecord('alm_asset');
gr.addQuery('assigned_to', sysId);
gr.addQuery('asset_tag', '!=', '');
gr.query();
while (gr.next()) {
arr.push(gr.asset_tag.toString());
}
if (arr.length >= 2)
return arr.toString();
// else
// return '';
},

type: 'getAssetTag'
});