SQL table or View that contains just the GUID of the SMP server

Products

• IT Management Suite

Issue/Introduction

You may have a situation in which you do not know the name of the SMP server, or, you're looking to create a top-level report when the name of the SMP is not always the same.  In this situation, you would like to query a table or view that would contain the GUID of the SMP server, without passing in the name of it. So, which SQL table or view contains just the GUID of the SMP server?

Environment

ITMS 8.x

Resolution

The requested SQL Table is ServerSettingGuids and you can run this query:  select * from ServerSettingGuids where Name = 'NSResourceGuid'