CA Service Management

 View Only
  • 1.  How to use Ms SQL View in Dashboard

    Posted May 22, 2017 06:27 AM

    Dear All,

     

    we are using service catalog 14.1.

    As of now, i able to use the SQL query results in the dashboard.

    but now my query is too long which exceeds the query length limitation(4096 characters).

    i thought of using the SQL query as SQL VIEWS in the dashboard, but it is not working.

     

    whether it is possible??? or else can someone guide me how to use the query to get the results in dashboard.

     

    Thanks in Advance.



  • 2.  Re: How to use Ms SQL View in Dashboard
    Best Answer

    Broadcom Employee
    Posted May 22, 2017 06:56 AM

    Good Afternoon Santosh.
     
    To be able to 'select from a view' in an SC/Admin/Report Builder/Data Object query, check the below:
     
    1. Create a view in the mssql (mdb) database:
    E.G.:
    CREATE view [dbo].[z_order_information] as
    select
    a.request_id,a.name as request_name,
    a.status as request_status,
    a.created_date,a.modified_date,a.completion_date,a.domain,
    a2.account_id,a2.name as account_name,
    a.req_by_user_id,
    a3.first_name,a3.last_name,
    a.req_for_user_id,
    from usm_request a
    join usm_account a2 on a2.account_id=a.req_for_account_id
    join ca_contact a3 on a3.userid=a.req_by_user_id
     
    2. Create a new Data Object in the SC-UI with the query:
    SELECT * FROM Z_order_information
     
    3. Save and Test for the above shold then show the result.
     
    Please check the above. Thanks and kind regards, Louis.