How to create a ServiceNow report which fetches data from multiple tables.

แชร์
ฝัง
  • เผยแพร่เมื่อ 14 ธ.ค. 2024

ความคิดเห็น • 10

  • @shrijara3054
    @shrijara3054 17 วันที่ผ่านมา

    Thank you for the short and clear video. Request you to please create more content like this.

    • @nowgambit
      @nowgambit  17 วันที่ผ่านมา

      Thank you so much for your kind comment!

  • @yaro137
    @yaro137 6 หลายเดือนก่อน +2

    This is very nice and helped better undestand fow the fields are created. If only there was a way to see where exactly a particular field visible in a SNOW RITM,INC,REQ,TASK etc. came from in the first place would make life much easier for creating reports.

    • @nowgambit
      @nowgambit  6 หลายเดือนก่อน

      Thank you, If you were looking at a particular form and wondering where the fields on that form are coming from then you can download a Chrome plugin called SN_Utils and that will give you the column names of every field on the screen.There is an option on top to see which table that column belongs to.

  • @MrJuniorcandido
    @MrJuniorcandido หลายเดือนก่อน

    nice video.. Its seems simple.. but I´m not able to join INC and RITM tables in the same report. I want to create a chart showing total tickets per year to specific assigment group..

    • @nowgambit
      @nowgambit  หลายเดือนก่อน

      The incident table normally has the assignment group column in it. Is that field empty for you? You shouldn’t need to join two tables for this report.

  • @shravanthiy6346
    @shravanthiy6346 2 หลายเดือนก่อน

    Do u have any idea about tracking and reporting on dashboard usage module

    • @nowgambit
      @nowgambit  2 หลายเดือนก่อน

      Are you talking about this in particular? I don't have experience in using this, or were you talking about measuring usage in general? developer.servicenow.com/dev.do#!/reference/next-experience/xanadu/shared-components/sn-dashboard/usage

  • @eduardemilmarcaida2441
    @eduardemilmarcaida2441 19 วันที่ผ่านมา

    How to add if some columns/fields are not available in the base table?

    • @nowgambit
      @nowgambit  19 วันที่ผ่านมา

      Those columns which are not available in the base table should be available in any of the reference tables. So, in our example above you see that the green column names are green with a little plus icon. You should see something similar, and should be able to add columns in another table that is referenced from your base table.