1 Reply Latest reply on Apr 9, 2019 9:47 AM by Andrew Waters

    Database state discovery

    Jacek Szlaczka
      Share This:



      Is it possible to discover database state with BMC Discovery/ADDM?
      Database States - SQL Server | Microsoft Docs


      I couldn't find any attribute which may be related to that in the Default Data Model, so I just would like to confirm.

        • 1. Re: Database state discovery
          Andrew Waters

          It would be possible writing a custom pattern though this information is not discovered by the standard patterns. You would need a pattern definitions block, something like

          definitions MSSQLStatus 1.0

            '''Additional SQL details.'''


            type := sql_discovery;

            group := "Microsoft SQL Server";


            define showSqlStatus

              '''Return status of databases'''


              query := "SELECT name, status FROM sys.database";

            end define;

          end definitions;

          which would then be called in a pattern.

          1 of 1 people found this helpful