scenarios: Need to glide a table, print the records and get into a Excel sheet using a Background script

We definitely come across such requirements often, following the below steps would help

1) Create a Background script, print a column and rows using a seperator |

dpfracus();function dpfracus(){ try{

gs.print('Assignment group'+'|'+'User'+'|'+'Has DP Fracas role (Yes/No)'+'|'+'Is DP Fracas revoked (Yes/No)'); //Table Header

var gr = new GlideRecord('sys_user_grmember'); gr.addEncodedQuery('group.typeLIKE6883ac7b4f385a006ce8bc718110c7b1'); gr.query(); while(gr.next()){

gs.print(gr.group.getDisplayValue() +'|'+gr.user.getDisplayValue()+'|'+userroles1(gr.user)+'|'+revokedroles(gr.user)); //Prints the row using a seperator |

} }catch(e){ gs.log("Exception Occured :"+e,'>>>BackgroundScript<<<'); }}function userroles1(userrole){ var gr1 = new GlideRecord('sys_user_has_role'); gr1.addEncodedQuery('user='+userrole+'role=31df7d154f41da006ce8bc718110c739'); gr1.query(); if(gr1.next()){ return 'Yes'; }else{ return 'No'; }}function revokedroles(userrevoked){ var gr2 = new GlideRecord('u_revoked_roles'); gr2.addEncodedQuery('u_user='+userrevoked+'u_status=activeu_user_role=DP Fracas'); gr2.query(); if(gr2.next()){ return 'Yes'; }else{ return 'No'; }

}

2) Output

3) Copy all the script and paste it in Notepad ++ [remove ***script ] use ctrl+F andcopy the text, replace all

4) Now open the excel sheet --> Data - From text

Please mark the blog as helpful and Bookmark..!!!

Regards,

Chalan

Labels: