Question: Which table or view contains just the GUID of the SMP server?
search cancel

Question: Which 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

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

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'