Minion Enterprise provides stored procedures and views to help you find pertinent information. Two of these stored procedures are Servers.ByName and Servers.ByID.

Search using Servers.ByName

The Servers.ByName procedure allows you to search for servers by name. To search for a specific server name – for example, “YourServer” – execute the procedure with the @ServerName parameter:

EXEC [Servers].[ByName] 'YourServer';

To search for a partial name – for example, any server with “Your” in the name – execute the procedure with the @ServerName and @Fuzzy parameters:

EXEC [Servers].[ByName] 'Your', 1;

In either case, the procedure will return a great amount of data for YourServer, including application information (if any), InstanceID, IP and port, service level, and other collected and configured data.

Search using Servers.ByID

The Servers.ByID procedure allows you to search for servers by instance ID. To search for a server by ID, execute the procedure with the @InstanceID parameter:

EXEC [Servers].[ByID] @InstanceID = 2;

The procedure will return a great amount of data for the server with InstanceID=2, including application information (if any), InstanceID, IP and port, service level, and other collected and configured data.