Adding Additional Tables to ServiceManagement Databsase

David_AllenDavid_Allen Partner Advanced IT Monkey ✭✭✭
edited November 2016 in Analyst Portal
If I added a couple of additional tables to the ServiceManagement database where I can calculate and store data for dashboards, would this be supported, and would they get wiped on upgrade?

Similarly, same questions in regards to adding Views?

Thanks,
David

Best Answers

  • Brett_MoffettBrett_Moffett Super IT Monkey ✭✭✭✭✭
    Accepted Answer
    Adding views is supported and would be carried over with any upgrade.
    Adding new tables would be hit and miss. We can not guarantee that we will not overwrite tables we don't expect to be there.

    What tables are you wanting to add for reporting?
    Is it worth adding it as a feature request?

Answers

  • Brett_MoffettBrett_Moffett Cireson PACE Super IT Monkey ✭✭✭✭✭
    Accepted Answer
    Adding views is supported and would be carried over with any upgrade.
    Adding new tables would be hit and miss. We can not guarantee that we will not overwrite tables we don't expect to be there.

    What tables are you wanting to add for reporting?
    Is it worth adding it as a feature request?
  • David_AllenDavid_Allen Partner Advanced IT Monkey ✭✭✭

    I will be adding as a feature request, however had to ask the question as we need certain dashboard reports sooner rather than later.  Tanks for the info regarding the views, very good to know :-)

  • David_AllenDavid_Allen Partner Advanced IT Monkey ✭✭✭
    Thanks for the clarification Seth, I now have a clear way forward!

    The one issue I have noticed at present when using the SQL Table Widget to return data from other databases is that each row because a link to Search, which obviously it can't find a match on as I'm pulling from another DB.  Is it possible to remove this hyperlinking behaviour when querying a DB other than ServiceManagement?
Sign In or Register to comment.