æ¿èªãæ»çãããªãããã®éçšèšèšæžïŒsysapproval_approverã®ç¶æ èšèšãšå§ä»»
æ¿èªã®äžèЧã state ã§çµã蟌ãã§ã¿ããšãããRequested ã®ãŸãŸæ¢ãŸã£ãŠããã¬ã³ãŒããååãè¶
ããŠããŸããã確èªã§ãã771ä»¶ã®ãã¡390ä»¶ãå²åã«ããŠ50.6%ã§ããæ¿èªãŸã§é²ãã ã®ã¯77ä»¶ã察ããŠåŽäžã¯ããã2ä»¶ã§ãããå·®ã¯æŽç¶ã§ãã
ãã®æ°åã ããèŠããšãæ¿èªã圢ã ãã«ãªã£ãŠããããšèããããªããŸãããããåå ãæ¿èªæ©èœãã®ãã®ã«æ±ããã®ã¯æ©èšã§ããæ¿èªãšããä»çµã¿èªäœãå£ããŠããã®ã§ã¯ãªããç¶æ ãã©ãèšèšããã©ãæ€ç¥ããããšããéçšåŽã®èšèšãæããŠãã宿 ãèŠããŠããŸãã
ãã®èšäºã§åããããš
æ¿èªã¬ã³ãŒãïŒsysapproval_approverïŒã®ä»çµã¿ãš state ã®æå³ããå ¬åŒããã¥ã¡ã³ãã®å®çŸ©ãš PDI ã®å®æ©ç»é¢ã®äž¡æ¹ã§ç¢ºèªããå 容
æ¿èªã¬ã³ãŒãã®ååè¿ãã Requested ã®ãŸãŸæ¢ãŸã£ãŠãã宿ž¬ãšãç¶æ ã sysapproval_approver ãš change_request ã®2ãæã«åãããŠããŠçæ¹ã ãã§ã¯èªã¿éããããš
æ¿èªè ãã人ãã§åºå®ããã圹å²ã»ã°ã«ãŒããã§æ±ºããèšèšãšãäžåšæã®å§ä»»ïŒsys_user_delegateïŒã®èšèšæ¡
æ»çãæ€ç¥ããŠãšã¹ã«ã¬ãŒã·ã§ã³ããä»çµã¿ãšãåŽäžãã»ãŒ0ä»¶ãšããçµæãã©ãèšèšã«åæ ããã
ãã®èšäºã¯ãServiceNow ã® PDIïŒPersonal Developer Instanceãç¡æã®å人æ€èšŒç°å¢ïŒã§æ¿èªãŸããã®ããŒãã«ã宿©ç¢ºèªããå 容ã«ããšã¥ããŸããä»¶æ°ã¯ç¢ºèªããæç¹ã®ãã®ã§ãããæ¬çªç°å¢ãèªç€Ÿå°å ¥åŸã®ç¶æ³ãšã¯ç°ãªããŸãã
æ¿èªãšããä»çµã¿ã®åºæ¬ïŒå ¬åŒããã¥ã¡ã³ãããïŒ
ServiceNow ã®æ¿èªã¯ãChange Request ãã«ã¿ãã°ç³è«ãªã©ã®å¯Ÿè±¡ã¬ã³ãŒãã«ã€ããŠãå ã«é²ããŠãããããæ¿èªè ã«åãåãããä»çµã¿ã§ããå ¬åŒããã¥ã¡ã³ãã® Classic approvals ã§ã¯ãæ¿èªã誰ã«å¯ŸããŠçºçããã©ããªç¶æ ãçµãŠå®äºããããšããåºæ¬ã®èãæ¹ã説æãããŠããŸããæ¿èªããã€ã»èª°ã«æ±ããããšããæ¡ä»¶ã¯ Approval rules ãæ åœããé åã§ãã
æ¿èªã¬ã³ãŒããšå¯Ÿè±¡ã¬ã³ãŒãã®é¢ä¿
æ¿èªã®å®äœã¯å¯Ÿè±¡ã¬ã³ãŒãã®å éšã«ã¯ãããŸãããå°çšã®ããŒãã« sysapproval_approver ã«ã1äººã®æ¿èªè ã«ã€ã1ã¬ã³ãŒããšããŠä¿åãããŸããæ¿èªè ã3äººå¿ èŠãªå€æŽèŠæ±ãªããsysapproval_approver ã«3è¡ãäœãããæ§æã§ãããã®çæãæ ãã®ããFlow Designer ã® Ask for Approval action ããã¯ãŒã¯ãããŒæä»£ã® Approval - Group workflow activity ã§ããã©ã¡ããæ¿èªè ã確å®ããæ¿èªã¬ã³ãŒããäœã圹å²ãæã¡ãŸãã
æ¿èªå¯Ÿè±¡ã®åŽã«ããæ¿èªã®ç¶æ ãæ ããã£ãŒã«ããçšæãããŠããŸããchange_request ã§ããã° approval ãšããé ç®ã§ãæ¿èªãã©ããŸã§é²ãã ãã衚ããŸããæ¿èªè ããšã®è©³çްãæã€ sysapproval_approver ãšã察象ã¬ã³ãŒãåŽã«èŠçŽããã approval ã¯å¥ã®ãã£ãŒã«ãã§ãããã®2ã€ãã©ãããããã¯ãææãšãªã¢ã§å®æ©ã®æ°åãçªãåãããŠç¢ºèªããŸãã
state ã瀺ã7ã€ã®ç¶æ ïŒå ¬åŒã®å®çŸ©ïŒ
sysapproval_approver.state ã®éžæè¢ã¯7ã€ãããŸããåºæ¬ã®æå³ã¯æ¬¡ã®ãšããã§ãã
Not Yet Requested âŠ è€æ°æ¿èªè ã«é çªãããå Žåãªã©ããŸã èªåã®çªãåã£ãŠããŠããªãç¶æ
Requested ⊠æ¿èªè ã«å€æãæ±ããŠããç¶æ ãæ¿èªåŸ ã¡ã®äžå¿ã«ãããå€
Approved ⊠æ¿èªè ãæ¿èªããç¶æ
Rejected ⊠æ¿èªè ãåŽäžããç¶æ
Cancelled ⊠æ¿èªå¯Ÿè±¡ã®ã¬ã³ãŒãèªäœãåãæ¶ããã倿ãã®ãã®ãè¡ãããªãã£ãç¶æ
No Longer Required ⊠ã°ã«ãŒãæ¿èªãªã©ã§ä»ã®æ¿èªè ã®å€æã«ãããèªåã®æ¿èªãäžèŠã«ãªã£ãç¶æ
Not Entitled ⊠æ¿èªã¬ã³ãŒããäœãããåŸãæš©éãæ¡ä»¶ã®å€åã§æ¿èªè ãšããŠã®è³æ Œã倱ã£ãç¶æ
7ã€ã®ãã¡ãæ¥åžžã®æ¿èªæ¥åã§ããåãã®ã¯ Requestedã»Approvedã»Rejectedã»No Longer Required ã®4ã€ã§ããæ®ã3ã€ãå®éã«ã©ããªå Žé¢ã§ä»ãã®ãã¯ã宿©ã®éžæè¢å®çŸ©ãšããããŠææãšãªã¢ã§èŠãŸãã
宿©ã§ç¢ºãããçŸç¶ïŒæ¿èªã®ååããRequestedãã®ãŸãŸ
ããããã¯ãPDI ã§å®éã«ç¢ºèªããç»é¢ã§ããsysapproval_approver ã State ã§ã°ã«ãŒãåãããšã次ã®ããã«åãããŠããŸããã

