• Sqler-Cmd


    针对于sqler 工具cmd 部分 做了如下整理

    1 Cluster Model

    2 Regedit Model

      

    $servers= '192.168.25.xx','192.168.25.yy'
    WfSqlerCmdGetRegdit  $servers  $WmiAccount  $WmiPassWord  'HKEY_LOCAL_MACHINE'  'SYSTEMCurrentControlSetServicesLanmanServerParameters'  

    192.168.25.xx Info: 
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParametersServiceDll REG_EXPAND_SZ:C:Windowssystem32srvsvc.dll
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParametersServiceDllUnloadOnStop REG_DWORD:1
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParametersEnableAuthenticateUserSharing REG_DWORD:0
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParametersNullSessionPipes REG_MULTI_SZ:
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParametersautodisconnect REG_DWORD:15
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParametersenableforcedlogoff REG_DWORD:1
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParametersenablesecuritysignature REG_DWORD:0
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParameters equiresecuritysignature REG_DWORD:0
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParameters estrictnullsessaccess REG_DWORD:1
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParametersLmannounce REG_DWORD:0
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParametersSize REG_DWORD:3
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParametersAdjustedNullSessionPipes REG_DWORD:3
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParametersAutoShareWks REG_DWORD:0
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParametersAutoShareServer REG_DWORD:0
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParametersGuid REG_BINARY:e5 82 40 ad 7a a 16 4e 92 da c3 93 a5 e9 e1 ba 
    192.168.25.yy Info: 
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParametersServiceDll REG_EXPAND_SZ:C:Windowssystem32srvsvc.dll
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParametersServiceDllUnloadOnStop REG_DWORD:1
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParametersEnableAuthenticateUserSharing REG_DWORD:0
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParametersNullSessionPipes REG_MULTI_SZ:
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParametersautodisconnect REG_DWORD:15
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParametersenableforcedlogoff REG_DWORD:1
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParametersenablesecuritysignature REG_DWORD:0
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParameters equiresecuritysignature REG_DWORD:0
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParameters estrictnullsessaccess REG_DWORD:1
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParametersLmannounce REG_DWORD:0
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParametersSize REG_DWORD:3
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParametersAdjustedNullSessionPipes REG_DWORD:3
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParametersGuid REG_BINARY:fc e7 9f 29 19 bb bd 42 a0 6d ed 80 fb 1b 8 d8 
    HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesLanmanServerParametersNoRemapPipes REG_MULTI_SZ:winreg svcctl eventlog

    3 HBA Model

    WFSqlerCmdGetHbaInfo $servers  $WmiAccount $WmiPassWord 

    ----'192.168.xx.18' errorinfo Begin:03/11/2013 21:06:34------
    Not supported 
    ----'192.168.xx.18' errorinfo Begin:03/11/2013 21:06:34------
    ---'192.168.xx.33'Hbainfo----'


    Server : 192.168.xx.33
    NodeWWN : 20-00-00-24-FF-08-9E-F2
    portwwn : 21-00-00-24-FF-08-9E-F2
    PortState : 2
    PortSpeed : 16
    PortSupportedSpeed : 26
    NodeSymbolicName : QLE2560 FW:v5.04.04 DVR:v9.1.9.27
    ModelDescription : QLogic QLE2560 Fibre Channel Adapter
    OptionROMVersion : 2.16
    NumberOfPorts : 1
    Model : QLE2560
    Manufacturer : QLogic Corporation
    HBAStatus : 0
    FirmwareVersion : 5.04.04
    DriverVersion : 9.1.9.27
    DriverName : ql2300.sys
    Active : True

    Server : 192.168.xx.33
    NodeWWN : 20-00-00-24-FF-08-9E-EF
    portwwn : 21-00-00-24-FF-08-9E-EF
    PortState : 2
    PortSpeed : 16
    PortSupportedSpeed : 26
    NodeSymbolicName : QLE2560 FW:v5.04.04 DVR:v9.1.9.27
    ModelDescription : QLogic QLE2560 Fibre Channel Adapter
    OptionROMVersion : 2.16
    NumberOfPorts : 1
    Model : QLE2560
    Manufacturer : QLogic Corporation
    HBAStatus : 0
    FirmwareVersion : 5.04.04
    DriverVersion : 9.1.9.27
    DriverName : ql2300.sys
    Active : True

     

    ---'192.168.xx.33'Hbainfo----'
    ---'192.168.xx.39'Hbainfo----'


    Server : 192.168.xx.39
    NodeWWN : 20-00-00-24-FF-07-2B-96
    portwwn : 21-00-00-24-FF-07-2B-96
    PortState : 2
    PortSpeed : 16
    PortSupportedSpeed : 26
    NodeSymbolicName : QLE2560 FW:v5.04.04 DVR:v9.1.9.27
    ModelDescription : QLogic QLE2560 Fibre Channel Adapter
    OptionROMVersion : 2.16
    NumberOfPorts : 1
    Model : QLE2560
    Manufacturer : QLogic Corporation
    HBAStatus : 0
    FirmwareVersion : 5.04.04
    DriverVersion : 9.1.9.27
    DriverName : ql2300.sys
    Active : True

    Server : 192.168.xx.39
    NodeWWN : 20-00-00-24-FF-07-2B-87
    portwwn : 21-00-00-24-FF-07-2B-87
    PortState : 2
    PortSpeed : 16
    PortSupportedSpeed : 26
    NodeSymbolicName : QLE2560 FW:v5.04.04 DVR:v9.1.9.27
    ModelDescription : QLogic QLE2560 Fibre Channel Adapter
    OptionROMVersion : 2.16
    NumberOfPorts : 1
    Model : QLE2560
    Manufacturer : QLogic Corporation
    HBAStatus : 0
    FirmwareVersion : 5.04.04
    DriverVersion : 9.1.9.27
    DriverName : ql2300.sys
    Active : True

     ---'192.168.xx.39'Hbainfo----'

    ---------------

     4 Domain Model

     5 File Model 

     6

  • 相关阅读:
    把一个英语句子中的单词次序颠倒后输出。例如输入“how are you”,输出“you are how”;
    个人简介
    Scala简单计算实例,其在数据分析方面的优势体会
    【转载】Hadoop分布式文件系统HDFS的工作原理详述
    RedHat Linux Shell常用命令(多数也适用于Unix和AIX)
    Hive insert into directory 命令输出的文件没有列分隔符分析和解决
    A Python example for HiveServer2
    Shell脚本,简单& 强大
    递归导致的StackOverflow的分析
    VS让人纠结的Release和网站一键发布
  • 原文地址:https://www.cnblogs.com/xwj1985/p/3754519.html
Copyright © 2020-2023  润新知