Report for Solman

[Former Member]

Hi Expert,

I have problem about report of Solution manager.

I need a report solman that can breakdown ticket number by user status.

the data may can display like this.

Ticket No          create on      user Status

12345               1/1/2012 06:00:00       open

12345               1/1/2012 07:00:00       in Process

12345                1/1/2012 07.30:00      Confirmed to customer

etc.

Thanks before. i hope some one can suggest some solution

[Former Member · Accepted solution]

hi,

Just goto solar_Eval -> service desk -> Extended selection -> status analysis

Thanks

Jansi

[Former Member · Accepted solution]

Hi,

the above displyyou can get in crmd_jest, crmd_jcds tables. create one z report based on this.

Thanks

Jansi

[Former Member · Accepted solution]

hi ,

Thanks for your comment. i'm trying to see the tables but the tables does not exist.

i see in SE14, SE11 and the table does not exist.

Thanks

[Former Member · Accepted solution]

hi

try with crm_jcds, crm_jest

Thanks

Jansi

[Former Member]

Hi Mas,

You can make use of the transaction code CRM_DNO_MONITOR and if you are using transaction type SLFN for your incident tickets, you can put it in the field 'transaction type'.

For Solman 7.1, You need to do this from workcenter.

Thanks,

Jagadish.

[Former Member]

Thanks for your response

but i still cannot breakdown 1 ticket number by user status

i want to display 1 ticket no to be more than 1 record in CRM_DNO_MONITOR according to user status changed.

the data may display like this

Ticket No          create on                        Change On                                                          user Status

12345               1/1/2012 06:00:00          1/1/2012 06:00:00                                               open

12345               1/1/2012 06:00:00         1/1/2012 07:00:00                                                in Process

12345                1/1/2012 06.00:00         1/1/2012 07.30:00                                               Confirmed to customer

for more information, i'm using solman 7.0 dan transaction type "SLFN"

Thanks.