hello ladies and gentlemen welcome back to servicenow 911 in today's video we are discussing something good because I am showing you a way by which you can access the audit table as well as the channel input table in a very easy way let me show you the tables first of all uh this is the channel table you know what I see Channel field table right whenever you write something in the work note it will get stored in the sys Channel table and this table is very very huge so when you open this table directly by dot list it will take a lot of time and if you did it in business hours it will hamper the performance in anyways so let me open that table first this is demo so it will not take much time so at present it is only having two to two records but in general you can go and check in your instance okay I am not lying here so let's go to incident let me open this incident so now let me add the work notes here okay testing at 9 11 20 22 okay so now the situation arises when I want to update this comment I cannot see it here I see the activity but I cannot update it here so I have to go to the table so for that I have to open the table but again I told you it's a very risky thing so there is a very simple thing which you can do I have the syntax here this is the basic syntax which you have to follow just copy this syntax this is basically the URL paste the URL here okay so now provide your instance name my instance name is this and then at the end after element ID equal to this is the C side of the record in which you have the comment so I have the comment in this particular incident right so I just copy this particular CS ID paste it here I'm done press enter so these are all the entries in the sys Channel field which you can see for that record so this is my comment right I can easily update that double click okay done so if you use this approach it will not hamper the performance because it is not now navigate all the records it will navigate to the record which you have specified as simple as that in the same way we have the query for audit table as well and audit table also is a one of the huge table and again it will impact the performance like anything so now let me copy this let me check paste it just update the name right this is the complete name and update the Society of this record just remember the syntax of this URL this is audit dot list then this is Forum query equal to document key equal to this right this ID here we have element ID equal to C set so you have to remember this enter so these all are the six audit records with respect to only this incident in demo so in demo it has 43 remember what will happen when it is there in your instance that is production and huge number of incident records and other task records are there so I think you have understood what I'm trying to say if you want your customer to be happy and do not bug you okay what you have done my instance is very slow so you can use these type of tricks I have a specified all this in my website servicenow spectacular so you can open that article I'll show you here best way to delete comment and work notes so this is not me this is not you it can be anyone who just opens this audit table dot list okay so all the steps are there you can copy the syntax directly from here and use it same goes for audit history okay so I hope you understand this concept I hope you like my video subscribe to the channel and just spread this across okay and let the people know okay this is a trick thank you so much bye bye