Topic
2 replies Latest Post - ‏2013-09-12T18:07:45Z by Kabutox
Kabutox
Kabutox
2 Posts
ACCEPTED ANSWER

Pinned topic Making a report from 1 DB in a server with diferents DB's

‏2013-09-11T21:26:13Z |

Hi all,

i'm traying to do a report from a server wich have 3 diferents data bases. so, how do i pick only 1 intance wich correspond to 1 DB for does the report. i'm not sure what kind of DB's are those (win, linux...) so if you can explain me the procedures for all these i'll be grateful with you.

cheers..

  • Muris
    Muris
    45 Posts
    ACCEPTED ANSWER

    Re: Making a report from 1 DB in a server with diferents DB's

    ‏2013-09-12T07:26:47Z  in response to Kabutox

    Hi,

    Don't know if I undestood you correctly... All in all, you can create report with ServerIP attribute in condition and then add Server Type attribute as field from Client/Server entity. Then you can clone/combine reports if you have different DB types on single server (MySQL, MSSQL, Oracle...) just placing Server type condition...

    Regards,

  • Kabutox
    Kabutox
    2 Posts
    ACCEPTED ANSWER

    Re: Making a report from 1 DB in a server with diferents DB's

    ‏2013-09-12T18:07:45Z  in response to Kabutox

    Thanks for answer.

    Next i copy the answer i was looking for, this is in spanish. ;)

     

    se debe filtrar por el campo 'database name' en el caso de MSSQL y 'service name' en el caso de las demás BD. Dependiendo del objetivo del reporte puedes usar como 'main entity'   session start ó object.

    Ingresa a la creación de reportes <'Monitor/Audit'/Build Reports > pulsa sobre Tracking Access

    Selecciona New  y query name: Reporte de actividades por DB; main entity: session start.