771ä»¶ã®å èš³ãå²åã§æŽçãããšã次ã®ãšããã§ãã

æå€ã¯ Requested ã®390ä»¶ã§ãå šäœã®50.6%ãå ããŸããæ¬¡ã«å€ãã®ã No Longer Required ã®302ä»¶ïŒ39.2%ïŒã§ãããã®å€ã¯ãã°ã«ãŒãæ¿èªã§èª°ããå ã«å€æããããèªåã®åãäžèŠã«ãªã£ããšãã«ä»ãå€ã§ãåç¬ã§ã¯æ»çãæå³ããŸãããæ¿èªãŸã§é²ãã ã®ã¯ Approved ã®77ä»¶ïŒ10.0%ïŒãåŽäžã¯ Rejected ã®2ä»¶ïŒ0.3%ïŒã«ãšã©ãŸããŸãã
åŽäžã¯ã»ãšãã©çºçããŠããªã
倿ãã€ãã79ä»¶ïŒApproved 77ä»¶ïŒRejected 2ä»¶ïŒã®ãã¡ãåŽäžã®å²åã¯2.5%ã§ããæ¿èªããã»ã¹ãéã£ããã®ã®ã»ãšãã©ãæçµçã«éã£ãŠããèšç®ã«ãªããŸãããããå®åãšããŠåŠ¥åœãªæ°åãªã®ãããããšãæ¿èªã倿ã®å ŽãšããŠæ©èœããŠããªããµã€ã³ãªã®ãã¯ãä»¶æ°ã ãã§ã¯å€æã§ããŸããããã®è§£éã¯ææãšãªã¢ã®èšèšæ¡ã§æ±ããŸãã
ãªããNot Yet Requestedã»Cancelledã»Not Entitled ã®3å€ã¯ä»åã®éèšã§0ä»¶ã§ãããæ¿èªé åºããŸã åã£ãŠããŠããªãã察象ã¬ã³ãŒããåãæ¶ããããæ¿èªè ã®æš©éã倱ãããããšãã£ãæäœãä»åã®ããŒã¿ã§ã¯çºçããŠããªãããšã«ãªããŸããããããæäœèªäœãèµ·ããŠããªãã®ããå¥ã®çç±ãããã®ãã¯ããã®äžèЧã ãã§ã¯åãåããããŸããã
æ¿èªã¯ã©ãã«éäžããŠãããïŒå¯Ÿè±¡ããŒãã«å¥ïŒ
æ¿èªãã©ã®ããŒãã«ã«å¯Ÿãããã®ãã Source table ã§ã°ã«ãŒãåãããšãå èš³ã¯ã¯ã£ããåã£ãŠããŸãã


