Fazer uma PerguntaFazer uma Pergunta
 

RespondidoGet node availability using Powershell

  • segunda-feira, 22 de junho de 2009 18:48willvv Medalhas de usuárioMedalhas de usuárioMedalhas de usuárioMedalhas de usuárioMedalhas de usuário
     
    Hi

    I need to obtain the node availability information for a cluster using powershell, is there a way to get that information?

    The information I need is the same that appears on the HPC Cluster Manager, under Charts and Reports - Reports - Node Availability.

    I thought maybe the Export-HPCMetrics command would work, but it doesn't have that information.

    Thanks

Respostas

  • terça-feira, 23 de junho de 2009 2:07Zhen WEI MSFT Medalhas de usuárioMedalhas de usuárioMedalhas de usuárioMedalhas de usuárioMedalhas de usuário
     Respondido

    In V2 (Windows HPC Server 2008) the answer is yes with some dev work. You can get node's Added/Removed/Online/Offline/Reachable/Unreachable/Draining state change history from Get-HpcNodeStateHistory cmdlet, and then put together the node availability. If you are interested in the "Available" definition in HPC Server, it means a node is "Online" and "Reachable". So there is somehow tricky formula like

    sum(TheTimeANodeBecomesUnavailable - TheTimeANodeBecomesAvailable) / sum(TheTimeANodeIsRemoved - TheTimeANodeIsAdded)

    In V3 (Windows HPC Server 2008 R2) we are considering expose the hourly aggregated node availability data though reporting database view.

    Feel free to let us know if you have further questions. Thanks.

    • Sugerido como RespostaZhen WEI MSFT terça-feira, 23 de junho de 2009 2:07
    • Marcado como Respostawillvv terça-feira, 23 de junho de 2009 3:19
    •  

Todas as Respostas

  • terça-feira, 23 de junho de 2009 2:07Zhen WEI MSFT Medalhas de usuárioMedalhas de usuárioMedalhas de usuárioMedalhas de usuárioMedalhas de usuário
     Respondido

    In V2 (Windows HPC Server 2008) the answer is yes with some dev work. You can get node's Added/Removed/Online/Offline/Reachable/Unreachable/Draining state change history from Get-HpcNodeStateHistory cmdlet, and then put together the node availability. If you are interested in the "Available" definition in HPC Server, it means a node is "Online" and "Reachable". So there is somehow tricky formula like

    sum(TheTimeANodeBecomesUnavailable - TheTimeANodeBecomesAvailable) / sum(TheTimeANodeIsRemoved - TheTimeANodeIsAdded)

    In V3 (Windows HPC Server 2008 R2) we are considering expose the hourly aggregated node availability data though reporting database view.

    Feel free to let us know if you have further questions. Thanks.

    • Sugerido como RespostaZhen WEI MSFT terça-feira, 23 de junho de 2009 2:07
    • Marcado como Respostawillvv terça-feira, 23 de junho de 2009 3:19
    •  
  • terça-feira, 23 de junho de 2009 3:20willvv Medalhas de usuárioMedalhas de usuárioMedalhas de usuárioMedalhas de usuárioMedalhas de usuário
     
    Thanks for your answer, I guess I'll have to do that...

    And what do you mean by "through reporting database view"? is there any reporting db that I can access directly from code?

    Thanks
  • domingo, 5 de julho de 2009 17:36Zhen WEI MSFT Medalhas de usuárioMedalhas de usuárioMedalhas de usuárioMedalhas de usuárioMedalhas de usuário
     
    Yes, we are considering to expose a reporting database view schema of SQL Server, so that you can query it from any SQL client, including your code of course.