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

    Database state discovery

    Jacek Szlaczka
      Share This:

      Hi,

       

      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