Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Task marked complete

...

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  
  •  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)

...