public static void Refresh()
{
_instances.Clear();
var tcpTable = ManagedIpHelper.GetExtendedTcpTable();
foreach (var proc in Process.GetProcessesByName("msmdsrv"))
{
int _port = 0;
LocalInstanceType _icon = LocalInstanceType.PowerBI;
var parent = proc.GetParent();
// exit here if the parent == "services" then this is a SSAS instance
if (parent.ProcessName.Equals("services", StringComparison.OrdinalIgnoreCase))
{
continue;
}
// if the process was launched from Visual Studio change the icon
if (parent.ProcessName == "devenv")
{
_icon = LocalInstanceType.Devenv;
}
// get the window title so that we can parse out the file name
var parentTitle = parent.MainWindowTitle;
if (parentTitle.Length == 0)
{
// for minimized windows we need to use some Win32 api calls to get the title
parentTitle = GetWindowTitle(parent.Id);
}
// try and get the tcp port from the Win32 TcpTable API
try
{
var tcpRow = tcpTable.SingleOrDefault((r) => r.ProcessId == proc.Id && r.State == TcpState.Listen && IPAddress.IsLoopback(r.LocalEndPoint.Address));
if (tcpRow != null)
{
_port = tcpRow.LocalEndPoint.Port;
_portSet = true;
_instances.Add(new LocalInstance(parentTitle, _port, _icon));
//Log.Debug("{class} {method} PowerBI found on port: {port}", "PowerBIHelper", "Refresh", _port);
}
else
{
//Log.Debug("{class} {method} PowerBI port not found for process: {processName} PID: {pid}", "PowerBIHelper", "Refresh", proc.ProcessName, proc.Id);
}
}
catch (Exception ex)
{
//Log.Error("{class} {Method} {Error} {StackTrace}", "PowerBIHelper", "Refresh", ex.Message, ex.StackTrace);
}
}
}
public LocalInstance(string name, int port, LocalInstanceType icon)
{
Port = port;
Type = icon;
try
{
var dashPos = name.LastIndexOf(" - ");
if (dashPos >= 0)
{
Name = name.Substring(0, dashPos);
} // Strip "Power BI Designer" or "Power BI Desktop" off the end of the string
else
{
//Log.Warning("{class} {method} {message} {dashPos}", "PowerBIInstance", "ctor", "Unable to find ' - ' in Power BI title", dashPos);
Name = name;
}
}
catch (Exception ex)
{
//Log.Error("{class} {method} {message} {stacktrace}", "PowerBIInstance", "ctor", ex.Message, ex.StackTrace);
Name = name;
}
}
