SymphonyAI Enterprise IT SymphonyAI Enterprise IT

Replies posted by westbem

2 Replies

W
Voyager
westbemVoyager
asked in Forum

"Unauthorized" or "Unapproved" Changes

@jason.yeary Yes we have considered this although we also want to know if a change was “fully imlemented” for example.   We may end up using this field and adding several additional options like “Fully Implemented - Unauthorized”, “Partially Implemented - Unathorized” etc.  in addition to the standard values in that field. Thanks for the response.

2
W
Voyager
1 year ago
W
Voyager
westbemVoyager
asked in Forum

Reporting DataSource that stores the "Proposed Standard Template Status" on the Change form

@Rajini.kanth thank you for the response.  I was not able to find “STANDARD CHANGE TEMPLATE LIST” table within standard reports, so I’ve used the Admin > Report Builder and was able to Join the Change_Request_Master table with the Change_Request_Master_Template table and pull in the “ACTIVE” column from that template table, with the assumption that if ACTIVE=TRUE, those are Approved templates.  Any record with a “blank” in the ACTIVE column is either Rejected or not full thru the process.  Here is the join details:Select a.Change_Request_Id, d.AttributeValue, a.Request_Registration_Time, a.Status, a.Classification, a.Requestor_Id, a.Owner_Workgroup_Id, a.Risk_Id, a.Planned_Start_Time, a.Planned_End_Time, a.Is_ChangeSucessful, a.ProposedTemplateName, b.ACTIVE [Approved] from CM_Change_Request_Master_Syn a WITH (NOLOCK) inner join CM_CustomAttributes_Details_Syn d WITH (NOLOCK) on a.change_Request_ID=d.Change_Request_Id and d.AttributeID=67 left join CM_Change_Request_Master_Template

3
R
New Comer
1 year ago

Badge winners

Show all badges
Terms & ConditionsCookie settings
© Copyright 2024, SymphonyAI Enterprise IT. All Rights Reserved