Support Center

Retrieving Server Information

Last Updated: Mar 30, 2016 12:13PM CDT

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.

556ca399015f31edc97a62de2771be1a@minionware.desk-mail.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete