search cancel

Question: What table or view contains just the GUID of the SMP server

book

Article ID: 151057

calendar_today

Updated On:

Products

IT Management Suite

Issue/Introduction

 

Resolution

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'