def get_queries()

in db/sqlserver_scanner.py [0:0]
30 lines of code
1 McCabe index (conditional complexity)

  def get_queries(self):
    """Gets a list of data collection queries.

    Returns:
        List of data collection queries
    """
    version_query = "select @@version as version"
    return [
      Query("SQLServer_Version", version_query),
      Query("SQLServer_DBs", "select name from sys.databases"),
      Query("SQLServer_SSISPackage", "select count(*) as ssisPackageCount from msdb.[dbo].[sysssispackages] where ownersid <>0x01"),
      Query("SQLServer_WindowsSQLLogin", "select count(*) as windowsSQLLoginCount from master..syslogins where isntname = 1 and hasaccess = 1 and loginname not like 'NT %'"),
      Query("SQLServer_StorageInGB", "select s.[name], sum ((convert(Decimal(18,2),size)*8/1024))/1024 as GB_Storage_Used from sys.master_files m join sys.databases s ON m.database_id = s.database_id group by m.database_id, s.[name]"),
      Query("SQLServer_AlwaysOn", "select CAST(coalesce(serverproperty('IsHadrEnabled') ,0) AS NVARCHAR(50)) IsHadrEnabled"),
      Query("SQLServer_FailoverCluster", "select CAST(serverproperty('IsClustered') AS NVARCHAR(50)) [IsClustered]"),
      Query("SQLServer_LogShipping", "exec master.sys.sp_help_log_shipping_monitor"),
      Query("SQLServer_MailInUse", "select CAST(value_in_use AS NVARCHAR(50)) DBMailEnabled from  sys.configurations where name = 'Database Mail XPs'"),
      Query("SQLServer_FileTable", "select count(*) FTDBs from sys.database_filestream_options where non_transacted_access_desc <> 'OFF'"),
      Query("SQLServer_MaintenancePlans", "select count(*) MaintPlans from msdb..sysmaintplan_plans"),
      Query("SQLServer_PolicyMgmtPolicies", "select count(*) PoliciesEnabled from msdb..syspolicy_policies where is_enabled =1"),
      Query("SQLServer_ExternalScripts", "select convert(int, value_in_use) as ExtScriptsEnabled from sys.configurations where (name collate Latin1_General_CI_AS) = 'external scripts enabled'"),
      Query("SQLServer_ComputeNodes", "select count(*) ComputeNodes from sys.dm_exec_compute_nodes"),
      Query("SQLServer_ResourceGovernorGroups", "select count(*) ResGovGroups from sys.resource_governor_workload_groups"),
      Query("SQLServer_Audits", "select count(*) ServerAudits from sys.server_audits"),
      Query("SQLServer_ServerLevelTriggers", "select count(*) ServTriggers from sys.server_triggers"),
      Query("SQLServer_ServiceBrokerTasks", "select count(*) ServBrokerTasks from sys.dm_broker_activated_tasks"),
      Query("SQLServer_Endpoints", "select count(*) Endpoints from sys.endpoints where state =0"),
      Query("SQLServer_CDCEnabled", "select count(*) DBsWithCdc from sys.databases where is_cdc_enabled=1"),
      Query("SQLServer_CLR", "Select count(*) UserCLRObjects from sysobjects where ObjectProperty(id, 'IsMSShipped') =0 and (xtype ='FS' or type ='FT' or type ='TA' or type ='PC')"),
      Query("SQLServer_LinkedServers", "select count(*) LinkedServiers from sys.servers where is_linked = 1"),
      Query("SQLServer_ExternalAccessAssemblies", "select count(*) ExtAccAsmblyEnabled from sys.server_permissions where permission_name = 'External access assembly' and state='G'"),
      Query("SQLServer_DQSRoles", "exec sp_msforeachdb \"select '?' as dbName,  count(name) as sqlServerDQSRoleCount from [?].sys.database_principals where name like 'dqs_%'\""),
      Query("SQLServer_FilestreamGroups", "exec sp_msforeachdb \"select '?' as dbName,  count(type) as sqlServerFileStreamGroupCount  from [?].sys.filegroups Where type = 'FD'\""),
      Query("SQLServer_DCUsers", "exec sp_msforeachdb \"select '?' as dbName,  count(name) as sqlServerDCUserCount from [?].sys.database_principals where name like 'dc_%'\""),
    ]