change_request ã750ä»¶ã§å šäœã®97%以äžãå ããæ®ãã¯æšæºå€æŽææ¡ã»Service Catalog ã®ç³è«ã»ãã¬ããžèšäºã®å ¬éæ¿èªãªã©ã«æ£ãã°ã£ãŠããŸããæ¿èªã®å®æ ãèªãããã§ãchange_request ãã©ãèŠãããèŠã«ãªããŸãã
ãã€ããã®æ»çã
Requested ã®ãŸãŸæ®ã£ãŠããæ¿èªãäœææ¥ã®å€ãé ã«äžŠã¹ããšã次ã®ããã«è¡šç€ºãããŸãã

æãå€ãè¡ã®äœææ¥ã¯2023-06-24ã§ããäœææ¥ãšçµéãæŽçãããšã次ã®ãšããã§ãã

察象ããŒãã«ãèšé²ãããŠããªãå€ãã¬ã³ãŒã3ä»¶ãšãchange_request åãã®7ä»¶ãã確èªã§ããç¯å²ã§ãã£ãšãæ»çæéã®é·ãã°ã«ãŒãã§ããæ€èšŒæ¥ããèŠãŠçŽ3幎ãçµéããŠããŸãããã®æéãæ¿èªè ãäžåšã§ã代ããã«åŠçã§ããä»çµã¿ãåãã圢跡ã¯ãããŸãããå§ä»»ã®èšå®ãã®ãã®ã0ä»¶ã ããã§ãã代ããã¯ããŸããã
ããã§äžã€æã£ãŠãããŸãããã£ãšãå€ãæ»çãPDIã®ããŒã¿ã§ããããšãèžãŸãããšããããå®éã®æ¥åæŸçœ®ãªã®ããæ€èšŒçšã«æå ¥ããããã¢ããŒã¿ã®æ¥ä»ãªã®ãã¯ããã®ç¢ºèªã ãã§ã¯åºå¥ã§ããŸãããèªç€Ÿã®ç°å¢ã§åã確èªããããšãã¯ããã®å€ãã®ååžããã®ãŸãŸæ¥åäžã®åé¡ã瀺ããŠããåæã§èªãŸãããŸãæ¯éå£ã®æ§è³ªã確èªãããšããããå§ããå¿ èŠããããŸãã
ð° âââââ ããããå ã¯ææãšãªã¢ïŒÂ¥300ïŒâââââ
ããããå ã¯ã宿ž¬ããããã¹ãå§¿ã®èšèšãã«èœãšã蟌ã¿ãŸããæ¿èªè ã人ã§ã¯ãªã圹å²ã»ã°ã«ãŒãã§æ±ºããèšèšã
äžåšæã®å§ä»»ãã©ãçµãããæ»çãæ€ç¥ããŠãšã¹ã«ã¬ãŒã·ã§ã³ããä»çµã¿ããããŠåŽäžãã»ãŒ0ä»¶ãšããçµæã
ã©ãèšèšå€æã«åæ ããããæ¿èªã®ç¶æ ã2ãæã«åãããçç±ãšãstate 7çš®ã®äœ¿ãåããããããŠæ±ããŸãã