Basic troubleshooting of discovery scripts

<!--[if lt IE 9]>


Comments (3)

  1. Anonymous says:

    I wrote about basic discovery script troubleshooting here:

  2. Dominique says:


    I find this article helpful but I could not finalize the same udpate for SQL MP failing on SQL Discovery all SQL versions…

    I tried with DiscoverSQL2008DB.vbs

    Apparently it needs 7 parameters:

    ‘ Parameters that should be passed to this script
    ‘ 0 MPElement ID ({157E391B-AE98-47B4-529A-544481162729})
    ‘ 1 Target Id for ME this rule is running against ({24345584-0FD5-0FAB-2293-D4C82BEDB086})
    ‘ 2 Computer ID
    ‘ 3 Computer FQDN
    ‘ 4 SQL Connection String for the instance that the DBs are being discovered on
    ‘ 5 SQL Instance that this rule is being run for
    ‘ 6 Exlcuded database list (prefixed with Exclude:)

    I tried but nothing happened I miss 1 parameter but not sure how to do it?

    cscript /nologo DiscoverSQL2008DB.vbs {00000000-0000-0000-0000-000000000000} {00000000-0000-0000-0000-000000000000} MSQLCL1A. TRANSPLANT08 Exclude:True


  3. Dominique says:

    In progress not sure of the format for the TCP and Event ID but still trying !!!
    cscript /nologo DiscoverSQL2008DB.vbs {00000000-0000-0000-0000-000000000000} {00000000-0000-0000-0000-000000000000} Server=TRANSPLANTxxTRANSPLANTxx;Database=TRANSPLANT;User Id=zzzzzz;Password=123456789 TRANSPLANTxx Exclude:True TCP:1433
    1 but still exiting right away !!!

Skip to main content