Question: Which table or view contains just the GUID of the SMP server?
Situation:
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.
Resolution:
You can run the following query to find this information: select * from ServerSettingGuids where Name = 'NSResourceGuid'