ITSM Coach

How did it get here?

This is the initial update set to create application and modules:

https://yaledevelopment.service-now.com/nav_to.do?uri=sys_update_set.do?sys_id=00942b8a2b9f6840fde6a4bc59da1587

How does it work within ServiceNow?

The user side of this is just embedded pages from ITSMCoach.  Basically we pass some parameters to the itsmcoach page and then display it in the ServiceNow frame.  Here's the ui page where that's done.

Where is it getting data from?

ITSMCoach pulls data via s_csi user.  This user actually appears to have some roles which allow it to update tables, so this might be worth looking into as well.

s_csi has 3 roles.  csi_readonly grants read only access to 13 elements.  A report is attached here : csi_readonly.pdf.

How often is it getting data?

 According to the system logs, that user is coming in once a day a little after 5AM and pulling data via SOAP.  Here's a sampling of a few days of activity : s_csi_syslog_transaction.xls

How do people get access to the "application"

  1. Grant the user(s) the itsm_coach_user role
  2. A job at itsmcoach runs everyday at 5 am EST which gets that users from Yale's ServiceNow production instance and grants them permission at itsmcoach.

 

Todo

  • Determine the frequency in which reports are pulled?  
  • Are they deltas only?
  • Examine the permissions that this user has, it seems like it has too much power.  Specifically itsm_coach_user. 
    • After looking at this further it appears that it only has read only access to some fields.
  • Figure out if the update set was provided by someone, or if it was home-grown.
  • Get some access for myself, Dan Franko (Unlicensed)