Modules > Asset Management > Client Operations - Workstation Data Assistant > Modules > ESI Server Scanner > Task Parameters > Generated SQL Server Instance Name Format

Applies to SQL Server discovery ONLY.

As machines with SQL Server Instances are discovered, they are sent to the MIE, where the next consolidate run will bring the discovered information into the list of unassigned aliases, where they can be managed using Recognition Training on the MIE. The format of the generated SQL Server Instance aliases to be trained is as follows:

If the use host name task parameter is /useHostName:n then the computer name is not included in the generated SQL Server Instance alias, .e.g.:

InstanceID|SkuName|SqlServiceName|Version|FileVersion

Including the computer name as part of the alias allows more granular recognition training to be performed. This is useful when wanting to use recognition training to assign the correct metric to any given machine. For example, one set of servers may be assigned (through rogue authorization) SQL Server by processor or core and another group of servers may be assigned the same edition and version, however by server/CAL (two different metrics). The trade-off is additional recognition training since each instance will report a unique alias. If you do not wish to managed the assignment of authorizations to the individual machine, then use this parameter to turn off the default behavior and aliases will be reported without the machine name.