Home Service Manager Portal Feature Requests
We appreciate you taking the time to vote and add your suggestions to make our products awesome! Your request will be submitted to the community for review and inclusion into the backlog.

We recommend reviewing what is submitted before posting, in case your idea has already been submitted by another community member. If it has been submitted, vote for that existing feature request (by clicking the up arrow) to increase its opportunity of being added to Cireson solutions.

For more information around feature requests in the Cireson Community click here.

Allow Dashboard SQL Widgets to query a database other than ServiceManagement

The Dashboard designer is a great tool for customizing dashboards:  https://support.cireson.com/KnowledgeBase/View/1297#/

However I think it would be useful to be able to configure a SQL Widget to query a database other than ServiceManagement, such as ServiceManager or really anything else.
22 votes

Submitted · Last Updated

Comments

  • Geoff_RossGeoff_Ross Cireson Consultant O.G.
    Hey, do you mean by specifying another connection string as you can do this already as long as the Portal account has permissions to another database and its on the same or a linked SQL server.

    Eg.
    SELECT * FROM [ServiceManager].[dbo].[MT_Microsoft$SystemCenter$BusinessService]
    Geoff
  • David_AllenDavid_Allen Partner Advanced IT Monkey ✭✭✭
    I can verify that what Geoff suggests does work.  I am currently using the SQL widget to return config item data from the ServiceManager database.
    The wording on the widget suggests that it will only query the ServiceManagement database, but you can query any database as long as you specify it in the query.

    I would say that all you need to do is change the wording on the widget :smile:

    David
  • carrie_medinecarrie_medine Member Advanced IT Monkey ✭✭✭
    This feature would allow you to basically save credentials and connection information to any database even if it is not on the same or linked server.
  • David_AllenDavid_Allen Partner Advanced IT Monkey ✭✭✭
    That would be very useful, particularly being able to save alternate credentials to use!
  • David_AllenDavid_Allen Partner Advanced IT Monkey ✭✭✭
    Another point to add here would be that if querying results from other databases, that the by design feature of each returned row of data being auto hyperlinked to search for that item can be switched off. 

    When querying alternate databases, for example config items in the ServiceManager database, the auto hyperlink for each item returned always sends you to the search page with no results found.  While this is expected, as the ServiceManagement DB knows nothing about config items queried from the ServiceManager database, it is not a helpful experience.
  • Geoff_RossGeoff_Ross Cireson Consultant O.G.
    edited April 2020
    Further to @David_Allen's comment above, even better to be able to have the option to specify an alternative URL to link to with configurable parameters using results from the SQL query so you can link to other external systems, bespoke pages, SQL reports...

    eg SELECT EmployeeId, FirstName, LastName, JobTitle FROM [HRDatabase].[Staff]

    and the configure the 1st column to hyperlink to

    https://hrsystem.contoso.com/staff?userid={{EmployeeId}}

This discussion has been closed.